SAS base考试必备练习题.rar

1.The following SAS program is submitted:

data WORK.TOTAL;

set WORK.SALARY;

by Department Gender;

if First.<_insert_code_> then Payroll=0;

Payroll+Wagerate;

if Last.<_insert_code_>;

run;

C. Gender Department

D. Department Gender

Answer: A

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

2.Given the following raw data records in TEXTFILE.TXT:

----|----10---|----20---|----30

John,FEB,13,25,14,27,Final

John,MAR,26,17,29,11,23,Current

Tina,FEB,15,18,12,13,Final

1 John FEB Final $13 $25 $14 $27 .

2 John MAR Current $26 $17 $29 $11 $23

3 Tina FEB Final $15 $18 $12 $13 .

4 Tina MAR Current $29 $14 $19 $27 $20

Which SAS program correctly produces the desired output?

A.

data WORK.NUMBERS;

length Name $ 4 Month $ 3 Status $ 7;

infile 'TEXTFILE.TXT' dsd;

if Month='FEB' then input Week1 Week2 Week3 Week4 Status $;

format Week1-Week5 dollar6.;

run;

proc print data=WORK.NUMBERS;

run;

B.

data WORK.NUMBERS;

run;

proc print data=WORK.NUMBERS;

C.

data WORK.NUMBERS;

length Name $ 4 Month $ 3 Status $ 7;

infile 'TEXTFILE.TXT' dlm=',';

input Name $ Month $ @;

if Month='FEB' then input Week1 Week2 Week3 Week4 Status $;

else if Month='MAR' then input Week1 Week2 Week3 Week4 Week5 Status $;

data WORK.NUMBERS;

length Name $ 4 Month $ 3 Status $ 7;

infile 'TEXTFILE.TXT' dsd @;

input Name $ Month $;

if Month='FEB' then input Week1 Week2 Week3 Week4 Status $;

else if Month='MAR' then input Week1 Week2 Week3 Week4 Week5 Status $;

run;

proc print data=WORK.NUMBERS;

run;

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

EAST

WEST

NORTH

SOUTH

The following program is submitted:

D. proc print data=MYXLS.'NORTH$'n;run;

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

4.The following SAS program is submitted:

data WORK.DATE_INFO;

Day="01" ;

Yr=1960 ;

X=mdy(Day,01,Yr) ;

run;

function.

Answer: A

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

5.Which statement specifies that records 1 through 10 are to be read from the raw data

file customer.txt?

A. infile 'customer.txt' 1-10;

B. input 'customer.txt' stop@10;

C. infile 'customer.txt' obs=10;

D. input 'customer.txt' stop=10;

Answer: C

6.After a SAS program is submitted, the following is written to the SAS log:

101 data WORK.JANUARY;

102 set WORK.ALLYEAR(keep=product month num_Sold Cost);

103 if Month='Jan' then output WORK.JANUARY;

104 Sales=Cost * Num_Sold;

105 keep=Product Sales;

106 run;

LOG?

A. keep=(Product Sales);

B. keep Product, Sales;

C. keep=Product, Sales;

D. keep Product Sales;

Answer: D

B. EXCELXP

C. CSVALL

D. WINXP

Answer: D

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

8.The SAS data set named WORK.SALARY contains 10 observations for each

department,and is currently ordered by Department. The following SAS program is

submitted:

set WORK.SALARY(keep=Department MonthlyWageRate);

if First.Department=1 then Payroll=0;

Payroll+(MonthlyWageRate*12);

if Last.Department=1;

run;

Which statement is true?

A. The by statement in the DATA step causes a syntax error.

Answer: C

10.The following SAS program is submitted:

data WORK.RETAIL;

Cost='$20,000';

Discount=.10*Cost;

run;

C. The value of the variable Discount in the output data set is missing. A note in

the SAS log refers to invalid numeric data.

D. The variable Discount in the output data set is set to zero.No messages are

written to the SAS log.

11.Given the existing SAS program:

proc format;