SASBASE123试题+答案详解

《SASBASE123试题+答案详解》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、A00-201QUESTION1InthefollowingSASprogram,theinputdatafilesaresortedbytheNAMESvariable:libnametemp'SAS-data-library';datatemp.sales;mergetemp.saleswork.receipt;bynames;run;Whichoneofthefollowingresultsoccurswhenthisprogramissubmitted?A.Theprogramexecutessuc

2、cessfullyandatemporarySASdatasetiscreated.B.TheprogramexecutessuccessfullyandapermanentSASdatasetiscreated.C.TheprogramfailsexecutionbecausethesameSASdatasetisreferencedforbothreadandwriteoperations.D.TheprogramfailsexecutionbecausetheSASdatasetsontheMERGE

3、statementareintwodifferentlibraries.Answer:BQUESTION2WhenthefollowingSASprogramissubmitted,thedatasetSASDATA.PRDSALEScontains5000observations:libnamesastemp'SAS-data-library';optionsobs=500;procprintdata=sasdata.prdsales(firsttobs=100);run;optionsobs=max;p

4、rocmeansdata=sasdata.prdsales(firsttobs=500);run;Howmanyobservationsareprocessedbyeachprocedure?A.400forPROCPRINT4500forPROCMEANSB.401forPROCPRINT4501forPROCMEANSC.401forPROCPRINT4500forPROCMEANSD.500forPROCPRINT5000forPROCMEANSAnswer:BQUESTION3Thefollowin

5、gSASprogramissubmitted:Actualtests.com-ThePowerofKnowingA00-201datawork.new;lengthword$7;amount=7;ifamount=5thenword='CAT';elseifamount=7thenword='DOG';elsework='NONE!!!';amount=5;run;WhichoneofthefollowingrepresentsthevaluesoftheAMOUNTandWORDvariables?A.a

6、mountword5DOGB.amountword5CATC.amountword7DOGD.amountword7''(missingcharactervalue)Answer:AQUESTION4WhichoneofthefollowingistrueoftheSUMstatementinaSASDATAstepprogram?A.ItisonlyvalidinconjunctionwithaSUMfunction.B.ItisnotvalidwiththeSET,MERGEandUPDATEstate

7、ments.C.Itaddsthevalueofanexpressiontoanaccumulatorvariableandignoresmissingvalues.D.ItdoesnotretaintheaccumulatorvariablevaluefromoneiterationoftheSASDATAsteptothenext.Answer:CQUESTION5ThefollowingSASprogramissubmitted:datawork.sets;dountil(prodgt6);prod+

8、1;end;run;WhichoneofthefollowingisthevalueofthevariablePRODintheoutputdataset?A.5B.6Actualtests.com-ThePowerofKnowingA00-201C.7D.8Answer:CQUESTION6ThefollowingSASprogramissubmitted:procprintdata=sasuser.house