SASBase认证考试题库—70题（附答案）.doc

SASBase认证考试题库—70题（附答案）.DOCThefollowingSASprogramissubmitted:;;byDepartmentGender;ifFirst.<_insei1_code_>thenPayroll二0;Payroll+Wagcratc;ifLasl.<_insert_code_>;run;?:・—I—„IQ—I——20—I——30John,FEB,13,25,14,27,FinalJohn,MAR,26,17,29,11,23,CurrentTina,FEBJ5,18,12,13,FinalTina,MAR,29,14,19,27,20,CurrentThefollowingoutputisdesired:ObsNameMonthStatusWeeklWeek2Week3Week4Week51JohnFEBFinal$13$25$14$27•2JohnMARCuirent$26$17$29$11$233TinaFEBFinal$15$18$12$13•4TinaMARCuiient$29$14$19$27$20WhichSASprogramcorrectlyproducesthedesiredoutput?;lengthName$4Month$3Status$7;infile'*dsd;inputNameSMonth$;ifMonth='FEB'theninputWeeklWeek2Week3Week4Status$;else讦Month='MAR'theninputWeek1Week2Week3Week4Week5Status$;fonnatWeek1-Week5dollar6.;run;procprintdata=;run;;lengthName$4Month$3Status$7;*dlm=7missovcr;inputName$Month$;ifMonth='FEB'theninputWeeklWeek2Week3Week4Status$;elseifMonth二'MAR'theninputWeeklWeek2Week3Week4Week5Status$;foi*matWeekl-Week5dollar6.;run;procprintdata=;run;;lengthName$4Month$3Status$7;infile'*dlm=7;inputName$Month$@;ifMonth='FEB'theninputWeeklWeek2Week3Week4Status$;else讦Month二'MAR'theninputWeek1Week2Week3Week4Week5Status$;foi*matWeekl-Week5dollar6.;run;procprintdata=;run;;lengthName$4Month$3Status$7;infile'*dsd@;inputNameSMonth$;ifMonth='FEB'theninputWeeklWeek2Week3Week4Status$;else讦Month二'MAR'theninputWeek1Week2Week3Week4Week5Status$;foi*matWeekl-Week5dollar6.;run;procprintdata=;run;ThefollowingSASprogramissubmitted:;Day二”01”;Yr=1960;X=mdy(Day,01,Yr);run;WhatisthevalueofthevariableX?thenumericvalue0thecharactervalue"01011960"