SAS advance_在线真题试卷与模拟练习_SAS advance

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

When attempting to minimize memory usage, the most efficient way to do group processing when using the MEANS procedure is to use:

The SAS data set WORK.CHECK has a variable named Id_Code in it.
Which SQL statement would create an index on this variable?

Given the SAS data sets:

WORK.EMPLOYEE WORK.NEWEMPLOYEE

Name Dept Names Salary

------------------ -------------------

Alan Sales Michelle 50000

Michelle Sales Paresh 60000

A SAS program is submitted and the following is written to the SAS log:

101 proc sql;

102 select dept, name

103 from WORK.EMPLOYEE

104 where name=(select names

from newemployee

where salary > 40000)

ERROR: Subquery evaluated to more than one row.

105 ;

106 quit;

What would allow the program to successfully execute without errors?

与 QUESTION 16 采用类似数据集。
Given the SAS data set SASUSER.HIGHWAY:
Steering Seatbelt Speed Status Count
-----------------------------------------
Absent No 0-29 serious 31
Absent No 0-29 not 1419
Absent No 30-49 serious 191
Absent no 30-49 not 2004
Absent no 50+ serious 216
The following SAS program is submitted:
Proc sql noprint;
select distinct
Speed [INSERT SQL CLAUSE]
from SASUSER.HIGHWAY;
Quit;
Title1 "Speed values represented are: &GROUPS";
Proc print data=SASUSER.HIGHWAY;
Run;
Which SQL clause stores the text 0-29,30-49,50+ in the macro variable GROUPS?

The SAS data set WORK.CHECK has an index on the variable Code and the following SAS program is submitted.
Proc sort data=WORK.CHECK;
by Code;
Run;
Which describes the result of submitting the SAS program?

The table WORK.PILOTS contains the following data:
WORK.PILOTS
Id Name Jobcode Salary
-----------------------------
001 Albert PT1 50000
002 Brenda PT1 70000
003 Carl PT1 60000
004 Donna PT2 80000
005 Edward PT2 90000
006 Flora PT3 100000
The data set was summarized to include average salary based on jobcode:
Jobcode Salary Avg
-----------------------
PT1 50000 60000
PT1 70000 60000
PT1 60000 60000
PT2 80000 85000
PT2 90000 85000
PT3 100000 100000
Which SQL statement could NOT generate this result?

A quick rule of thumb for the space required to run PROC SORT is:

Multi-threaded processing for PROC SORT will affect which of these system resources?

Given the SAS data set WORK.TRANSACT:
Rep Cost Ship
-----------------------
SMITH 200 50
SMITH 400 20
JONES 100 10
SMITH 600 100
JONES 100 5
The following output is desired:
Rep
------------
JONES 105
SMITH 250
Which SQL statement was used?

The following SAS program is submitted:
%let Value=9;
%let Add=5;
%let Newval=%eval(&Value/&Add);
%put &Newval;
What is the value of the macro variable newval when the %PUT statement executes?

The following SAS code is submitted:
Data WORK.TEMP WORK.ERRORS / view=WORK.TEMP;
Infile RAWDATA;
Input Xa Xb Xc;
If Xa=. then output WORK.ERRORS;
Else output WORK.TEMP;
Run;
Which of the following is true of the WORK.ERRORS data set?

Which title statement would always display the current date?

Given the SAS data sets:
WORK.ONE WORK.TWO
Id Name Id Salary
----------- ---------------
112 Smith 243 150000
243 Wei 355 45000
457 Jones 523 75000
The following SAS program is submitted:
Data WORK.COMBINE;
merge WORK.ONE WORK.TWO;
by Id;
Run;
Which SQL procedure statement produces the same results?

The following SAS program is submitted:
Proc contents data=TESTDATA.ONE;
Run;
Which SQL procedure step produces similar information about the column attributes of TESTDATA.ONE?

Given the SAS data set WORK.ONE:
Rep Cost
----------------
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100
The following SAS program is submitted;
Proc sql;
Select
Rep,
Avg(Cost)
From WORK.ONE
Order by Rep
;
Quit;
Which result set would be generated?

Given the SAS data sets:
WORK.MATH1A WORK.MATH1B
Name Fi Name Fi
----------- -----------
Lauren L Smith M
Patel A Lauren L
Chang Z Patel A
Hillier R
The following SAS program is submitted:
Proc sql;
Select *
From WORK.MATH1A
[INSERT SET OPERATOR]
Select *
From WORK.MATH1B
;
Quit;
The following output is desired:
Name Fi
------------
Lauren L
Patel A
Chang Z
Hillier R
Smith M
Lauren L
Patel A
Which SQL set operator completes the program and generates the desired output?

Which of the following is an advantage of SAS views?

In what order does SAS search for format definitions by default?

Given the dataset WORK.STUDENTS:
Name Age
-------------
Mary 15
Philip 16
Robert 12
Ronald 15
The following SAS program is submitted:
%let Value=Philip;
Proc print data=WORK.STUDENTS;
[INSERT WHERE STATEMENT]
Run;
Which WHERE statement successfully completes the program and produces a report?

The following SAS program is submitted:
Data WORK.TEMP;
length A B 3 X;
infile RAWDATA;
input A B X;
Run;
What is the length of variable A?

1 2

更多题库