資源描述:
《sas adv 真題 killtest130》由會(huì)員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫。
1、1.GiventheSASdatasetONE:ONEDIVISIONSALESA1234A3654B5678ThefollowingSASprogramissubmitted:data_null_;setone;bydivision;iffirst.divisionthendo;%letmfirst=sales;end;run;WhatisthevalueofthemacrovariableMFIRSTwhentheprogramfinishesexecution?A.1234B.5678C.nullD.sales2.Thefollowi
2、ngSASprogramissubmitted:datatemp;arraypoints{2,3}(10,15,20,25,30,35);run;WhatimpactdoestheARRAYstatementhaveintheProgramDataVector(PDV)?A.ThevariablesnamedPOINTS1,POINTS2,POINTS3,POINTS4,POINTS5,POINTS6arecreatedinthePDV.B.ThevariablesnamedPOINTS10,POINTS15,POINTS20,POINTS
3、25,POINTS30,POINTS35arecreatedinthePDV.C.ThevariablesnamedPOINTS11,POINTS12,POINTS13,POINTS21,POINTS22,POINTS23arecreatedinthePDV.D.NovariablesarecreatedinthePDV.3.GiventheSASdatasetsMATH1AandMATH1B:MATH1AMATH1BNAMEFINAMEFILaurenLSmithMPatelALaurenSChangZPatelAHillierRThef
4、ollowingSASprogramissubmitted:procsql;select*fromMATH1Aselect*fromMATH1B;quit;Thefollowingoutputisdesired:NAMEFILaurenLPatelAChangZSmithMLaurenSPatelAHillierRWhichSQLsetoperatorcompletestheprogramandgeneratesthedesiredoutput?A.APPENDCORRB.EXCEPTCORRC.OUTERUNIONCORRD.INTERS
5、ECTALLCORR4.ThefollowingSASprogramissubmitted:%lettest=one;%letone=two;%lettwo=three;%letthree=last;%putwhatdisplaysis&&&&&test;WhatiswrittentotheSASlog?A.whatdisplaysisoneB.whatdisplaysistwoC.whatdisplaysisthreeD.whatdisplaysislast5.GiventhefollowingpartialSASlog:29%macro
6、test;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;WhichSASSystemoptionwritestoth
7、eSASlogthenoteMacrovariableAresolvesto5?A.MLOGICB.MPRINTC.SYMBOLGEND.MSGLEVEL=I6.TheSASdatasetWORK.TEMPDATAcontainsthevariablesFMTNAME,START,andLABELanditconsistsof10observations.ThefollowingSASprogramissubmitted:procformatcntlin=work.tempdata;run;Whatistheresultofsubmitti
8、ngtheFORMATprocedurestep?A.Noformatsarecreatedinthisstep.B.Allformatscreatedwillbestoredi