跟crackman做sas base认证试题（70题）

1.

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;

C. Gender Department

D. Department Gender

2.

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;

run;

B.

data WORK.NUMBERS;

length Name $ 4 Month $ 3 Status $ 7;

infile ‘TEXTFILE.TXT’ dlm=‘,’ missover;

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

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

format Week1-Week5 dollar6.;

run;

proc print data=WORK.NUMBERS;

run;

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

format Week1-Week5 dollar6.;

run;

proc print data=WORK.NUMBERS;

run;

3.

3

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

EAST

The following program is submitted:

libname MYXLS ‘regions.xls’;

Which PROC PRINT step correctly displays the NORTH worksheet?

A. proc print data=MYXLS.NORTH;run;

B. proc print data=MYXLS.NORTH$;run;

C. proc print data=MYXLS.’NORTH’e;run;

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

The following SAS program is submitted:

data WORK.DATE_INFO;

Day=”01” ;

Yr=1960 ;

X=mdy(Day,01,Yr) ;

run;

What is the value of the variable X?

A. the numeric value 0

B. the character value ”01011960”

C. a missing value due to syntax errors

D. the step will not compile because of the character argument in the mdy function.

customer.txt?

A. infile ‘customer.txt’ 1-10;

B. input ‘customer.txt’ stop@10;

C. infile ‘customer.txt’ obs=10;

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;

—–

22

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

>, >=,

AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,NOTIN, OR, ^=, |, ||, ~=.

106 run;

What changes should be made to the KEEP statement to correct the errors in the LOG?

A. keep=(Product Sales);

B. keep Product, Sales;

7

Which of the following choices is an unacceptable ODS destination for producing output that can

be viewed in Microsoft Excel?

A. MSOFFICE2K

B. EXCELXP

C. CSVALL

D. WINXP

if First.Department=1 then Payroll=0;

Payroll+(MonthlyWageRate*12);

if Last.Department=1;

run;

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 WAGERATE

data course;

input exam;

datalines;

50.1

;

run;

proc format;

value score 1 – 50 = ‘Fail’

51 – 100 = ‘Pass’;

run;

B. Pass

C. 50.1

D. No output

10.

10

The following SAS program is submitted:

data WORK.RETAIL;

Cost=‘$20.000’;

Discount=.10*Cost;

run;

What is the result?

11.