SASADVANCE63题无问题详解版适合独立练习使用文档格式.docx
- 文档编号:18888243
- 上传时间:2023-01-02
- 格式:DOCX
- 页数:74
- 大小:28.34KB
SASADVANCE63题无问题详解版适合独立练习使用文档格式.docx
《SASADVANCE63题无问题详解版适合独立练习使用文档格式.docx》由会员分享,可在线阅读,更多相关《SASADVANCE63题无问题详解版适合独立练习使用文档格式.docx(74页珍藏版)》请在冰豆网上搜索。
ASASprogramissubmittedand
thefollowingiswrittentotheSASlog:
101procsql;
102selectdept,name
103fromWORK.EMPLOYEE
104wherename=(selectnames
fromnewemployee
wheresalary>
40000)
ERROR:
Subqueryevaluatedtomorethanonerow.
105;
106quit;
Whatwouldallowtheprogramto
successfullyexecutewithouterrors?
Replacethewhereclausewith:
whereEMPLOYEE.Name=(selectNamesdelimitedwith'
'
fromWORK.NEWEMPLOYEE
whereSalary>
40000);
Replaceline104with:
whereEMPLOYEE.Name=ANY(selectNamesseparatedwith'
fromWORK.NEWEMPLOYEE
ReplacetheequalsignwiththeINoperator.
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?
into&
GROUPS
into:
GROUPSseparatedby'
Item5of63Markitemforreview
TheSASdatasetWORK.CHECKhasanindex
onthevariableCodeandthefollowingSAS
programissubmitted.
procsortdata=WORK.CHECK;
byCode;
Whichdescribestheresultofsubmitting
theSASprogram?
TheindexonCodeisdeleted.
TheindexonCodeisupdated.
TheindexonCodeisuneffected.
Thesortdoesnotexecute.
Item6of63Markitemforreview
ThetableWORK.PILOTScontainsthefollowingdata:
WORK.PILOTS
IdNameJobcodeSalary
----------------------
001AlbertPT150000
002BrendaPT170000
003CarlPT160000
004DonnaPT280000
005EdwardPT290000
006FloraPT3100000
Thedatasetwassummarizedtoincludeaverage
salarybasedonjobcode:
JobcodeSalaryAvg
------------------
PT15000060000
PT17000060000
PT16000060000
PT28000085000
PT29000085000
PT3100000100000
WhichSQLstatementcouldNOTgenerate
thisresult?
select
Jobcode,
Salary,
avg(Salary)label='
Avg'
fromWORK.PILOTS
groupbyJobcode
orderbyId
(selectavg(Salary)
fromWORK.PILOTSasP1
whereP1.Jobcode=P2.Jobcode)asAvg
fromWORK.PILOTSasP2
fromWORK.PILOTS
groupbyJobcode)asAvg
Avg
from
WORK.PILOTS,
(select
JobcodeasJc,
avg(Salary)asAvg
groupby1)
whereJobcode=Jc
Item7of63Markitemforreview
Aquickruleofthumbforthespace
requiredtorunPROCSORTis:
twotimesthesizeoftheSASdatasetbeingsorted.
threetimesthesizeoftheSASdatasetbeingsorted.
fourtimesthesizeoftheSASdatasetbeingsorted.
fivetimesthesizeoftheSASdatasetbeingsorted.
Item8of63Markitemforreview
Multi-threadedprocessingforPROCSORTwill
effectwhichofthesesystemresources?
CPUtimewilldecrease,
wallclocktimewilldecrease
CPUtimewillincrease,
wallclocktimewillincrease
Item9of63Markitemforreview
GiventheSASdatasetWORK.TRANSACT:
RepCostShip
---------------
SMITH20050
SMITH40020
JONES10010
SMITH600100
JONES1005
Thefollowingoutputisdesired:
Rep
---------
JONES105
SMITH250
WhichSQLstatementwasused?
rep,
min(Cost+Ship)
fromWORK.TRANSACT
orderbyRep
Rep,
min(Cost,Ship)asMin
summarybyRep
min(Cost,Ship)
groupbyRep
Item10of63Markitemforreview
%letValue=9;
%letAdd=5;
%letNewval=%eval(&
Value/&
Add);
%put&
Newval;
Whatisthevalueofthemacrovariable
Newvalwhenthe%PUTstatementexecutes?
0.555
2
1.8
1
Item11of63Markitemforreview
ThefollowingSAScodeissubmitted:
dataWORK.TEMPWORK.ERRORS/view=WORK.TEMP;
infileRAWDATA;
inputXaXbXc;
ifXa=.thenoutputWORK.ERRORS;
elseoutputWORK.TEMP;
Whichofthefollowingistrueof
theWORK.ERRORSdataset?
Thedatasetiscreatedwhenthe
DATAstepissubmitted.
Thedatasetiscreatedwhentheview
TEMPisusedinanotherSASstep.
ThedatasetisnotcreatedbecausetheDATA
statementcontainsasyntaxerror.
ThedescriptorportionofWORK.ERRORSiscreated
whentheDATAstepissubmitted.
Item12of63Markitemforreview
Whichtitlestatementwouldalways
displaythecurrentdate?
title"
Todayis:
sysdate."
sysdate9."
today."
%sysfunc(today(),worddate.)"
Item13of63Markitemforreview
WORK.ONEWORK.TWO
IdNameIdSalary
------------------
112Smith243150000
243Wei35545000
457Jones52375000
dataWORK.COMBINE;
mergeWORK.ONEWORK.TWO;
byId;
WhichSQLprocedurestatementproduces
thesameresults?
createtableWORK.COMBINEas
select
Id,
Name,
Salary
WORK.ONE
fulljoin
WORK.TWO
onONE.Id=TWO.Id
coalesce(ONE.Id,TWO.Id)asId,
WORK.ONE,
whereONE.Id=TWO.Id
orderbyONE.Id
Item14of63Markitemforreview
proccontentsdata=TESTDATA.ONE;
WhichSQLprocedurestepproduces
similarinformationaboutthecolumn
attributesofTESTDATA.ONE?
procsql;
contentsfromTESTDATA.ONE;
quit;
describefromTESTDATA.ONE;
contentstableTESTDATA.ONE;
describetableTESTDATA.ONE;
Item15of63Markitemforreview
GiventheSASdatasetWORK.ONE:
RepCost
SMITH200
SMITH400
JONES100
SMITH600
ThefollowingSASprogramissubmitted;
Rep,
avg(Cost)
fromWORK.ONE
orderbyRep
Whichresultsetwouldbegenerated?
JONES280
JONES280
SMITH280
JONES600
SMITH100
JONES100
SMITH600
Item16of63Markitemforreview
WORK.MATH1AWORK.MATH1B
NameFiNameFi
-----------------
LaurenLSmithM
PatelALaurenL
ChangZPatelA
HillierR
select*
fromWORK.MATH1A
[_insert_set_operator_]
fromWORK.MATH1B
NameFi
---------
LaurenL
PatelA
ChangZ
SmithM
WhichSQLsetoperatorcompletestheprogram
andgeneratesthedesiredoutput?
appendcorr
unioncorr
outerunioncorr
intersectcorr
Item17of63Markitemforreview
Whichofthefollowingisan
advantageofSASviews?
SASviewscanaccessthemostcu
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- SASADVANCE63 问题 详解 适合 独立 练习 使用