SASbase70题无答案解析版适合练习.docx
《SASbase70题无答案解析版适合练习.docx》由会员分享，可在线阅读，更多相关《SASbase70题无答案解析版适合练习.docx（53页珍藏版）》请在冰豆网上搜索。
SASbase70题无答案解析版适合练习
SASBase认证考试—70题
Q1
1.ThefollowingSASprogramissubmitted:
dataWORK.TOTAL;
setWORK.SALARY;
byDepartmentGender;
ifFirst.<_insert_code_>thenPayroll=0;
Payroll+Wagerate;
ifLast.<_insert_code_>;
run;
TheSASdatasetWORK.SALARYiscurrentlyorderedbyGenderwithinDepartment.
WhichinsertedcodewillaccumulatesubtotalsforeachGenderwithinDepartment?
A.Gender
B.Department
C.GenderDepartment
D.DepartmentGender
Q2
GiventhefollowingrawdatarecordsinTEXTFILE.TXT:
----|----10---|----20---|----30
John,FEB,13,25,14,27,Final
John,MAR,26,17,29,11,23,Current
Tina,FEB,15,18,12,13,Final
Tina,MAR,29,14,19,27,20,Current
Thefollowingoutputisdesired:
ObsNameMonthStatusWeek1Week2Week3Week4Week5
1JohnFEBFinal$13$25$14$27.
2JohnMARCurrent$26$17$29$11$23
3TinaFEBFinal$15$18$12$13.
4TinaMARCurrent$29$14$19$27$20
WhichSASprogramcorrectlyproducesthedesiredoutput?
A.dataWORK.NUMBERS;
lengthName$4Month$3Status$7;
infile'TEXTFILE.TXT'dsd;
inputName$Month$;
ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;
elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;
formatWeek1-Week5dollar6.;
run;
procprintdata=WORK.NUMBERS;
run;
B.dataWORK.NUMBERS;
lengthName$4Month$3Status$7;
infile'TEXTFILE.TXT'dlm=','missover;
inputName$Month$;
ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;
elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;
formatWeek1-Week5dollar6.;
run;
procprintdata=WORK.NUMBERS;
run;
C.dataWORK.NUMBERS;
lengthName$4Month$3Status$7;
infile'TEXTFILE.TXT'dlm=',';
inputName$Month$@;
ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;
elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;
formatWeek1-Week5dollar6.;
run;
procprintdata=WORK.NUMBERS;
run;
D.dataWORK.NUMBERS;
lengthName$4Month$3Status$7;
infile'TEXTFILE.TXT'dsd@;
inputName$Month$;
ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;
elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;
formatWeek1-Week5dollar6.;
run;
procprintdata=WORK.NUMBERS;
run;
Q3
ThefollowingSASprogramissubmitted:
dataWORK.DATE_INFO;
Day="01";
Yr=1960;
X=mdy（Day,01,Yr）;
run;
WhatisthevalueofthevariableX?
A.thenumericvalue0
B.thecharactervalue"01011960"
C.amissingvalueduetosyntaxerrors
D.thestepwillnotcompilebecauseofthecharacterargumentinthemdyfunction.
Q4
TheExcelworkbookREGIONS.XLScontainsthefollowingfourworksheets:
EAST
WEST
NORTH
SOUTH
Thefollowingprogramissubmitted:
libnameMYXLS'regions.xls';
WhichPROCPRINTstepcorrectlydisplaystheNORTHworksheet?
A.procprintdata=MYXLS.NORTH;run;
B.procprintdata=MYXLS.NORTH$;run;
C.procprintdata=MYXLS.'NORTH'e;run;
D.procprintdata=MYXLS.'NORTH$'n;run;
Q5
Whichstatementspecifiesthatrecords1through10aretobereadfromtherawdatafilecustomer.txt?
A.infile'customer.txt'1-10;
B.input'customer.txt'stop@10;
C.infile'customer.txt'obs=10;
D.input'customer.txt'stop=10;
Q6
AfteraSASprogramissubmitted,thefollowingiswrittentotheSASlog:
101dataWORK.JANUARY;
102setWORK.ALLYEAR（keep=productmonthnum_SoldCost）;
103ifMonth='Jan'thenoutputWORK.JANUARY;
104Sales=Cost*Num_Sold;
105keep=ProductSales;
-----
22
ERROR22-322:
Syntaxerror,expectingoneofthefollowing:
!
!
!
&,*,**,+,-,
<=,<>,=,>,>=,
AND,EQ,GE,GT,IN,LE,LT,MAX,MIN,NE,NG,NL,
NOTIN,OR,^=,|,||,~=.
106run;
WhatchangesshouldbemadetotheKEEPstatementtocorrecttheerrorsintheLOG?
A.keep=（ProductSales）;
B.keepProduct,Sales;
C.keep=Product,Sales;
D.keepProductSales;
Q7
WhichofthefollowingchoicesisanunacceptableODSdestinationforproducingoutputthatcanbeviewedinMicrosoftExcel?
A.MSOFFICE2K
B.EXCELXP
C.CSVALL
D.WINXP
Q8
TheSASdatasetnamedWORK.SALARYcontains10observationsforeachdepartment,andiscurrentlyorderedbyDepartment.
ThefollowingSASprogramissubmitted:
dataWORK.TOTAL;
setWORK.SALARY（keep=DepartmentMonthlyWageRate）;
byDepartment;
ifFirst.Department=1thenPayroll=0;
Payroll+（MonthlyWageRate*12）;
ifLast.Department=1;
run;
Whichstatementistrue?
A.ThebystatementintheDATAstepcausesasyntaxerror.
B.ThestatementPayroll+（MonthlyWageRate*12）;inthedatastepcausesasyntaxerror.
C.ThevaluesofthevariablePayrollrepresentthemonthlytotalforeachdepartmentintheWORK.SALARYdataset.
D.ThevaluesofthevariablePayrollrepresentamonthlytotalforallvaluesofWAGERATEintheWORK.SALARYdataset.
Q9
datacourse;
inputexam;
datalines;
50.1
;
run;
procformat;
valuescore1–50=‘Fail’
51–100=‘Pass’;
run;
procreportdata=coursenowd;
columnexam;
defineexam/displayformat=score.;
run;
Whatisthevalueforexam?
A.Fail
B.Pass
C.50.1
D.Nooutput
Q10
ThefollowingSASprogramissubmitted:
dataWORK.RETAIL;
Cost='$20.000';
Discount=.10*Cost;
run;
Whatistheresult?
A.ThevalueofthevariableDiscountintheoutputdatasetis2000.NomessagesarewrittentotheSASlog.
B.ThevalueofthevariableDiscountintheoutputdatasetis2000.AnotethatconversionhastakenplaceiswrittentotheSASlog.
C.ThevalueofthevariableDiscountintheoutputdatasetismissing.AnoteintheSASlogreferstoinvalidnumericdata.
D.ThevariableDiscountintheoutputdatasetissettozero.NomessagesarewrittentotheSASlog.
Q11
GiventheexistingSASprogram:
procformat;
valueagegrp
low-12='Pre-Teen'
13-high='Teen';
run;
procmeansdata=SASHELP.CLASS;
varHeight;
classSexAge;
formatAgeagegrp.;
run;
Whichstatementintheprocmeansstepneedstobemodifiedoradded
togeneratethefollowingresults:
AnalysisVariable:
Height
N
Sex Age Obs Minimum Maximum Mean
------------------------------------------------------------------
F Pre-Teen 3 51.3 59.8 55.8
Teen 6 56.5 66.5 63.0
M Pre-Teen 4 57.3 64.8 59.7
Teen 6 62.5 72.0 66.8
--------------------------------------------------------------------
A.varHeight/nobsminmaxmeanmaxdec=1;
B.procmeansdata=SASHELP.CLASSmaxdec=1;
C.procmeansdata=SASHELP.CLASSminmaxmeanmaxdec=1;
D.outputnobsminmaxmeanmaxdec=1;
Q12
TheExcelworkbookQTR1.XLScontainsthe
followingthreeworksheets:
JAN
FEB
MAR
WhichstatementcorrectlyassignsalibraryreferencetotheExcelworkbook?
A.libnameqtrdata'qtr1.xls';
B.libname'qtr1.xls'sheets=3;
C.libnamejanfebmar'qtr1.xls';
D.libnamemydata'qtr1.xls'WORK.heets=（jan,feb,mar）;
Q13
ThefollowingSASprogramissubmitted:
dataWORK.TEST;
setWORK.MEASLES（keep=JanptFebptMarpt）;
arrayDiff{3} Difcount1-Difcount3;
arrayPatients{3}JanptFebptMarpt;
run;
Whatnewvariablesarecreated?
A.Difcount1,Difcount2andDifcount3
B.Diff1,Diff2andDiff3
C.Janpt,Febpt,andMarpt
D.Patients1,Patients2andPatients3
Q14
WhichofthefollowingprogramscorrectlyinvokestheDATAStepDebugger:
A.dataWORK.TESTdebug;
setWORK.PILOTS;
State=scan（cityState,2,''）;
ifState='NE'thendescription='Central';
run;
B.data WORK.TESTdebugger;
setWORK.PILOTS;
State=scan（cityState,2,''）;
ifState='NE'thendescription='Central';
run;
C.dataWORK.TEST/debug;
setWORK.PILOTS;
State=scan（cityState,2,''）;
ifState='NE'thendescription='Central';
run;
D.data WORK.TEST/debugger;
setWORK.PILOTS;
State=scan（cityState,2,''）;
ifState='NE'thendescription='Central';
run;
Q15
WhichstatementistrueconcerningtheSASautomaticvariable_ERROR_?
A.Itcannotbeusedinanif/thencondition.
B.Itcannotbeusedinanassignmentstatement.
C.Itcanbeputintoakeepstatementorkeep=option.
D.Itisautomaticallydropped.
Q16
ThefollowingSASprogramissubmitted:
dataWORK.DATE_INFO;
X='04jul2005'd;
DayOfMonth=day（x）;
MonthOfYear=month（x）;
Year=year（x）;
run;
WhattypesofvariablesareDayOfMonth,MonthOfYear,andYear?
A.DayOfMonth,Year,andMonthOfYeararecharacter.
B.DayOfMonth,Year,andMonthOfYeararenumeric.
C.DayOfMonthandYeararenumeric.MonthOfYearischaracter.
D.DayOfMonth,Year,andMonthOfYeararedatevalues.
Q17
Giventhefollowingdatastep:
dataWORK.GEO;
infiledatalines;
inputCity$20.;
ifCity='Tulsa'then
State='OK';
Region='Central';
ifCity='LosAngeles'then
State='CA';
Region='Western';
datalines;
Tulsa
LosAngeles
Bangor
;
run;
Afterdatastepexecution,whatwilldatasetWORK.GEOcontain?
A. City State Region
----------- ----- -------
Tulsa OK Western
LosAngeles CA Western
Bangor Western
B. City State Region
----------- ----- -------
Tulsa OK Western
LosAngeles CA Western
Bangor
C. City State Region
----------- ----- -------
Tulsa OK Central
LosAngeles CA Western
Bangor Western
D. City State Region
----------- ----- -------
升级会员 