SAS Base认证考试题库70题附答案Word格式.docx
- 文档编号:5258564
- 上传时间:2023-05-04
- 格式:DOCX
- 页数:50
- 大小:29.24KB
SAS Base认证考试题库70题附答案Word格式.docx
《SAS Base认证考试题库70题附答案Word格式.docx》由会员分享,可在线阅读,更多相关《SAS Base认证考试题库70题附答案Word格式.docx(50页珍藏版)》请在冰点文库上搜索。
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;
B.dataWORK.NUMBERS;
dlm='
'
missover;
C.dataWORK.NUMBERS;
inputName$Month$@;
D.dataWORK.NUMBERS;
dsd@;
3.ThefollowingSASprogramissubmitted:
dataWORK.DATE_INFO;
Day="
01"
;
Yr=1960;
X=mdy(Day,01,Yr);
WhatisthevalueofthevariableX?
A.thenumericvalue0
B.thecharactervalue"
01011960"
C.amissingvalueduetosyntaxerrors
D.thestepwillnotcompilebecauseofthecharacterargumentinthemdyfunction.
4.TheExcelworkbookREGIONS.XLScontainsthefollowingfourworksheets:
EAST
WEST
NORTH
SOUTH
Thefollowingprogramissubmitted:
libnameMYXLS'
regions.xls'
WhichPROCPRINTstepcorrectlydisplaystheNORTHworksheet?
A.procprintdata=MYXLS.NORTH;
B.procprintdata=MYXLS.NORTH$;
C.procprintdata=MYXLS.'
NORTH'
e;
D.procprintdata=MYXLS.'
NORTH$'
n;
5.Whichstatementspecifiesthatrecords1through10aretobereadfromtherawdatafilecustomer.txt?
A.infile'
customer.txt'
1-10;
B.input'
stop@10;
C.infile'
obs=10;
D.input'
stop=10;
6.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;
7.WhichofthefollowingchoicesisanunacceptableODSdestinationforproducingoutputthatcanbeviewedinMicrosoftExcel?
A.MSOFFICE2K
B.EXCELXP
C.CSVALL
D.WINXP
8.TheSASdatasetnamedWORK.SALARYcontains10observationsforeachdepartment,andiscurrentlyorderedbyDepartment.
ThefollowingSASprogramissubmitted:
setWORK.SALARY(keep=DepartmentMonthlyWageRate);
byDepartment;
ifFirst.Department=1thenPayroll=0;
Payroll+(MonthlyWageRate*12);
ifLast.Department=1;
Whichstatementistrue?
A.ThebystatementintheDATAstepcausesasyntaxerror.
B.ThestatementPayroll+(MonthlyWageRate*12);
inthedatastepcausesasyntaxerror.
C.ThevaluesofthevariablePayrollrepresentthemonthlytotalforeachdepartmentintheWORK.SALARYdataset.
D.ThevaluesofthevariablePayrollrepresentamonthlytotalforallvaluesofWAGERATEintheWORK.SALARYdataset.
9.
datacourse;
inputexam;
datalines;
50.1
procformat;
valuescore1–50=‘Fail’
51–100=‘Pass’;
procreportdata=coursenowd;
columnexam;
defineexam/displayformat=score.;
Whatisthevalueforexam?
A.
Fail
B.
Pass
C.
D.
Nooutput
10.ThefollowingSASprogramissubmitted:
dataWORK.RETAIL;
Cost='
$20.000'
Discount=.10*Cost;
Whatistheresult?
A.ThevalueofthevariableDiscountintheoutputdatasetis2000.NomessagesarewrittentotheSASlog.
B.ThevalueofthevariableDiscountintheoutputdatasetis2000.AnotethatconversionhastakenplaceiswrittentotheSASlog.
C.ThevalueofthevariableDiscountintheoutputdatasetismissing.AnoteintheSASlogreferstoinvalidnumericdata.
D.ThevariableDiscountintheoutputdatasetissettozero.NomessagesarewrittentotheSASlog.
11.GiventheexistingSASprogram:
procformat;
valueagegrp
low-12='
Pre-Teen'
13-high='
Teen'
procmeansdata=SASHELP.CLASS;
varHeight;
classSexAge;
formatAgeagegrp.;
Whichstatementintheprocmeansstepneedstobemodifiedoraddedtogeneratethefollowingresults:
AnalysisVariable:
Height
N
SexAgeObsMinimumMaximumMean
------------------------------------------------------------------
FPre-Teen351.359.855.8
Teen656.566.563.0
MPre-Teen457.364.859.7
Teen662.572.066.8
--------------------------------------------------------------------
A.varHeight/nobsminmaxmeanmaxdec=1;
B.procmeansdata=SASHELP.CLASSmaxdec=1;
C.procmeansdata=SASHELP.CLASSminmaxmeanmaxdec=1;
D.outputnobsminmaxmeanmaxdec=1;
12.TheExcelworkbookQTR1.XLScontainsthefollowingthreeworksheets:
JAN
FEB
MAR
WhichstatementcorrectlyassignsalibraryreferencetotheExcelworkbook?
A.libnameqtrdata'
qtr1.xls'
B.libname'
sheets=3;
C.libnamejanfebmar'
D.libnamemydata'
WORK.heets=(jan,feb,mar);
13.ThefollowingSASprogramissubmitted:
dataWORK.TEST;
setWORK.MEASLES(keep=JanptFebptMarpt);
arrayDiff{3}Difcount1-Difcount3;
arrayPatients{3}JanptFebptMarpt;
Whatnewvariablesarecreated?
A.Difcount1,Difcount2andDifcount3
B.Diff1,Diff2andDiff3
C.Janpt,Febpt,andMarpt
D.Patients1,Patients2andPatients3
14.WhichofthefollowingprogramscorrectlyinvokestheDATAStepDebugger:
A.dataWORK.TESTdebug;
setWORK.PILOTS;
State=scan(cityState,2,'
'
);
ifState='
NE'
thendescription='
Central'
B.dataWORK.TESTdebugger;
C.dataWORK.TEST/debug;
D.dataWORK.TEST/debugger;
15.WhichstatementistrueconcerningtheSASautomaticvariable_ERROR_?
A.Itcannotbeusedinanif/thencondition.
B.Itcannotbeusedinanassignmentstatement.
C.Itcanbeputintoakeepstatementorkeep=option.
D.Itisautomaticallydropped.
16.ThefollowingSASprogramissubmitted:
X='
04jul2005'
d;
DayOfMonth=day(x);
MonthOfYear=month(x);
Year=year(x);
WhattypesofvariablesareDayOfMonth,MonthOfYear,andYear?
A.DayOfMonth,Year,andMonthOfYeararecharacter.
B.DayOfMonth,Year,andMonthOfYeararenumeric.
C.DayOfMonthandYeararenumeric.MonthOfYearischaracter.
D.DayOfMonth,Year,andMonthOfYeararedatevalues.
17.Giventhefollowingdatastep:
dataWORK.GEO;
infiledatalines;
inputCity$20.;
ifCity='
Tulsa'
then
State='
OK'
Region='
LosAngeles'
CA'
Western'
datalines;
Tulsa
LosAngeles
Bangor
Afterdatastepexecution,whatwilldatasetWORK.GEOcontain?
A.CityStateRegion
-----------------------
TulsaOKWestern
LosAngelesCAWestern
BangorWestern
B.CityStateRegion
Bangor
C.CityStateRegion
TulsaOKCentral
D.CityStateRegion
LosCAWestern
18.WhichstatementdescribesacharacteristicoftheSASautomaticvariable_ERROR_?
A.The_ERROR_variablemaintainsacountofthenumberofdataerrorsinaDATAstep.
B.The_ERROR_variableisaddedtotheprogramdatavectorandbecomespartofthedatasetbeingcreated.
C.The_ERROR_variablecanbeusedinexpressionsintheDATAstep.
D.The_ERROR_variablecontainsthenumberoftheobservationthatcausedthedataerror.
19.TheSASdatasetWORK.ONEcontainsanumericvariablenamedNumandacharactervariablenamedChar:
WORK.
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- SAS Base认证考试题库70题附答案 Base 认证 考试 题库 70 答案