BASE机经变形题总结.pdf

BASE机经变形题总结.pdf

《BASE机经变形题总结.pdf》由会员分享，可在线阅读，更多相关《BASE机经变形题总结.pdf（40页珍藏版）》请在冰豆网上搜索。

3/3/2015（109）QUESTION109ThecontentsoftherawdatafileEMPLOYEEarelistedbelow:

-|-10-|-20-|-30Ruth3911Jose3222Sue3033John4044ThefollowingSASprogramissubmitted:

datatest;infileemployee;inputemployee_name$1-4;ifemployee_name=Suetheninputage7-8;elseinputidnum10-11;run;WhichoneofthefollowingvaluesdoesthevariableAGEcontainwhenthenameoftheemployeeisSue?

A.30B.33C.40D.（missingnumericvalue）QUESTION110ThecontentsoftherawdatafileEMPLOYEEarelistedbelow:

-|-10-|-20-|-30Ruth3911Jose3222Sue3033John4044ThefollowingSASprogramissubmitted:

datatest;infileemployee;inputemployee_name$1-4;ifemployee_name=Ruthhtheninputidnum10-11;elseinputage7-8;runWhichoneofthefollowingvaluesdoesthevariableIDNUMcontainwhenthenameoftheemployeeisRuth?

A.11B.22（33）C.32D.（missingnumericvalue）Answer:

B机经：

正如各位前辈所言，70以及变形一定要看。

今天考到的有：

4，13，16，17，20，21（gt50），22，24，30，31，32，34，35（output变为elseoutput）,40（dowhile（prodle6）改为（dountil（prodgt6），42（变为填空，US放在了最前面），46，47，51，53，56，57，60，61，63，65，66（在第一个end后面加了output，求X值），67（ifX10thenX=1改为X=3），69，70（题目改为根据log内容，判断错误内容）70题的变型全部考到，全新题在7-8题1）ThefollowingSASprogramissubmitted:

dataWORK.TOTAL;setWORK.SALARY;byDepartmentGender;ifFirst.thenPayroll=0;Payroll+Wagerate;ifLast.;run;TheSASdatasetWORK.SALARYiscurrentlyorderedbyGenderwithinDepartment.WhichinsertedcodewillaccumulatesubtotalsforeachGenderwithinDepartment?

A.Gender_insert_code__insert_code_B.DepartmentC.GenderDepartmentD.DepartmentGenderAnswer:

A18.WhichstatementdescribesacharacteristicoftheSASautomaticvariable_ERROR_?

A.The_ERROR_variablemaintainsacountofthenumberofdataerrorsinaDATAstep.B.The_ERROR_variableisaddedtotheprogramdatavectorandbecomespartofthedatasetbeingcreated.C.The_ERROR_variablecanbeonlyusedinexpressionsintheDATAstep.D.The_ERROR_variablecontainsthenumberoftheobservationthatcausedthedataerror.Answer:

C9）ThefollowingSASprogramissubmitted:

procformat;valuescore1-50=Fail51-100=Pass;run;procreportdata=work.coursesnowd;columnexam;defineexam/displayformat=score.;run;ThevariableEXAMhasavalueof50.5.HowwilltheEXAMvariablevaluebedisplayedintheREPORTprocedureoutput?

A.FailB.PassC.50.5D.（missingnumericvalue）答案：

C19）TheSASdatasetWORK.ONEcontainsanumericvariablenamedNumandacharactervariablenamedChar:

WORK.ONENumChar-123323177ThefollowingSASprogramissubmitted:

procprintdata=WORK.ONE;whereNum=1;Num=contain

（1）;没contain这个函数run;Whatisoutput?

A.NumChar-123B.NumChar-123177C.NumChar-123323177D.Nooutputisgenerated.Answer:

D（num+char,wherestatmentcannotwork）21）GiventheSASdatasetWORK.PRODUCTS:

ProdIdPriceProductTypeSalesReturns-K12S95.50OUTDOOR152B132S2.99CLOTHING30010R18KY251.99EQUIPMENT2553KL8BY6.39OUTDOOR12515DY65DW5.60OUTDOOR455DGTY2334.55EQUIPMENT672ThefollowingSASprogramissubmitted:

dataWORK.OUTDOORWORK.CLOTHWORK.EQUIP;setWORK.PRODUCTS;ifSalesGT50;ifProductTypeEQOUTDOORthenoutputWORK.OUTDOOR;elseifProductTypeEQCLOTHINGthenoutputWORK.CLOTH;elseifProductTypeEQEQUIPMENTthenoutputWORK.EQUIP;run;HowmanyobservationsdoestheWORK.OUTDOORdatasetcontain?

A.1B.2C.3D.6Answer:

B27.GiventheSASdatasetWORK.TEMPS:

DayMonthTemp-1May7515May7015June803June762July8514July89Thefollowingprogramissubmitted:

procsortdata=WORK.TEMPS;bydescendingMonthDaybydaydescendingMonth;run;procprintdata=WORK.TEMPS;run;WhichoutputIscorrect?

33）ThefollowingSASprogramissubmitted:

dataWORK.TEST;setWORK.PILOTS;ifJobcode=Pilot2thenDescription=SeniorPilot;elseDescription=Unknown;run;ThevalueforthevariableJobcodeis:

PILOT2.WhatisthevalueofthevariableDescription?

A.PILOT2B.UnknownC.SeniorPilotD.（missingcharactervalue）Answer:

B35）xy521356题目改成了，ifx=5thenoutputone;ifylt5thenoutputtwo;elseoutputother;Howmanyobservationsineachdataset?

答案是2forone,2fortwo,1forother.35）giventheSASdatasetSASDATA.TWO:

XY-523156ThefollowingSASprogramissubmitted:

dataSASUSER.ONESASUSER.TWOOTHER;setSASDATA.TWO;ifXeq5thenoutputSASUSER.ONE;ifYlt5thenoutputSASUSER.TWO;elseoutput;run;Whatistheresult?

A.datasetSASUSER.ONEhas5observationsdatasetSASUSER.TWOhas5observationsdatasetWORK.OTHERhas3observationsB.datasetSASUSER.ONEhas2observationsdatasetSASUSER.TWOhas2observationsdatasetWORK.OTHERhas1observationsC.datasetSASUSER.ONEhas2observationsdatasetSASUSER.TWOhas2observationsdatasetWORK.OTHERhas5observationsD.Nodatasetsareoutput.TheDATAstepfailsexecutionduetosyntaxerrors.Answer:

A36）GiventhecontentsoftherawdatafileEMPLOYEE.TXT:

-+-10-+-20-+-30-Xing1922004ACCTBob5222004MKTGJorge3142004EDUCThefollowingSASprogra