SAS_base_70题.pdf

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

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

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;

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

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

format Week1-Week5 dollar6.;

run;

proc print data=WORK.NUMBERS;

run;

B.

data WORK.NUMBERS;

run;

proc print data=WORK.NUMBERS;

run;

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 $;

D.

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 $;

format Week1-Week5 dollar6.;

run;

proc print data=WORK.NUMBERS;

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

3.The Excel workbook REGIONS.XLS contains the following four worksheets:

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.

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

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;

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;

-----

22

ERROR 22-322: Syntax error, expecting one of the following: !,!!, &, *, **, +, -, ,

A. keep=(Product Sales);

B. keep Product, Sales;

C. keep=Product, Sales;

D. keep Product Sales;

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

7.Which of the following choices is an unacceptable ODS destination for producing

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

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:

data WORK.TOTAL;

set WORK.SALARY(keep=Department MonthlyWageRate);

by Department;

run;

Which statement is true?

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

B. The statement Payroll+(MonthlyWageRate*12); in the data step causes a

syntax error.

C. The values of the variable Payroll represent the monthly total for each

department in the WORK.SALARY data set.

D. The values of the variable Payroll represent a monthly total for all values of

50.1

;

run;

proc format;

value score 1 – 50 = ‘Fail’

51 – 100 = ‘Pass’;

run;

proc report data =course nowd;

column exam;

define exam / display format=score.;

D. No output

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

10.The following SAS program is submitted:

data WORK.RETAIL;

Cost='$20,000';

Discount=.10*Cost;

run;