资源描述：
《SAS Adv 模拟 130》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、1.GiventheSASdatasetONE:ONEDIVISIONSALESA1234A3654B5678ThefollowingSASprogramissubmitted:data_null_;setone;bydivision;iffirst.divisionthendo;%letmfirst=sales;end;run;WhatisthevalueofthemacrovariableMFIRSTwhentheprogramfinishesexecution?A.1234B.5678C.nullD.sales2.ThefollowingSASp
2、rogramissubmitted:datatemp;arraypoints{2,3}(10,15,20,25,30,35);run;WhatimpactdoestheARRAYstatementhaveintheProgramDataVector(PDV)?A.ThevariablesnamedPOINTS1,POINTS2,POINTS3,POINTS4,POINTS5,POINTS6arecreatedinthePDV.B.ThevariablesnamedPOINTS10,POINTS15,POINTS20,POINTS25,POINTS30,
3、POINTS35arecreatedinthePDV.C.ThevariablesnamedPOINTS11,POINTS12,POINTS13,POINTS21,POINTS22,POINTS23arecreatedinthePDV.D.NovariablesarecreatedinthePDV.3.GiventheSASdatasetsMATH1AandMATH1B:MATH1AMATH1B----------------------------------NAMEFINAMEFI------------------------LaurenLSmi
4、thMPatelALaurenSChangZPatelAHillierRThefollowingSASprogramissubmitted:procsql;select*fromMATH1Aselect*fromMATH1B;quit;Thefollowingoutputisdesired:NAMEFILaurenLPatelAChangZSmithMLaurenSPatelAHillierRWhichSQLsetoperatorcompletestheprogramandgeneratesthedesiredoutput?A.APPENDCORRB.
5、EXCEPTCORRC.OUTERUNIONCORRD.INTERSECTALLCORR4.ThefollowingSASprogramissubmitted:%lettest=one;%letone=two;%lettwo=three;%letthree=last;%putwhatdisplaysis&&&&&test;WhatiswrittentotheSASlog?A.whatdisplaysisoneB.whatdisplaysistwoC.whatdisplaysisthreeD.whatdisplaysislast5.Giventhefol
6、lowingpartialSASlog:29%macrotest;30%if&a=5%then%do;31procprintdata=sashelp.prdsale;32run;33%end;34%else%putaisnot5;35%mend;3637%leta=5;38%test(TEST):Beginningexecution.:MacrovariableAresolvesto5(TEST):%IFcondition&a=5isTRUE(TEST):procprintdata=sashelp.prdsale;(TEST):run;WhichSAS
7、SystemoptionwritestotheSASlogthenoteMacrovariableAresolvesto5?A.MLOGICB.MPRINTC.SYMBOLGEND.MSGLEVEL=I6.TheSASdatasetWORK.TEMPDATAcontainsthevariablesFMTNAME,START,andLABELanditconsistsof10observations.ThefollowingSASprogramissubmitted:procformatcntlin=work.tempdata;run;Whatisthe
8、resultofsubmittingtheFORMATprocedurestep?A.Nofo
