資源描述:
《SAS Adv 12月真題-63題》由會員上傳分享,免費在線閱讀,更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、1.Whenattemptingtominimizememoryusage,themostefficientwaytodogroupprocessingwhenusingtheMEANSprocedureistouse:A.theBYstatement.B.GROUPBYwiththeNOTSORTEDspecification.C.theCLASSstatement.D.multipleWHEREstatements.(Thequestionisprettyclear-cut,IMO.Italludestothe"standa
2、rd"long->beardedpracticaltrickusedinthesituationwhenMEANS/SUMMARYwithCLASS>usestoomuchmemory.Itdoesnotaskwhatismoreefficientingeneral>(whichwouldbetousesomethingelseinsteadofMEANSifpossible),just>whatleadstotheminimalmemoryfootprint,andtheanswerisA.(AnswerB>isjustadi
3、straction-acommondeviceincomputer-adaptivetests).The>reasonisthatwithoutBY,MEANScreatesandbuildsitsAVLtreeforthe>entirefileandallcategoricalvaluescrossingsfoundinCLASS.WithBY,>theprocbuildsthetreeforthecurrentBYgrouponly,computesthestats,>thenerasesthetreebeforethene
4、xtBYgroupstarts,createsandbuildsit>again,andsoon.Theerase/createprocessisnotazerocostone,sothe>smallerthemorenumeroustheBYgroupsare,themoreitslowsdoesthe>processing;however,thesmalleristhelargestBYgroup,thesmalleristhe>memoryfootprint.)2.TheSASdatasetWORK.CHECKhasava
5、riablenamedId_Codeinit.WhichSQLstatementwouldcreateanindexonthisvariable?A.createindexId_CodeonWORK.CHECK;B.createindex(Id_Code)onWORK.CHECK;C.makeindex=Id_CodefromWORK.CHECK;D.defineindex(Id_Code)inWORK.CHECK;3.GiventheSASdatasets:WORK.EMPLOYEEWORK.NEWEMPLOYEENameDe
6、ptNamesSalary---------------------------AlanSalesMichelle50000MichelleSalesParesh60000ASASprogramissubmittedandthefollowingiswrittentotheSASlog:101procsql;102selectdept,name103fromWORK.EMPLOYEE104wherename=(selectnamesfromnewemployeewheresalary>40000)ERROR:Subqueryev
7、aluatedtomorethanonerow.105;106quit;Whatwouldallowtheprogramtosuccessfullyexecutewithouterrors?A.Replacethewhereclausewith:whereEMPLOYEE.Name=(selectNamesdelimitedwith','fromWORK.NEWEMPLOYEEwhereSalary>40000);B.Replaceline104with:whereEMPLOYEE.Name=ANY(selectNamessep
8、aratedwith','fromWORK.NEWEMPLOYEEwhereSalary>40000);(any表示要有多個值,而=只能要求一個值。)C.ReplacetheequalsignwiththeINoperator.D.Qualifythecolum