BASE机经变形题总结资料下载.pdf

BASE机经变形题总结资料下载.pdf

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

WhichoneofthefollowingvaluesdoesthevariableAGEcontainwhenthenameoftheemployeeisSue?

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

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.;

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;

procreportdata=work.coursesnowd;

columnexam;

defineexam/displayformat=score.;

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;

HowmanyobservationsdoestheWORK.OUTDOORdatasetcontain?

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

B27.GiventheSASdatasetWORK.TEMPS:

DayMonthTemp-1May7515May7015June803June762July8514July89Thefollowingprogramissubmitted:

procsortdata=WORK.TEMPS;

bydescendingMonthDaybydaydescendingMonth;

procprintdata=WORK.TEMPS;

WhichoutputIscorrect?

33）ThefollowingSASprogramissubmitted:

dataWORK.TEST;

setWORK.PILOTS;

ifJobcode=Pilot2thenDescription=SeniorPilot;

elseDescription=Unknown;

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;

Whatistheresult?

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

A36）GiventhecontentsoftherawdatafileEMPLOYEE.TXT:

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