SAS ADVANCE（63题，无答案版，适合独立练习使用）(6)

set SASUSER.HIGHWAY; select(Status);

%do i=1 %to &Count;

when(\ %end;

otherwise; end; run; %mend;

%SPLIT

What macro variable reference completes the program to create the WORK.NOT and WORK.SERIOUS data sets?

A.

&Status&i

B.

&&Status&i

C.

&Status&Count

D.

&&Status&Count

Item 24 of 63 Mark item for review

The following SAS program is submitted:

%let Num1=7; %let Num2=3;

%let Result=%eval(&Num1/&Num2); %put &Result;

What is the value of the macro variable Result when the %PUT statement executes?

A. 2.3

B. 2

C.

. (missing value)

D.

2.33333333333333

Item 25 of 63 Mark item for review

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:

%macro HIGHWAY(Belt=no);

proc print data=SASUSER.HIGHWAY; where Seatbelt=\ run; %mend;

%HIGHWAY(Belt=No)

How many observations appear in the generated report?

A. 0

B. 2

C. 3

D. 5

Item 26 of 63 Mark item for review

Given the following SAS data sets:

WORK.VISIT1 WORK.VISIT2

Id Expense Id Cost --- ------- --- ---- 001 500 001 300 001 400 002 600 003 350

The following result set was summarized and consolidated using the SQL procedure:

Id Cost --- ---- 001 300 001 900 002 600 003 350

Which of the following SQL statements was most likely used to generate this result?

A. select

Id,

sum(Expense) label='COST' from WORK.VISIT1 group by 1 union all select Id,

sum(Cost) from WORK.VISIT2 group by 1 order by 1,2 ;

B. select id,

sum(expense) as COST from

WORK.VISIT1(rename=(Expense=Cost)), WORK.VISIT2

where VISIT1.Id=VISIT2.Id group by Id order by Id, Cost ;

C. select

VISIT1.Id,

sum(Cost) as Cost from

WORK.VISIT1(rename=(Expense=Cost)), WORK.VISIT2

where VISIT1.Id=VISIT2.Id group by Id order by Id, Cost ;

D. select Id,

sum(Expense) as Cost from WORK.VISIT1 group by Id outer union corr select Id,

sum(Cost) from WORK.VISIT2 group by Id order by 1,2 ;

Item 27 of 63 Mark item for review

Given the SAS data sets:

WORK.FIRST WORK.SECOND

Common X Common Y ------ -- ------ -- A 10 A 1 A 13 A 3 A 14 B 4 B 9 B 2

The following SAS program is submitted:

data WORK.COMBINE; set WORK.FIRST; set WORK.SECOND; run;

What data values are stored in data set WORK.COMBINE?

A.

Common X Y ------ -- -- A 10 1

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说教育文库SAS ADVANCE（63题，无答案版，适合独立练习使用）(6)在线全文阅读。