SAS-base-考试必备-70真题(附答案)

followingSASprogramissubmitted:data;set;byDepartmentGender;ifFirst.<_insert_code_>thenPayroll=0;Payroll+Wagerate;ifLast.<_insert_code_>;run;TheSASdatasetiscurrentlyorderedbyGenderwithinDepartment.WhichinsertedcodewillaccumulatesubtotalsforeachGenderwithinDepartmentGenderDepartmentGenderDepartmentDepartmentGenderAnswer:Athefollowingrawdatarecordsin: |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:ObsNameMonthStatusWeek1Week2Week3Week4Week5ObsNameMonthStatusWeek1Week2Week3Week4Week5ifMonth='FEB'theninputWeek1Week2Week3Week4StatusifMonth='FEB'theninputWeek1Week2Week3Week4Status$;TOC\o"1-5"\h\zJohn FEB Final $13 $25 $14 $27 .John MAR Current $26 $17 $29 $11 $23Tina FEB Final $15 $18 $12 $13 .Tina MAR Current $29 $14 $19 $27 $20WhichSASprogramcorrectlyproducesthedesiredoutputdata;lengthName$4Month$3Status$7;infile''dsd;inputName$Month$;ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;formatWeek1-Week5dollar6.;run;procprintdata=;run;data;lengthName$4Month$3Status$7;infile''dlm=','missover;inputName$Month$;elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5StatuselseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;formatWeek1-Week5dollar6.;run;procprintdata=;run;data;lengthName$4Month$3Status$7;infile''dlm=',';inputName$Month$@;ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;formatWeek1-Week5dollar6.;run;procprintdata=;run;data;lengthName$4Month$3Status$7;infile''dsd@;inputName$Month$;ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;$;formatWeek1-Week5dollar6.;run;procprintdata=;run;Answer:CExcelworkbookcontainsthefollowingfourworksheets:EASTWESTNORTHSOUTHThefollowingprogramissubmitted:libnameMYXLS'';WhichPROCPRINTstepcorrectlydisplaystheNORTHworksheetprocprintdata=;run;procprintdata=$;run;procprintdata=MYXLS.'NORTH'e;run;procprintdata=MYXLS.'NORTH$'n;run;Answer:DfollowingSASprogramissubmitted:data;Day="01";Yr=1960;X=mdy(Day,01,Yr);run;WhatisthevalueofthevariableXthenumericvalue0thecharactervalue"01011960"amissingvalueduetosyntaxerrorsthestepwillnotcompilebecauseofthecharacterargumentinthemdyfunction.Answer:Astatementspecifiesthatrecords1through10aretobereadfromtherawdatafileinfile''1-10;input''stop@10;infile''obs=10;input''stop=10;Answer:C aSASprogramissubmitted,thefollowingiswrittentotheSASlog:101data;102set(keep=productmonthnum_SoldCost);103ifMonth='Jan'thenoutput;104Sales=Cost*Num_Sold;105keep=ProductSales;22ERROR22-322:Syntaxerror,expectingoneofthefollowing:!,!!,&,*,**,+,-,,<=,<>,=,>,>=,AND, EQ,GE,GT,IN,LE,LT,MAX,MIN,NE,NG,NL,NOTIN,OR,A二,|,||,~二.106run;WhatchangesshouldbemadetotheKEEPstatementtocorrecttheerrorsintheLOGkeep=(ProductSales);keepProduct,Sales;keep=Product,Sales;keepProductSales;Answer:DofthefollowingchoicesisanunacceptableODSdestinationforproducingoutputthatcanbeviewedinMicrosoftExcelMSOFFICE2KEXCELXPCSVALLWINXPAnswer:DSASdatasetnamedcontains10observationsforeachdepartment,andiscurrentlyorderedbyDepartment.ThefollowingSASprogramissubmitted:data;set(keep=DepartmentMonthlyWageRate);byDepartment;if=1thenPayroll=0;Payroll+(MonthlyWageRate*12);if=1;run;WhichstatementistrueThebystatementintheDATAstepcausesasyntaxerror.ThestatementPayroll+(MonthlyWageRate*12);inthedatastepcausesasyntaxerror.ThevaluesofthevariablePayrollrepresentthemonthlytotalforeachdepartmentinthedataset.ThevaluesofthevariablePayrollrepresentamonthlytotalforallvaluesofWAGERATEinthedataset.Answer:CfollowingSASprogramissubmitted:data;Cost='$20,000';Discount=.10*Cost;run;WhatistheresultThevalueofthevariableDiscountintheoutputdatasetismessagesarewrittentotheSASlog.ThevalueofthevariableDiscountintheoutputdatasetisnotethatconversionhastakenplaceiswrittentotheSASlog.ThevalueofthevariableDiscountintheoutputdatasetismissing.AnoteintheSASlogreferstoinvalidnumericdata.ThevariableDiscountintheoutputdatasetissettomessagesarewrittentotheSASlog.Answer:C因为有一个 $符号theexistingSASprogram:procformat;valueagegrplow-12='Pre-Teen'13-high='Teen';run;procmeansdata=;varHeight;Answer:CAnswer:CclassSexAge;formatAgeagegrp.;run;Whichstatementintheprocmeansstepneedstobemodifiedoraddedtogeneratethefollowingresults:AnalysisVariable:HeightMeanSexAgeObsMinimumMaximumMeanFPre-Teen3Teen 6MPre-Teen4Teen 6varHeight/nobsminmaxmeanmaxdec=1;procmeansdata=maxdec=1;procmeansdata=minmaxmeanmaxdec=1;outputnobsminmaxmeanmaxdec=1;Excelworkbookcontainsthefollowingthreeworksheets:JANFEBMARWhichstatementcorrectlyassignsalibraryreferencetotheExcelworkbooklibnameqtrdata'';libname''sheets=3;libnamejanfebmar'';libnamemydata''=(jan,feb,mar);Answer:AfollowingSASprogramissubmitted:data;set(keep=JanptFebptMarpt);arrayDiff{3}Difcount1-Difcount3;arrayPatients{3}JanptFebptMarpt;run;WhatnewvariablesarecreatedDifcount1,Difcount2andDifcount3Diff1,Diff2andDiff3Janpt,Febpt,andMarptPatients1,Patients2andPatients3Answer:AofthefollowingprogramscorrectlyinvokestheDATAStepDebugger:datadebug;set;State=scan(cityState,2,'');ifState='NE'thendescription='Central';run;datadebugger;set;State=scan(cityState,2,'');ifState='NE'thendescription='Central';run;data/debug;set;State=scan(cityState,2,'');ifState='NE'thendescription='Central';run;data/debugger;set;State=scan(cityState,2,'');ifState='NE'thendescription='Central';run;Answer:cstatementistrueconcerningtheSASautomaticvariable_ERRORItcannotbeusedinanif/thencondition.Itcannotbeusedinanassignmentstatement.Itcanbeputintoakeepstatementorkeep=option.Itisautomaticallydropped.Answer:DfollowingSASprogramissubmitted:data;X='04jul2005'd;DayOfMonth=day(x);MonthOfYear=month(x);Year=year(x);run;WhattypesofvariablesareDayOfMonth,MonthOfYear,andYearDayOfMonth,Year,andMonthOfYeararecharacter.DayOfMonth,Year,andMonthOfYeararenumeric.

DayOfMonthandYeararenumeric.MonthOfYearischaracter.DayOfMonth,Year,andMonthOfYeararedatevalues.Answer:Bthefollowingdatastep:data;infiledatalines;inputCity$20.;ifCity='Tulsa'thenState='OK';Region='Central';ifCity='LosAngeles'thenState='CA';Region='Western';datalines;TulsaLosAngelesBangor;run;Afterdatastepexecution,whatwilldatasetcontainA.CityStateRegionCityStateRegionAnswer:AAnswer:ATulsaOKWesternLosAngelesCAWesternBangor WesternCityStateRegionTulsaOKWesternLosAngelesCAWesternBangorCityStateRegionTulsaOKCentralLosAngelesCAWesternBangorWesternD.CityStateRegion TulsaOKCentralLosCAWesternBangorstatementdescribesacharacteristicoftheSASautomaticvariable_ERROR_The_ERRORv_ariablemaintainsacountofthenumberofdataerrorsinaDATAstep.The_ERROR_variableisaddedtotheprogramdatavectorandbecomespartofthedatasetbeingcreated.The_ERRORv_ariablecanbeusedinexpressionsintheDATAstep.The_ERRORv_ariablecontainsthenumberoftheobservationthatcausedthedataerror.Answer:CSASdatasetcontainsanumericvariablenamedNumandacharactervariablenamedChar:NumChar 123323177ThefollowingSASprogramissubmitted:procprintdata=;whereNum='1';run;WhatisoutputTOC\o"1-5"\h\zNumChar 1 23NumChar 1 231 77NumChar 1 233 231 77Nooutputisgenerated.Answer:D

ThedatasethasthevariableLocalFeewithaformatof9.andavariableCountryFeewithaformatof7.;ThefollowingSASprogramissubmitted:data;formatLocalFeeCountryFee;set;LocalFee=LocalFee/100;CountryFee=CountryFee/100;run;WhataretheformatsofthevariablesLOCALFEEandCOUNTRYFEinEtheoutputdatasetLocalFeehasformatof9.andCountryFeehasaformatof7.LocalFeehasformatof9.andCountryFeehasaformatofBothLocalFeeandCountryFeehaveaformatofThedatastepfailsexecution;thereisnoformatforLocalFee.Answer:CtheSASdataset:ProdIdPriceProductTypeSalesReturnsK12SOUTDOOR15 2B132SCLOTHING300 10R18KY2EQUIPMENT253KL8BYOUTDOOR12515DY65DWOUTDOOR45 5DGTY23EQUIPMENT67 2ThefollowingSASprogramissubmitted:data;set;ifSalesGT30;ifProductTypeEQ'OUTDOOR'thenoutput;elseifProductTypeEQ'CLOTHING'thenoutput;elseifProductTypeEQ'EQUIPMENT'thenoutput;run;Howmanyobservationsdoesthedatasetcontain1236Answer:BstepdisplaysalistingofallthedatasetsintheWORKlibraryproccontentslib=WORKrun;proccontentslib=;run;proccontentsdata=;run;proccontentsdata=WORK_ALL_;run;Answer:cisavalidLIBNAMEstatementlibname"_SAS_data_library_location_";sasdatalibname"_SAS_data_library_location_";libnamesasdata"_SAS_data_library_location_";libnamesasdatasas"_SAS_data_library_location_";Answer:Cthefollowingrawdatarecords: |10---| 20---|30Susan*12/29/1970*10Michael**6Thefollowingoutputisdesired:Obsemployeebdateyears1Susan4015102Michael. 6WhichSASprogramcorrectlyreadsintherawdatadataemployees;infile'filespecification'dlm='*';inputemployee$bdate:mmddyy10.years;run;dataemployees;infile'filespecification'dsd='*';inputemployee$bdatemmddyy10.years;run;dataemployees;infile'filespecification'dlmdsd;inputemployee$bdatemmddyy10.years;run;dataemployees;infile'filespecification'dlm='*'dsd;inputemployee$bdate:mmddyy10.years;run;Answer:Dthefollowingcode:procprintdata=(firstobs=5obs=15);whereSex='M';run;Howmanyobservationswillbedisplayed111510orfewer11orfewerAnswer:DstepsortstheobservationsofapermanentSASdatasetbytwovariablesandstoresthesortedobservationsinatemporarySASdatasetprocsortout=EMPLOYEESdata=EMPSORT;byLnameandFname;run;procsortdata=out=EMPSORT;byLnameFname;run;procsortout=data=;byLnameFname;run;D.procsortdata=out=;byLnameandFname;run;Answer:BtheSASdataset:DayMonthTemp 1May7515May7015June803June762July8514July89Thefollowingprogramissubmitted:procsortdata=;bydescendingMonthDay;run;procprintdata=;run;WhichoutputiscorrectA.ObsDayMonthTemp 1 2July85TOC\o"1-5"\h\z14 July 893 June 7615 June 801 May 7515 May 7ObsDayMonthTemp 1 May 752July 853 June 7614July 8915 May 7015 June 80ObsDayMonthTemp 1 May 7515 May 703 June 764 15June805 2July856 14July89TempObsDayMonthTemp TOC\o"1-5"\h\z15 May 701 May 7515June803 June 7614 July 892July85Answer:CtheSASdataset:LocationPop2000Alaska626931Delaware783595Vermont608826Wyoming493782andtheSASdatasetStatePop2008Alaska686293Delaware873092Wyoming532668Thefollowingoutputisdesired:ObsStatePop2000Pop2008DifferenceTOC\o"1-5"\h\z1Alaska626931 686293 593622Delaware783595 873092 894973Wyoming493782 532668 38886WhichSASprogramcorrectlycombinesthedatadatacompare;merge(in=_aLocation=State)(in=_b);byState;if_aand_b;Difference=Pop2008-Pop2000;run;datacompare;merge(rename=(Location=State));byState;if_aand_b;Difference=Pop2008-Pop2000;run;datacompare;merge(in=_arename=(Location=State))(in=_b);byState;if_aand_b;Difference=Pop2008-Pop2000;run;datacompare;merge(in=_a)(rename=(Location=State))(in=_b);byState;if_aand_b;Difference=Pop2008-Pop2000;run;Answer:CfollowingSASprogramissumbitted:data;infile'';input@1Company$20.@25State$2.@;ifState=''theninput@30Year;elseinput@30CityYear;inputNumEmployees;run;HowmanyrawdatarecordsarereadduringeachiterationoftheDATAstep1234Answer:A'reattemptingtoreadarawdatafileandyouseethefollowingmessagesdisplayedintheSASLog:NOTE:InvaliddataforSalaryinline415-23.RULE: +1+2+3+4+5-4 120104F46#30 11MAY195433Employee_Id=120104employee_gender=FSalary=.birth_date=-2061_ERROR_=1_N_=4NOTE:20recordswerereadfromtheinfile'c:\'.Theminimumrecordlengthwas33.Themaximumrecordlengthwas33.NOTE:Thedatasethas20observationsand4variables.WhatdoesitmeanAcompilererror,triggeredbyaninvalidcharacterforthevariableSalary.Anexecutionerror,triggeredbyaninvalidcharacterforthevariableSalary.The1stofpotentiallymanyerrors,thisoneoccurringonthe4thobservation.AnerrorontheINPUTstatementspecificationforreadingthevariableSalary.Answer:B31.Giventhefollowingrawdatarecordsin: |10---|20---|30Kim,Basketball,Golf,TennisBill,FootballTracy,Soccer,TrackThefollowingprogramissubmitted:data;lengthFnameSport1-Sport3$10;infile''dlm=',';inputFname$Sport1$Sport2$Sport3$;run;procprintdata=;run;WhichoutputiscorrectbasedonthesubmittedprogramObsFnameSport1Sport2Sport3KimBasketballGolf TennisBillFootballTracySoccer TrackObsFnameSport1Sport2Sport3KimBasketballGolf TennisBillFootballFootball FootballTracySoccerTrack TrackObsFnameSport1Sport2Sport3KimBasketballGolfTennisBillFootballTracySoccerObsFnameSport1Sport2Sport3KimBasketballGolfTennisBillFootballAnswer:Cthefollowingdatastep:data;set;Count+1;run;ThevariableCountiscreatedusingasumstatement.WhichstatementregardingthisvariableistrueItisassignedavalue0whenthedatastepbeginsexecution.Itisassignedavalueofmissingwhenthedatastepbeginsexecution.Itisassignedavalue0atcompiletime.Itisassignedavalueofmissingatcompiletime.Answer:CfollowingSASprogramissubmitted:data;set;ifJobcode='Pilot2'thenDescription='SeniorPilot';elseDescription='Unknown';run;ThevalueforthevariableJobcodeis:isthevalueofthevariableDescriptionPILOT2UnknownSeniorPilot''(missingcharactervalue)Answer:Buser-definedformathasbeencreatedusingtheFORMATisitstoredA.inaSAScataloginamemoryresidentlookuptableinaSASdatasetintheWORKlibraryinaSASdatasetinapermanentSASdatalibraryAnswer:ATheseformatsmustbestoredintheorcatalog—theSASdataset:XY—523156ThefollowingSASprogramissubmitted:dataOTHER;Answer:AAnswer:Aset;ifXeq5thenoutput;ifYlt5thenoutput;output;run;Whatistheresultdatasethas5observationsdatasethas5observationsdatasethas3observationsdatasethas2observationsdatasethas2observationsdatasethas1observationsdatasethas2observationsdatasethas2observationsdatasethas5observationsNodatasetsareoutput.TheDATAstepfailsexecutionduetosyntaxerrors.thecontentsoftherawdatafile'' + 10---+ 20---+30--Xing 219 2004ACCTBob 522 2004MKTGJorge 314 2004EDUCThefollowingSASprogramissubmitted:data;infile'';input@1FirstName$@15StartDate@25Department$;run;WhichSASinformatcorrectlycompletestheprogramdate9.mmddyy10.ddmmyy10.mondayyr10.Answer:BSASdatasetcontainsavariableOpen_Datewhichhasbeenassignedapermanentlabelof"OpenDate".WhichSASprogramtemporarilyreplacesthelabel"OpenDate"withthelabel"StartingDate"intheoutput44A8211A27A.procprintdata=label;labelOpen_Date"StartingDate";run;procprintdata=label;labelOpen_Date="StartingDate";run;procprintdata=;labelOpen_Date="StartingDate";run;procprintdata=;Open_Date="StartingDate";run;Answer:B theSASdataset:XYZA33B45A52B69B70A82C91ThefollowingSASprogramissubmitted:data;set;byXY;if;run;procprintdata=noobs;run;WhichreportisproducedA.XYZ B45A52B69B704C91B.XYZ A27B45A52B69B70A82C91C.XYZ A33B45A52B69B70A82C91D.ThePRINTprocedurefailsbecausethedatasetisnotcreatedintheDATAstep.Answer:BfollowingSASprogramissubmitted:data;arrayFavorites{3}$8('Shakespeare','Hemingway','McCaffrey');run;WhatisthevalueofthesecondvariableinthedatasetHemingwayHemingwa''(amissingvalue)Theprogramcontainserrors.Novariablesarecreated.Answer:BfollowingSASprogramissubmitted:data;Prod=1;dowhile(ProdLE6);Prod+1;end;run;WhatisthevalueofthevariableProdintheoutputdataset67Answer:AAnswer:AC.8D..(missingnumeric)Answer:Btherawdatarecordinthefile: |10---|20---|30---|StevensJamesSALES304-923-372114ThefollowingSASprogramissubmitted:data;infile'';inputEmpLName$EmpFName$Dept$Phone$Extension;<_insert_code_>run;WhichSASstatementcompletestheprogramandresultsinavalueof"JamesStevens"forthevariableFullNameFullName=CATX('',EmpFName,EmpLName);FullName=CAT('',EmpFName,EmpLName);FullName=EmpFName!!EmpLName;FullName=EmpFName+EmpLName;followingSASprogramissubmitted:data;Text='Australia,US,Denmark';Pos=find(Text,'US','i',5);run;WhatvaluewillSASassigntoPos01212Answer:DtheSASdataset:order_idcustomershipped9341JoshMartin02FEB20099874RachelLords14MAR200910233TakashiSato07JUL2009Thevariableorder_idisnumeric;customerischaracter;andshippedisnumeric,containsaSASdatevalue,andisshownwiththeDATE9.format.Aprogrammerwouldliketocreateanewvariable,ship_note,thatshowsacharactervaluewiththeorder_id,shippeddate,andcustomername.Forexample,giventhefirstobservationship_notewouldhavethevalue"Order9341shippedon02FEB2009toJoshMartin".Whichofthefollowingstatementwillcorrectlycreatethevalueandassignittoship_noteship_note=catx('','Order',order_id,'shippedon',input(shipped,date9.),'to',customer);ship_note=catx('','Order',order_id,'shippedon',char(shipped,date9.),'to',customer);ship_note=catx('','Order',order_id,'shippedon',transwrd(shipped,date9.),'to',customer);ship_note=catx('','Order',order_id,'shippedon',put(shipped,date9.),'to',customer);Answer:D followingSASprogramissubmitted:dataONETWOset;run;Assumingthatexists,howmanytemporaryandpermanentSASdatasetsarecreated2temporaryand1permanentSASdatasetsarecreated3temporaryand2permanentSASdatasetsarecreated2temporaryand2permanentSASdatasetsarecreatedthereisanerrorandnonewdatasetsarecreatedAnswer:DfollowingSASprogramissubmitted:odscsvallfile='c:\';procprintdata=;varNameScoreGrade;byIdNumber;run;odscsvallclose;WhatisproducedasoutputAfilenamedthatcanonlybeopenedinExcel.AtextfilenamedthatcanbeopenedinExcelorinanytexteditor.Atextfilenamedthatcanonlybeopenedinatexteditor.AfilenamedthatcanonlybeopenedbySAS.Answer:CtheSASdataset:ObsRevenue2008Revenue2009Revenue2010ThefollowingSASprogramissubmitted:data;set;Total=mean(ofRev:);run;WhatvaluewillSASassigntoTotal3Theprogramfailstoexecuteduetoerrors.Answer:BfollowingoutputiscreatedbytheFREQUENCYprocedure:TheFREQProcedureTableofregionbyproductregionproductFrequency|Percent|RowPct|ColPct|corn|cotton|oranges|TotalTOC\o"1-5"\h\z + + + +EAST| 2 | 1 | 1 | 4|||||||||||| + + + +SOUTH| 2 | 2 | 1 | 5|||||||||||| + + + +Total4 3 2 9rowandcolumnWhichTABLESoption(s)wouldbeusedtoeliminatethecountsandjustseethefrequenciesandpercentsrowandcolumnnorowcountnocolcountfreqpercentnorownocolnocountsAnswer:CfollowingSASprogramissubmitted:WhatwillthedatasetcontainWhatwillthedatasetcontaindata;dropCity;infiledatalines;inputName$1-14/Address$1-14/City$1-12;ifCity='NewYork'theninput@1State$2.;elseinput;datalines;JoeConley123MainSt.JanesvilleWIJaneNgyuen555AlphaAve.NewYorkNYJenniferJason666Mt.DiabloEurekaCA;A.NameAddressStateJoeConley123MainSt.JaneNgyuen555AlphaAve.NYJenniferJason666Mt.DiabloNameAddressCityStateJoeC