(完整版)SASADVANCE(63题,无答案版,适合独立练习使用)VIP免费

Item1of63MarkitemforreviewWhenattemptingtominimizememoryusage,themostefficientwaytodogroupprocessingwhenusingtheMEANSprocedureistouse:A.theBYstatement.B.GROUPBYwiththeNOTSORTEDspecification.C.theCLASSstatement.D.multipleWHEREstatements.Item2of63MarkitemforreviewTheSASdatasetWORK.CHECKhasavariablenamedId_Codeinit.WhichSQLstatementwouldcreateanindexonthisvariable?A.createindexId_CodeonWORK.CHECK;B.createindex(Id_Code)onWORK.CHECK;C.makeindex=Id_CodefromWORK.CHECK;D.defineindex(Id_Code)inWORK.CHECK;Item3of63MarkitemforreviewGiventheSASdatasets:WORK.EMPLOYEEWORK.NEWEMPLOYEENameDeptNamesSalary---------------------------AlanSalesMichelle50000MichelleSalesParesh60000ASASprogramissubmittedandthefollowingiswrittentotheSASlog:101procsql;102selectdept,name103fromWORK.EMPLOYEE104wherename=(selectnamesfromnewemployeewheresalary>40000)ERROR:Subqueryevaluatedtomorethanonerow.105;106quit;Whatwouldallowtheprogramtosuccessfullyexecutewithouterrors?A.Replacethewhereclausewith:whereEMPLOYEE.Name=(selectNamesdelimitedwith','fromWORK.NEWEMPLOYEEwhereSalary>40000);B.Replaceline104with:whereEMPLOYEE.Name=ANY(selectNamesseparatedwith','fromWORK.NEWEMPLOYEEwhereSalary>40000);C.ReplacetheequalsignwiththeINoperator.D.Qualifythecolumnnameswiththetablenames.Item4of63MarkitemforreviewGiventheSASdatasetSASUSER.HIGHWAY:SteeringSeatbeltSpeedStatusCount---------------------------------absentNo0-29serious31absentNo0-29not1419absentNo30-49serious191absentno30-49not2004absentno50+serious216ThefollowingSASprogramissubmitted:procsqlnoprint;selectdistinctSpeed[_insert_SQL_clause_]fromSASUSER.HIGHWAY;quit;title1"Speedvaluesrepresentedare:&GROUPS";procprintdata=SASUSER.HIGHWAY;run;WhichSQLclausestoresthetext0-29,30-49,50+inthemacrovariableGROUPS?A.into&GROUPSB.into:GROUPSC.into:GROUPSseparatedby','D.into&GROUPSseparatedby','Item5of63MarkitemforreviewTheSASdatasetWORK.CHECKhasanindexonthevariableCodeandthefollowingSASprogramissubmitted.procsortdata=WORK.CHECK;byCode;run;WhichdescribestheresultofsubmittingtheSASprogram?A.TheindexonCodeisdeleted.B.TheindexonCodeisupdated.C.TheindexonCodeisuneffected.D.Thesortdoesnotexecute.Item6of63MarkitemforreviewThetableWORK.PILOTScontainsthefollowingdata:WORK.PILOTSIdNameJobcodeSalary----------------------001AlbertPT150000002BrendaPT170000003CarlPT160000004DonnaPT280000005EdwardPT290000006FloraPT3100000Thedatasetwassummarizedtoincludeaveragesalarybasedonjobcode:JobcodeSalaryAvg------------------PT15000060000PT17000060000PT16000060000PT28000085000PT29000085000PT3100000100000WhichSQLstatementcouldNOTgeneratethisresult?A.selectJobcode,Salary,avg(Salary)label='Avg'fromWORK.PILOTSgroupbyJobcodeorderbyId;B.selectJobcode,Salary,(selectavg(Salary)fromWORK.PILOTSasP1whereP1.Jobcode=P2.Jobcode)asAvgfromWORK.PILOTSasP2orderbyId;C.selectJobcode,Salary,(selectavg(Salary)fromWORK.PILOTSgroupbyJobcode)asAvgfromWORK.PILOTSorderbyId;D.selectJobcode,Salary,AvgfromWORK.PILOTS,(selectJobcodeasJc,avg(Salary)asAvgfromWORK.PILOTSgroupby1)whereJobcode=JcorderbyId;Item7of63MarkitemforreviewAquickruleofthumbforthespacerequiredtorunPROCSORTis:A.twotimesthesizeoftheSASdatasetbeingsorted.B.threetimesthesizeoftheSASdatasetbeingsorted.C.fourtimesthesizeoftheSASdatasetbeingsorted.D.fivetimesthesizeoftheSASdatasetbeingsorted.Item8of63MarkitemforreviewMulti-threadedprocessingforPROCSORTwilleffectwhichofthesesys...