资源描述：
《SAS Adv 12月真题-63题》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
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
