SAS-base-70题(无答案版-适合练习).doc

PAGE\*MERGEFORMAT34

SASBase认证考试—70题Q1
1.ThefollowingSASprogramissubmitted:
dataWORK.TOTAL;
setWORK.SALARY;
byDepartmentGender;
ifFirst.<_insert_code_>thenPayroll=0;
Payroll+Wagerate;
ifLast.<_insert_code_>;
run;
TheSASdatasetWORK.SALARYiscurrentlyorderedbyGenderwithinDepartment.
WhichinsertedcodewillaccumulatesubtotalsforeachGenderwithinDepartment?
A.Gender
B.Department
C.GenderDepartment
D.DepartmentGender
Q2
GiventhefollowingrawdatarecordsinTEXTFILE.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
Tina,MAR,29,14,19,27,20,Current
Thefollowingoutputisdesired:
ObsNameMonthStatusWeek1Week2Week3Week4Week5
1JohnFEBFinal$13$25$14$27.
2JohnMARCurrent$26$17$29$11$23
3TinaFEBFinal$15$18$12$13.
4TinaMARCurrent$29$14$19$27$20
WhichSASprogramcorrectlyproducesthedesiredoutput?
A.dataWORK.NUMBERS;
lengthName$4Month$3Status$7;
infile'TEXTFILE.TXT'dsd;
inputName$Month$;
ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;
elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;
formatWeek1-Week5dollar6.;
run;
procprintdata=WORK.NUMBERS;
run;
B.dataWORK.NUMBERS;
lengthName$4Month$3Status$7;
infile'TEXTFILE.TXT'dlm=','missover;
inputName$Month$;
ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;
elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;
formatWeek1-Week5dollar6.;
run;
procprintdata=WORK.NUMBERS;
run;
C.dataWORK.NUMBERS;
lengthName$4Month$3Status$7;
infile'TEXTFILE.TXT'dlm=',';
inputName$Month$@;
ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;
elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;
formatWeek1-Week5dollar6.;
run;
procprintdata=WORK.NUMBERS;
run;
D.dataWORK.NUMBERS;
lengthName$4Month$3Status$7;
infile'TEXTFILE.TXT'dsd@;
inputName$Month$;
ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;
elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;
formatWeek1-Week5dollar6.;
run;
procprintdata=WORK.NUMBERS;
run;

Q3
ThefollowingSASprogramissubmitted:
dataWORK.DATE_INF