SASBase认证考试70真题答案详解.docx

SASBase认证考试—70题SAS分多个认证种类:base,advanced,clinic等,但大多需要先通过base认证。但凡这类商业组织提供的考证,基本都是题库型,所以想考过难度并不大。对于只想拿SAS认证的人,如果熟练掌握网上流传甚广的sas真题70题,通过base认证基本就没问题。:;;byDepartmentGender;ifFirst.<_insert_code_>thenPayroll=0;Payroll+Wagerate;ifLast.<_insert_code_>;run;?:A本题知识点:自动变量在SAS读取数据时,在PDV过程中会产生很多自动变量,在输出的数据集中是不可见的。·:同一个BY变量(组),若新的变量值第一次出现时,。·:同一个BY变量(组),若新的变量值最后一次出现时,。另外,在BY变量右面有多个变量时,先按第一个变量排序,若第一个变量的观测存在重复时,才按第二个变量排序。Q2GiventhefollowingrawdatarecordsinTEXT:----|----10---|----20---|----30John,FEB,13,25,14,27,FinalJohn,MAR,26,17,29,11,23,CurrentTina,FEB,15,18,12,13,FinalTina,MAR,29,14,19,27,20,CurrentThefollowingoutputisdesired:ObsNameMonthStatusWeek1Week2Week3Week4Week51JohnFEBFinal$13$25$14$$26$17$29$11$233TinaFEBFinal$15$18$12$$29$14$19$27$20WhichSASprogramcorrectlyproducesthedesiredoutput?;lengthName$4Month$3Status$7;infile'TEXT'dsd;inputName$Month$;ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;formatWeek1-Week5dollar6.;run;procprintdata=;run;;lengthName$4Month$3Status$7;infile'TEXT'dlm=','missover;inputName$Month$;ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;formatWeek1-Week5dollar6.;run;procprintdata=;run;;lengthName$4Month$3Status$7;infile'TEXT'dlm=',';inputName$Month$@;ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;formatWeek1-Week5dollar6.;run;procprintdata=;run;;lengthName$4Month$3Status$7;infile'TEXT'dsd@;inputName$Month$;ifMonth='FEB'theninputWeek1W