完整版SASADVANCE63题无答案版适合独立练习使用.docx

完整版SASADVANCE63题无答案版适合独立练习使用.docx

《完整版SASADVANCE63题无答案版适合独立练习使用.docx》由会员分享，可在线阅读，更多相关《完整版SASADVANCE63题无答案版适合独立练习使用.docx（85页珍藏版）》请在冰豆网上搜索。

完整版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.

SASviewscanaccessthemostc