SASADVANCE63题无问题详解版适合独立练习使用.docx
《SASADVANCE63题无问题详解版适合独立练习使用.docx》由会员分享，可在线阅读，更多相关《SASADVANCE63题无问题详解版适合独立练习使用.docx（74页珍藏版）》请在冰豆网上搜索。
SASADVANCE63题无问题详解版适合独立练习使用
Item1of63Markitemforreview
Whenattemptingtominimizememoryusage,the
mostefficientwaytodogroupprocessingwhen
usingtheMEANSprocedureistouse:
A.
theBYstatement.
B.
GROUPBYwiththeNOTSORTEDspecification.
C.
theCLASSstatement.
D.
multipleWHEREstatements.
Item2of63Markitemforreview
TheSASdatasetWORK.CHECKhasavariable
namedId_Codeinit.WhichSQLstatementwould
createanindexonthisvariable?
A.
createindexId_CodeonWORK.CHECK;
B.
createindex（Id_Code）onWORK.CHECK;
C.
makeindex=Id_CodefromWORK.CHECK;
D.
defineindex（Id_Code）inWORK.CHECK;
Item3of63Markitemforreview
GiventheSASdatasets:
WORK.EMPLOYEEWORK.NEWEMPLOYEE
NameDeptNamesSalary
---------------------------
AlanSalesMichelle50000
MichelleSalesParesh60000
ASASprogramissubmittedand
thefollowingiswrittentotheSASlog:
101procsql;
102selectdept,name
103fromWORK.EMPLOYEE
104wherename=（selectnames
fromnewemployee
wheresalary>40000）
ERROR:
Subqueryevaluatedtomorethanonerow.
105;
106quit;
Whatwouldallowtheprogramto
successfullyexecutewithouterrors?
A.
Replacethewhereclausewith:
whereEMPLOYEE.Name=（selectNamesdelimitedwith','
fromWORK.NEWEMPLOYEE
whereSalary>40000）;
B.
Replaceline104with:
whereEMPLOYEE.Name=ANY（selectNamesseparatedwith','
fromWORK.NEWEMPLOYEE
whereSalary>40000）;
C.
ReplacetheequalsignwiththeINoperator.
D.
Qualifythecolumnnameswiththetablenames.
Item4of63Markitemforreview
GiventheSASdatasetSASUSER.HIGHWAY:
SteeringSeatbeltSpeedStatusCount
---------------------------------
absentNo0-29serious31
absentNo0-29not1419
absentNo30-49serious191
absentno30-49not2004
absentno50+serious216
ThefollowingSASprogramissubmitted:
procsqlnoprint;
selectdistinct
Speed[_insert_SQL_clause_]
fromSASUSER.HIGHWAY
;
quit;
title1"Speedvaluesrepresentedare:
&GROUPS";
procprintdata=SASUSER.HIGHWAY;
run;
WhichSQLclausestoresthetext0-29,30-49,50+in
themacrovariableGROUPS?
A.
into&GROUPS
B.
into:
GROUPS
C.
into:
GROUPSseparatedby','
D.
into&GROUPSseparatedby','
Item5of63Markitemforreview
TheSASdatasetWORK.CHECKhasanindex
onthevariableCodeandthefollowingSAS
programissubmitted.
procsortdata=WORK.CHECK;
byCode;
run;
Whichdescribestheresultofsubmitting
theSASprogram?
A.
TheindexonCodeisdeleted.
B.
TheindexonCodeisupdated.
C.
TheindexonCodeisuneffected.
D.
Thesortdoesnotexecute.
Item6of63Markitemforreview
ThetableWORK.PILOTScontainsthefollowingdata:
WORK.PILOTS
IdNameJobcodeSalary
----------------------
001AlbertPT150000
002BrendaPT170000
003CarlPT160000
004DonnaPT280000
005EdwardPT290000
006FloraPT3100000
Thedatasetwassummarizedtoincludeaverage
salarybasedonjobcode:
JobcodeSalaryAvg
------------------
PT15000060000
PT17000060000
PT16000060000
PT28000085000
PT29000085000
PT3100000100000
WhichSQLstatementcouldNOTgenerate
thisresult?
A.
select
Jobcode,
Salary,
avg（Salary）label='Avg'
fromWORK.PILOTS
groupbyJobcode
orderbyId
;
B.
select
Jobcode,
Salary,
（selectavg（Salary）
fromWORK.PILOTSasP1
whereP1.Jobcode=P2.Jobcode）asAvg
fromWORK.PILOTSasP2
orderbyId
;
C.
select
Jobcode,
Salary,
（selectavg（Salary）
fromWORK.PILOTS
groupbyJobcode）asAvg
fromWORK.PILOTS
orderbyId
;
D.
select
Jobcode,
Salary,
Avg
from
WORK.PILOTS,
（select
JobcodeasJc,
avg（Salary）asAvg
fromWORK.PILOTS
groupby1）
whereJobcode=Jc
orderbyId
;
Item7of63Markitemforreview
Aquickruleofthumbforthespace
requiredtorunPROCSORTis:
A.
twotimesthesizeoftheSASdatasetbeingsorted.
B.
threetimesthesizeoftheSASdatasetbeingsorted.
C.
fourtimesthesizeoftheSASdatasetbeingsorted.
D.
fivetimesthesizeoftheSASdatasetbeingsorted.
Item8of63Markitemforreview
Multi-threadedprocessingforPROCSORTwill
effectwhichofthesesystemresources?
A.
CPUtimewilldecrease,
wallclocktimewilldecrease
B.
CPUtimewillincrease,
wallclocktimewilldecrease
C.
CPUtimewilldecrease,
wallclocktimewillincrease
D.
CPUtimewillincrease,
wallclocktimewillincrease
Item9of63Markitemforreview
GiventheSASdatasetWORK.TRANSACT:
RepCostShip
---------------
SMITH20050
SMITH40020
JONES10010
SMITH600100
JONES1005
Thefollowingoutputisdesired:
Rep
---------
JONES105
SMITH250
WhichSQLstatementwasused?
A.
select
rep,
min（Cost+Ship）
fromWORK.TRANSACT
orderbyRep
;
B.
select
Rep,
min（Cost,Ship）asMin
fromWORK.TRANSACT
summarybyRep
orderbyRep
;
C.
select
Rep,
min（Cost,Ship）
fromWORK.TRANSACT
groupbyRep
orderbyRep
;
D.
select
Rep,
min（Cost+Ship）
fromWORK.TRANSACT
groupbyRep
orderbyRep
;
Item10of63Markitemforreview
ThefollowingSASprogramissubmitted:
%letValue=9;
%letAdd=5;
%letNewval=%eval（&Value/&Add）;
%put&Newval;
Whatisthevalueofthemacrovariable
Newvalwhenthe%PUTstatementexecutes?
A.
0.555
B.
2
C.
1.8
D.
1
Item11of63Markitemforreview
ThefollowingSAScodeissubmitted:
dataWORK.TEMPWORK.ERRORS/view=WORK.TEMP;
infileRAWDATA;
inputXaXbXc;
ifXa=.thenoutputWORK.ERRORS;
elseoutputWORK.TEMP;
run;
Whichofthefollowingistrueof
theWORK.ERRORSdataset?
A.
Thedatasetiscreatedwhenthe
DATAstepissubmitted.
B.
Thedatasetiscreatedwhentheview
TEMPisusedinanotherSASstep.
C.
ThedatasetisnotcreatedbecausetheDATA
statementcontainsasyntaxerror.
D.
ThedescriptorportionofWORK.ERRORSiscreated
whentheDATAstepissubmitted.
Item12of63Markitemforreview
Whichtitlestatementwouldalways
displaythecurrentdate?
A.
title"Todayis:
&sysdate.";
B.
title"Todayis:
&sysdate9.";
C.
title"Todayis:
&today.";
D.
title"Todayis:
%sysfunc（today（）,worddate.）";
Item13of63Markitemforreview
GiventheSASdatasets:
WORK.ONEWORK.TWO
IdNameIdSalary
------------------
112Smith243150000
243Wei35545000
457Jones52375000
ThefollowingSASprogramissubmitted:
dataWORK.COMBINE;
mergeWORK.ONEWORK.TWO;
byId;
run;
WhichSQLprocedurestatementproduces
thesameresults?
A.
createtableWORK.COMBINEas
select
Id,
Name,
Salary
from
WORK.ONE
fulljoin
WORK.TWO
onONE.Id=TWO.Id
;
B.
createtableWORK.COMBINEas
select
coalesce（ONE.Id,TWO.Id）asId,
Name,
Salary
from
WORK.ONE,
WORK.TWO
whereONE.Id=TWO.Id
;
C.
createtableWORK.COMBINEas
select
coalesce（ONE.Id,TWO.Id）asId,
Name,
Salary
from
WORK.ONE
fulljoin
WORK.TWO
onONE.Id=TWO.Id
orderbyId
;
D.
createtableWORK.COMBINEas
select
coalesce（ONE.Id,TWO.Id）asId,
Name,
Salary
from
WORK.ONE,
WORK.TWO
whereONE.Id=TWO.Id
orderbyONE.Id
;
Item14of63Markitemforreview
ThefollowingSASprogramissubmitted:
proccontentsdata=TESTDATA.ONE;
run;
WhichSQLprocedurestepproduces
similarinformationaboutthecolumn
attributesofTESTDATA.ONE?
A.
procsql;
contentsfromTESTDATA.ONE;
quit;
B.
procsql;
describefromTESTDATA.ONE;
quit;
C.
procsql;
contentstableTESTDATA.ONE;
quit;
D.
procsql;
describetableTESTDATA.ONE;
quit;
Item15of63Markitemforreview
GiventheSASdatasetWORK.ONE:
RepCost
---------
SMITH200
SMITH400
JONES100
SMITH600
JONES100
ThefollowingSASprogramissubmitted;
procsql;
select
Rep,
avg（Cost）
fromWORK.ONE
orderbyRep
;
quit;
Whichresultsetwouldbegenerated?
A.
JONES280
JONES280
SMITH280
SMITH280
SMITH280
B.
JONES600
SMITH100
C.
JONES280
SMITH280
D.
JONES100
JONES100
SMITH600
SMITH600
SMITH600
Item16of63Markitemforreview
GiventheSASdatasets:
WORK.MATH1AWORK.MATH1B
NameFiNameFi
-----------------
LaurenLSmithM
PatelALaurenL
ChangZPatelA
HillierR
ThefollowingSASprogramissubmitted:
procsql;
select*
fromWORK.MATH1A
[_insert_set_operator_]
select*
fromWORK.MATH1B
;
quit;
Thefollowingoutputisdesired:
NameFi
---------
LaurenL
PatelA
ChangZ
HillierR
SmithM
LaurenL
PatelA
WhichSQLsetoperatorcompletestheprogram
andgeneratesthedesiredoutput?
A.
appendcorr
B.
unioncorr
C.
outerunioncorr
D.
intersectcorr
Item17of63Markitemforreview
Whichofthefollowingisan
advantageofSASviews?
A.
SASviewscanaccessthemostcu
升级会员 