SASbase70题无答案版,适合练习

1、SASBase认证考试一70题Ql1.ThefollowingSASprogramissubmitted:dataWORK.TOTAL;setWORK.SALARY;byDepartmentGender;ifFirst.<_insert_code_>thenPayroll=0;Payroll+Wagerate;ifLast.<insertcode>run;TheSASdatasetWORK.SALARYiscurrentlyorderedbyGenderwithinDepartment.Whichinsertedcodewillaccumulatesubtotalsfo

2、reachGenderwithinDepartment?A. GenderB. DepartmentC. GenderDepartmentD. DepartmentGenderQ2GiventhefollowingrawdatarecordsinTEXTFILE.TXT:-|-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:ObsNameMo

3、nthStatusWeeklWeek2Week3Week4Weeks1JohnFEBFinal$13$25$14$272JohnMARCurrent$26$17$29$11$233TinaFEBFinal$15$18$12$134TinaMARCurrent$29$14$19$27$20WhichSASprogramcorrectlyproducesthedesiredoutput?A. dataWORK.NUMBERS;lengthName$4Month$3Status$7;infile'TEXTFILE.TXT'dsd;inputName$Month$;ifMonth=lF

4、EB,theninputWeeklWeek2Week3Week4Status$;elseifMonth=,MAR,theninputWeeklWeek2Week3Week4Week5Status$;formatWeekl-WeekSdollarG.;run;procprintdata=WORK.NUMBERS;run;B. dataWORK.NUMBERS;lengthName$4Month$3Status$7;infile'TEXTFILE.TXT1dlm=7missover;inputName$Month$;ifMonth=lFEB,theninputWeeklWeek2Week3

5、Week4Status$;elseifMonth=,MAR,theninputWeeklWeek2Week3Week4WeeksStatus$;formatWeekl-WeekSdollar6.;run;procprintdata=WORK.NUMBERS;run;C. dataWORK.NUMBERS;lengthName$4Month$3Status$7;infile'TEXTFILE.TXT1dlm=7;inputName$Month$;ifMonth='FEB,theninputWeeklWeek2Week3Week4Status$;elseifMonth=,MAR,t

6、heninputWeeklV/eek2Week3Week4WeeksStatus$;formatWeekl-WeekSdollar6.;run;procprintdata=WORK.NUMBERS;run;D. dataWORK.NUMBERS;lengthName$4Month$3Status$7;infile'TEXTFILE.TXT'dsd;inputName$Month$;ifMonth='FEB,theninputWeeklWeek2Week3Week4Status$;elseifMonth=,MAR,theninputWeeklV/eek2Week3Week

7、4Week5Status$;formatWeekl-WeekSdollar6.;run;procprintdata=WORK.NUMBERS;run;Q3ThefollowingSASprogramissubmitted:dataWORK.DATEINFO;Day="01"Yr=1960;X=mdy(Day,01,Yr);run;WhatisthevalueofthevariableX?A. thenumericvalue0B. thecharactervalue"01011960"C. amissingvalueduetosyntaxerrorsD.

8、thestepwillnotcompilebecauseofthecharacterargumentinthemdyfunction.Q4TheExcelworkbookREGIONS.XLScontainsthefollowingfourworksheets:EASTWESTNORTHSOUTHThefollowingprogramissubmitted:libnameMYXLS'regions.xls1;WhichPROCPRINTstepcorrectlydisplaystheNORTHworksheet?A. procprintdata=MYXLS.NORTH;run;B. p

9、rocprintdata=MYXLS.NORTH$;run;C. procprintdata=MYXLS.'NORTH'e;run;D. procprintdata=MYXLS.lNORTH$,n;run;Q5Whichstatementspecifiesthatrecords1through10aretobereadfromtherawdatafilecustomer.txt?A. infile,customer.txt,1-10;B. inputcustomer.txt1stop10;C. infile'customer.txt'obs=10;D. inpu

10、t'customer.txt'stop=10;Q6AfteraSASprogramissubmitted,thefollowingiswrittentotheSASlog:101dataWORKJANUARY;102setWORK.ALLYEAR(keep=productmonthnum_SoldCost);103ifMonth='Jan'thenoutputWORKJANUARY;104Sales=Cost*Num_Sold;105keep=ProductSales;22ERROR22-322:Syntaxerror,expectingoneofthefoll

11、owing:!,!,<=,<>,=/>/>=zAND,EQGE,GT,IN,LE,LT,MAX,MIN,NE,NG,NL,NOTIN,ORJ=,I,106run;WhatchangesshouldbemadetotheKEEPstatementtocorrecttheerrorsintheLOG?A. keep=(ProductSales);B. keepProduct,Sales;C. keep=ProductzSales;D. keepProductSales;Q7WhichofthefollowingchoicesisanunacceptableODSdes

12、tinationforproducingoutputthatcanbeviewedinMicrosoftExcel?A. MSOFFICE2KB. EXCELXPC. CSVALLD. WINXPQ8TheSASdatasetnamedWORK.SALARYcontains10observationsforeachdepartment,andiscurrpntlyordprpdhyDppartmpnt.ThefollowingSASprogramissubmitted:dataWORK.TOTAL;setWORK.SALARY(keep=DepartmentMonthlyWageRate);b

13、yDepartment;ifFirst.Department=lthenPayroll=0;Payroll+(MonthlyWageRate*12);ifLast.Department=l;run;Whichstatementistrue?A. ThebystatementintheDATAstepcausesasyntaxerror.B. ThestatementPayroll+(MonthlyWageRate*12);inthedatastepcausesasyntaxerror.C. ThevaluesofthevariablePayrollrepresentthemonthlytota

14、lforeachdepartmentintheWORK.SALARYdataset.D. ThevaluesofthevariablePayrollrepresentamonthlytotalforallvaluesofWAGERATEintheWORK.SALARYdataset.Q9datacourse;inputexam;datalines;50.1run;procformat;valuescore1-50='Fail'51-100='Pass'run;procreportdata=coursenowd;columnexam;defineexam/disp

15、layformat=score.;run;Whatisthevalueforexam?A. FailB. PassC. 50.1D. NooutputQ10ThefollowingSASprogramissubmitted:dataWORK.RETAIL;Cost='$20.000,;Discount=.10*Cost;run;Whatistheresult?A. ThevalueofthevariableDiscountintheoutputdatasetis2000.NomessagesarewrittentotheSASlog.B. ThevalueofthevariableDi

16、scountintheoutputdatasetis2000.AnotethatconversionhastakenplaceiswrittentotheSASlog.C. ThevalueofthevariableDiscountintheoutputdatasetismissing.AnoteintheSASlogreferstoinvalidnumericdata.D. ThevariableDiscountintheoutputdatasetissettozero.NomessagesarewrittentotheSASlog.QUGiventheexistingSASpiogram:

17、piocfbnnat;valueagegiplow-12='Pie-Teen'13-high='Teen'cmeansdata=SASHELP.CLASS;vaiHeight;classSexAge;fbimatAgeagegip.;inn;Whichstatementinthepiocmeansstepneedstobemodified01addedtogeneratethefollowingresults:AnalysisVariable:HeiglitN'SexAgeObsMiniinuinMaxmiuniMeanFPie-Teen3

18、513Teen656.5MPie-Teen457.3Teen662.559.855.866.563.064.859.772.066.8A. vaiHeight/nobsnunmaxmeanmaxdec=l;B. piocmeansdata=SASHELP.CLASSniaxdec=l;C. piocmeansdata=SASHELP.CLASSminmaxmeanniaxdec=l;D. outputnobsimiimaxmeanmaxdec=l;Q12TheExcelworkbookQTR1.XLScontainsthefbllowmgtlueeworksheets:JANFEBMARWlu

19、chstatementconectlyassignsalibiaiyreferencetotheExcelwoikbook9A. libnameqtidata'qtrLxls'B. libnainequLxls1sheets=3;C. libnamejanfebmaxfqtrl.xlsr;D. libnamemydata'qtil.xls'WORK.heets=(jan,febanai);Q13ThefollowingSASpiogiainissubmitted:dataWORK.TEST;setWORK.MEASLES(keep=JanptFebptMarpt

20、);aiiayDiff3Difcount1-Difcount3;aiiayPatients3JanptFebptMaipt;run;Whatnewvaiiablesarecreated?A. Difcountl,Difcount2andDifcount3B. Diffl.Diff2andDiffiC. Janpt,Febpt.andMaiptD. Patients1,Patients?andPatients3Q14WhichofthefollowingprogiamsconectlyinvokestheDATAStepDebugger:A. dataWORK.TESTdebug;setWORK

21、.PILOTS;State=scan(cityState.2/f);ifState=fNE,thendescription-Centiar；run.B. dataWORK.TESTdebugger;setWORK.PILOTS,State=scan(cityState.2J*);ifState=rNE,thendesciiptiou=,Cential,;mn;C. dataWORK.TEST/debug;setWORK.PILOTS;State=scan(cityState7/f)；ifState=lNElthendescription-Centiar；nm.D. dataWORK.TEST/

22、debugger;setWORK.PILOTS,S(are=scan(ciryStare.2J*);ifState=rNE,thendescnptiou=,Cential,;am:Q15WinchstatementistineconcemingtheSASautomaticvaiiable_ERROR_?A. Itcamiotbeusedinanif/thencondition.B. Itcannotbeusedinanassignmentstatement.C. Itcanbeputintoakeepstatementoikeep=option.D. Itisautomaticallycho

23、pped.Q16ThefollowingSASpiogiamissubmitted:dataWORK.DATE_INFO;X=,04jul2005,d;DayOfMontli=day(x);MonthOfYear=inonth(x);Yeai=yeai(x);am:WhattypesofvaiiablesaieDayOfMontlhMonthOfYeai.andYear?A. DayOfMonth.Year,andMonthOfYearaiecharacter.B. DayOfMontluYeaiandMontliOfYreaiaienumenc.C. DavOfMonthandYearare

24、numeric.MonthOfYearischaracter.D. DayOfMonth.YeaiandMonthOfYeaiaiedatevalues.Q17Giventhefollowingdatastep:dataWORK.GEO;infiledatalines;inputCity$20.;ifCity=tTulsa,thenState=,OK,;Region=,Centialf;ifCity=fLosAngeles*thenState-CA1;Region=,Westein1;datalmes;TulsaLosAngelesBangoirun.Afterdatastepexecutio

25、n,whatwilldatasetWORK.GEOcontain?A. CityStateRegionTulsaOKWesternLosAngelesCAWesrernBangoiWesternB. CityStateRegionTulsaOKWesternLosAngelesCAWesternBangoiC.CityStateRegionTulsaOKCenualLosAngelesCAWesternBangoiWesternD.CitvJStateRegionTulsaOKCentialLosCAWesternBangoiQ18Winchstatementdescnbesachaiacte

26、iisticoftheSASautomaticvaiiable_ERROR_?A. The_ERROR_vanablemaintainsacountofthenumberofdataenorsinaDATAstep.B. The_ERROR_vaiiableisaddedtotheprogramdatavectoraudbecomespairofthedatasetbeingcreated.C. The_ERROR_vaiiablecanbeusedinexpressionsintheDATAstep.D. The_ERROR_variablecontainsthenumberoftheobs

27、eivationthatcausedthedataenor.Q19TheSASdatasetWORK.ONEcontamsanuiiiencvaiiablenamedNumandachaiacteivaiiablenamedChai:WORK.ONFNumChai1233231 77ThefollowingSASpiogianiissubmitted:procprintdata=WORK.ONE;vvheieNum-T;nin:Whatisoutput?A.NumChai123B. NumChai1 23177C. NumChai1 23323177D. Nooutputisgenerated

28、.Q20ThedatasetWORK.REALESTATEhasdievariableLocalFeewithafbniiatof9.andavariableCountiyFeewithafbimatof7.;ThefollowingSASpiogiamissubmitted:dataWORK.FEE_STRUCTURE,fbimatLocalFeeCountiyFeepercent7.2;setWORK.REALESTAT;LocalFee=LocalFee/100;CountiyFee=CountiyFee/100;am:WhataiethefoimatsofthevaiiablesLOC

29、ALFEEandCOUNTRYFEEuitheoutputdataset?A. LocalFeehasformatof9.andCountiyFeehasafbiniatof7.B. LocalFeehasfbimatof9.andCountiyFeehasafbiinatofpercent7.2C. BothLocalFeeandCountiyFeehaveafbimatofpercent7.2D. Thedatastepfailsexecution,thereisnofbimatfbiLocalFee.Q21GivendieSASdatasetWORK.PRODUCTS:PiodldPri

30、cePioductTypeSalesRenunsKl2s95.50OUTDOOR152B132S2.99CLOTHING30010R18KY251.99EQUIPMENT2553KL8BY6.39OUTDOOR12515DY65DW5.60OUTDOOR453DGTY2334.55EQUIPMENT672ThefollowingSASpiogianiissubmitted:dataWORK.OUTDOORWORK.CLOTHWORK.EQUIP;setWORK.PRODUCTS;ifSalesGT30;ifPioductTypeEQOUTDOOR*thenoutputWORK.OUTDOOR.

31、elseifPioductTypeEQ'CLOTHING'thenoutputWORK.CLOTH;elseifPioductTypeEQ'EQUIPMENT1thenoutputWORK.EQUIP;inn;HowmanyobseivationsdoestheWORK.OUTDOORdatasetcontam9A.1B.2C.3D.6Q22WhichstepdisplaysalistingofallthedatasetsintheWORKlibiaiy?A. pioccontentslib=WORKrun;B. pioccontentslib=WORK.all;mn;

32、C. pioccontentsdata=WORK._all_;run,D. pioccontentsdata=WORK_ALL_;nm;Q23WinchisavalidLIBNAMEstatement?A.libname"_SAS_dataibnuy_location_”;BsasdatalibnameH_SAS_data_libiaiy_locatiou_H;C. libnamesasdataH_SAS_data_libiaiy_location_H;D. libnamesasdatasasn_SAS_data_hbiaiy_location_n;Q24Giventhefollow

33、ingrawdatarecoids:|10|20|30Susan*12/29/1970*10Michael*6Thefollowingoutputisdesued:Obsemployeebdateyeais1 Susan4015102 Michael.6WhichSASprogiamconectlyleadsintherawdata?A. dataemployees;mfile'filespecification9dim-*1;inputemployee$bdate'imnddyylO.yems;inn;B. dataemployees;nifile'filespeci

34、fication'dsd-*1;inputemployee$bdateminddyylO.yeais;nm;C. dataemployees;mfile'filespecification'dimdsd;mputemployeeSbdatenunddyylO.years;run;D. dataemployees;mfile'filespecification,dim-*1dsd;inputemployeeSbdate:nunddyylO.yeais;am;Q25Giventhefollowingcode:procprimdara=SASHELP.CLASS(fi

35、isrobs=5obs=15);wheieSex='M'nin;Howmanyobseivationswillbedisplayed?A. 11'B. 15C. 10orfewerD. 11orfewerQ26WinchstepsortstheobseivationsofapemianentSASdatasetbytwovaiiablesandstoresthesoiledobseivationsinatempoiaiySASdataset?A. piocsortout=EMPLOYEESdata=EMPSORT,byLnameandFname;run.B. piocs

36、ondata=SASUSER.EMPLOYEESout=EMPSORT;byLnameFnanie;inn;C. piocsortout=SASUSER.EMPLOTEESdata=WORK.EMPSORT,byLnanieFname;run.D. piocsondata=SASUSER.EMPLOYEESout=SASUSER.EMPSORT;byLnaineandFnaine,run;Q27GiventheSASdatasetWORK.TEMPS:DayMonthTemp1May7515May7015June803June762July8514July89Thefollowingpiogi

37、amissubmitted:procsortdata=WORK.TEMPS,bydescendingMonthDay;cpnntdata=WORK.TEMPS;run.Whichoutputiscorrect?A.ObsDayMonthTemp12July85214July8933June76415June8051May75615May7B.ObsDayMonthTemp11May7522July8533June76414JulyJ89315May70615June80C.ObsDavMonthTemp11May75215May7033June76415June8052July85

38、614July89D.ObsDayMonthTemp115May7021May75315JuneSO43June76314July8962July85Q28GiventheSASdatasetWORK.P2000:LocationPop2000Alaska626931Delaware783595Vermont608826Wyonmig493782andtheSASdatasetWORK.P2008:StatePop2008Alaska686293Delaware873092Wyommg532668Thefollowingoutputisdesired:ObsStatePop2000Pop200

39、8Difference1Alaska626931686293593622Delawaie783595873092894973Wyoming49378253266838886WinchSASpiogiamconectlycombinesthedata9A.datacompare;mergeWORK.P2000(in=_aLocation=State)WORK.P2008(in=_b);byState;ifaandb;Difference=Pop2008-Pop2000;nin:B. datacoinpaie;mergeWORK.P2000(iename=(Location=State)WORK.

40、P2008;byState;ifaandb;Diffeience=Pop2008-Pop2000;nin.C. datacompare;mergeWORK.P2000(m=_aienaine=(Location=State)WORK.P2008(in=_b);byState;ifaandb;MH7Diffeience=Pop2008-Pop2000;run:D. datacompare;mergeWORK.P2000(m=_a)(rename=(Location=State)WORK.P2008(m=_b);byState;ifaandb;Diffeience=Pop2008-Pop2000;

41、run.Q29ThefollowingSASpiogiamissumbitted:dataWORK.INFO;infileDATAFILE.TXT;input1CompanyS20.25StateS2.ifState-1theninput30Year;elsemput30CityYeai;inputNumEmployees;nm.HowmanylawdatarecordsaiereadduringeachneianonofrheDATAsrep?A. 1B.2C.3D.4Q30Youfieaitemptuigtoleadaiavdatafileandyouseethefbllowmgmessa

42、gesdisplayedintheSASLog:NOTE:InvaliddatafbiSalaiyinline415-23.4120104F46#3011MAY195433Employee_Id=120104employee_gendei-FSalaiy=.biith_date=-2061_ERROR_=1_N_=4NOTE:20lecoidswerereadfiomthenifile,c:einployees.dat,.Thenuiumuinlecoidlengtliwas33.Themaximumlecoidlengthwas33.NOTE:ThedatasetWORK.EMPLOYEES

43、has20obseivationsand4vanables.Whatdoesitmean?A.Acompileienor,tnggeiedbyaninvalidcharacterfbithevanableSalaiy.B. Anexecutionenoi,tnggeiedbyaninvalidchaiacteifbithevanableSalaiy.C. The1stofpotentiallymanyeriors,tinsoneoccuningonthe4thobseivation.D. Anenoion山eINPUTstatementspecificationfoxleadingdievar

44、iableSalaiy.Q31GivendiefollowingrawdatarecordsinDATAFILE.TXT:|10I20|30Kim.BasketbalLGoltTeimisBill.FootballTiacy,SocceiTiackThefollowingpiogiainissubmitted:dataWORK.SPORTS_INFO;lengthFnameSport1-Spoit3$10;mfilefDATAFILE.TXT,dlin=7;inputFnaineSSpoitlSSport2SSpoit3$,am:piocpirntdata=WORK.SPORTS_INFO.a

45、m:Winchoutputisconectbasedouthesubmittedpiogiam?A.Sport2 Sport3Golf TeiuiisTrackObsFnaineSpoitl1 KimBasketball2 BillFootball3 TracySoccerB.ObsFnameSpoil1Sport2Spon31 KimBasketballGolfTennis2 BillFootballFootballFootball3 TiacySoccerTrackTrackC.Spoit2 Spoit3Golf TeiuiisObsFnaineSpoitl1KimBasketball4

46、BillFootballTracvSoccerD.ObsFnaineSpoitlSpoit2Spoit31 KimBasketballGolfTeiuiis2 BillFootbaUQ32Consideithefollowingdatastep:dataW0RK.NEW;setWORK.OLD;Count+1;nin;ThevanableCountiscreatedusmgasumstatement.Whichstatementregardingthisvanableistrue?A. Itisassignedavalue0whenthedatastepbeguisexecution.B. I

47、tisassignedavalueofmissingwhenthedatastepbeginsexecution.C. Itisassignedavalue0atcompiletune.D. Itisassignedavalueofmissingatcompiletime.Q33ThefollowingSASpiogianiissubmitted:dataWORK.TEST;setWORK.PILOTS;ifJobcode-Pilot21thenDescription-SenioiPilot,;elseDescription=fIInknown1;am:Thevaluefbithevanabl

48、eJobcodeis:PILOT2.WhatisthevalueofthevariableDescription?A. PILOT?B. UnknownC. SeiuoiPilotD.11(iiussingchaiacteivalue)Q34Auser-definedfbnnathasbeencreatedusuigtheFORMATpioceduie.Howisitstored?A. inaSAScatalogB. niainemoiylesideutlookuptableC. inaSASdatasetintheWORKlibiaiyD. uiaSASdatasetinapeimaiien

49、tSASdatalibiaiyQ35GiventheSASdatasetSASDATA.TWO:XY523156ThefollowingSASpiogianiissubmitted:dataSASUSER.ONESASUSER.TWOOTHER.setSASDATA.TWO;ifXeq5thenoutputSASUSER.ONE;ifYIt5thenoutputSASUSER.TWO;output;inn;Whatistheresult?A. datasetSASUSER.ONEhas5obseivationsdatasetSASUSER.TWOhas5obseivationsdatasetW

50、ORK.OTHERhas3obseivatioiisB. datasetSASUSER.ONEhas2obseivatioiisdatasetSASUSER.TWOhas2obseivatioiisdatasetWORK.OTHERhas1obseivatioiisC. datasetSASUSER.ONEhas2obseivatioiisdatasetSASUSER.TWOhas2obseivatioiisdatasetWORK.OTHERhas5obseivatioiisD. Nodatasetsaieoutput.TheDATAstepfailsexecutionduetosyntaxe

51、nois.Q36Giventhecontentsofrherawdatafile'EMPLOYEETXT'，Xing2192004ACCTBob5222004MKTGJoige3142004EDUCThefollowingSASprogramissubmitted:dataWORK.EMPLOYEE;mfile,EMPLOYEE.TXT,;input1FustName$15StanDate25Depanment$:nm.WhichSASmfbnnatcorrectlycompletestheprogram?A. date9.B. nimddyylO.C. ddnuuyylO.D

52、. mondayyrlO.Q37TheSASdatasetFed.BankscontainsavariableOpen_Datewhichhasbeeuassignedapennanentlabelof"OpenDate”.WluchSASprogramtempoianlyreplacesthelabelMOpenDate"withthelabelMStaningDate0intheoutput?A. piocpimtdata=SASUSER.HOUSESlabel;labelOpen_Date"StartingDate”；nm:B. piocprintdata=

53、SASUSER.HOUSESlabel;labelOpen_Date=HStanmgDate”；nrn,C. piocprintdata=SASUSER.HOUSES;labelOpen_Date=MStaningDate”；run;D. procprintdata=SASUSER.HOUSES;Open_Date=HStaningDate”;run.Q38GiventheSASdatasetWORK.ONE:XYZAABABBAC 11122344273345526970S?91ThefollowingSASprogianiissubmitted:dataWORK.TWO;setWORK.O

54、NE.byXY;ifFust.Y;am;procpimtdata=WORK.TWOnoobs;run;Wluchlepoitisproduced?A.XYZ-2 3 5 2 -345 -Y - A B A - ex -1122B693B704A824C91D.ThePRINTpioceduxefailsbecausethedatasetWORK.TWOisnotcreatedindieDATAstep.Q39ThefollowingSASpiogiamissubmitted:dataWORK.AUTHORS;arrayFavontes3S8(,Shakespeare,JHemmgway,/McCaffiey,);run;WhatisthevalueofthesecondvanableinthedatasetW0RK.AUTH0RS9A.HemingwayB. HemingwaC.11(amissingvalue)D.Thepiogiamcontainsenois.Novariablesaiecreated.Q40ThefollowingSASpiogiamissubmitted:dataWORK.PRODUCTS;Piod=l;dowlule(PiodLE6);Piod+1;end;am.Whatisthevalueofthevanable