搜索
Exam:A00-201Title:SASBaseProgrammingVer:11.30.06A00-201Actualtests.com-ThePowerofKnowingQUESTION1InthefollowingSASprogram,theinputdatafilesaresortedbytheNAMESvariable:libnametemp'SAS-data-library';datatemp.sales;mergetemp.saleswork.receipt;bynames;run;Whichoneofthefollowingresultsoccurswhenthisprogramissubmitted?A.TheprogramexecutessuccessfullyandatemporarySASdatasetiscreated.B.TheprogramexecutessuccessfullyandapermanentSASdatasetiscreated.C.TheprogramfailsexecutionbecausethesameSASdatasetisreferencedforbothreadandwriteoperations.D.TheprogramfailsexecutionbecausetheSASdatasetsontheMERGEstatementareintwodifferentlibraries.Answer:BQUESTION2WhenthefollowingSASprogramissubmitted,thedatasetSASDATA.PRDSALEScontains5000observations:libnamesastemp'SAS-data-library';optionsobs=500;procprintdata=sasdata.prdsales(firsttobs=100);run;optionsobs=max;procmeansdata=sasdata.prdsales(firsttobs=500);run;Howmanyobservationsareprocessedbyeachprocedure?A.400forPROCPRINT4500forPROCMEANSB.401forPROCPRINT4501forPROCMEANSC.401forPROCPRINT4500forPROCMEANSD.500forPROCPRINT5000forPROCMEANSAnswer:BQUESTION3ThefollowingSASprogramissubmitted:A00-201Actualtests.com-ThePowerofKnowingdatawork.new;lengthword$7;amount=7;ifamount=5thenword='CAT';elseifamount=7thenword='DOG';elsework='NONE!!!';amount=5;run;WhichoneofthefollowingrepresentsthevaluesoftheAMOUNTandWORDvariables?A.amountword5DOGB.amountword5CATC.amountword7DOGD.amountword7''(missingcharactervalue)Answer:AQUESTION4WhichoneofthefollowingistrueoftheSUMstatementinaSASDATAstepprogram?A.ItisonlyvalidinconjunctionwithaSUMfunction.B.ItisnotvalidwiththeSET,MERGEandUPDATEstatements.C.Itaddsthevalueofanexpressiontoanaccumulatorvariableandignoresmissingvalues.D.ItdoesnotretaintheaccumulatorvariablevaluefromoneiterationoftheSASDATAsteptothenext.Answer:CQUESTION5ThefollowingSASprogramissubmitted:datawork.sets;dountil(prodgt6);prod+1;end;run;WhichoneofthefollowingisthevalueofthevariablePRODintheoutputdataset?A.5B.6A00-201Actualtests.com-ThePowerofKnowingC.7D.8Answer:CQUESTION6ThefollowingSASprogramissubmitted:procprintdata=sasuser.houses;run;insertOPTIONSstatementhereprocmeansdata=sasuser.shoes;run;WhichoneofthefollowingOPTIONSstatementsresetsthepagenumberto1forthesecondreport?A.optionpageno=1;B.optionpagenum=1;C.optionsresetpageno=1;D.optionsresetpagenum=1;Answer:AQUESTION7ThecontentsoftherawdatafilePRODUCTarelistedbelow:----|----10---|----20---|----3024613$25.31ThefollowingSASprogramissubmitted:datainventory;infile'product';inputidnum5.@10price;run;WhichoneofthefollowingisthevalueofthePRICEvariable?A.25.31B.$25.31C..(missingnumericvalue)D.Novalueisstoredastheprogramfailstoexecuteduetoerrors.Answer:CQUESTION8ThecontentsoftherawdatafileTYPECOLORarelistedbelow:----|----10---|----20---|----30daisyyellowThefollowingSASprogramissubmitted:dataflowers;A00-201Actualtests.com-ThePowerofKnowinginfile'typecolor';inputtype$1-5+1color$;run;WhichoneofthefollowingrepresentsthevaluesofthevariablesTYPEandCOLOR?A.typecolordaisyyellowB.typecolordaisyellowC.typecolordaisyyellow(missingcharactervalue)D.Novaluesarestoredastheprogramfailstoexecuteduetosyntaxerrors.Answer:BQUESTION9Arawdatarecordislistedbelow:----|----10---|----20---|----30son,Travis,Thefollowingoutputisdesired:relationfirstnamesonTravisWhichoneofthefollowingSASprogramsreadsthedatacorrectly?A.datafamily/dlm=',';infile'file-specification';inputrelation$firstname$;run;B.optiondlm=',';datafamily;infile'file-specification';inputrelation$firstname$;run;C.datafamily;infile'file-specification'optiondlm=',';inputrelation$firstname$;run;D.datafamily;infile'file-specification';inputrelation$firstname$/dlm=',';run;Answer:CA00-201Actualtests.com-ThePowerofKnowingQUESTION10ThefollowingSASprogramissubmitted:libnamerawdata1'locationofSASdatalibrary';filenamerawdata2'locationofrawdatafile';datawork.testdata;infileinsertitemhereinputsales1salse2;run;Whichoneofthefollowingisneededtocompletetheprogramcorrectly?A.rawdata1B.rawdata2C.'rawdata1'D.'rawdata2'Answer:BQUESTION11ThefollowingSASprogramissubmittedandreads100recordsfromarawdatafile:datawork.total;infile'file-specification'end=eof;inputname$salary;totsal+salary;insertIFstatementhererun;WhichoneofthefollowingIFstatementswritesthelastobservationtotheoutputdataset?A.ifend=0;B.ifeof=0;C.ifend=1;D.ifeof=1;Answer:DQUESTION12ThecontentsoftherawdatafileFURNITUREarelistedbelow:----|----10---|----20---|----30chair,,tablechair,couch,tableThefollowingSASprogramissubmitted:datastock;infile'furniture'dsd;inputitem1$item2$item3$;run;A00-201Actualtests.com-ThePowerofKnowingWhichoneofthefollowingisthevalueofthevariablenamedITEM2inthefirstobservationoftheoutputdataset?A.tableB.,tableC..(missingnumericvalue)D.''(missingcharactervalue)Answer:DQUESTION13Arawdatafileislistedbelow:RANCH,1250,2,1,SheppardAvenue,$64,000SPLIT,1190,1,1,RandStreet,$65,850CONDO,1400,2,1.5,MarketStreet,80,050TWOSTORY,1810,4,3,GarrisStreet,$107,250RANCH,1500,3,3,KembleAvenue,$86,650SPLIT,1615,4,3,WestDrive,94,450SPLIT,1305,3,1.5,GrahamAvenue,$73,650Thefollowi