资源描述：
《SASAdv12月真题-63题》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、1.Whenattemptingtominimizememoryusage,themostefficientwaytodogroupprocessingwhenusingtheMEANSprocedureistouse:A.theBYstatement.B.GROUPBYwiththeNOTSORTEDspecification.C.theCLASSstatement.D.multipleWHEREstatements.(Thequestionisprettyclear-cut,IMO.Italludestothe"standard"lo
2、ng->beardedpracticaltrickusedinthesituationwhenMEANS/SUMMARYwithCLASS>usestoomuchmemory.Itdoesnotaskwhatismoreefficientingeneral>(whichwouldbetousesomethingelseinsteadofMEANSifpossible),just>whatleadstotheminimalmemoryfootprint,andtheanswerisA.(AnswerB>isjustadistraction-
3、acommondeviceincomputer-adaptivetests).The>reasonisthatwithoutBY,MEANScreatesandbuildsitsAVLtreeforthe>entirefileandallcategoricalvaluescrossingsfoundinCLASS.WithBY,>theprocbuildsthetreeforthecurrentBYgrouponly,computesthestats,>thenerasesthetreebeforethenextBYgroupstarts
4、,createsandbuildsit>again,andsoon.Theerase/createprocessisnotazerocostone,sothe>smallerthemorenumeroustheBYgroupsare,themoreitslowsdoesthe>processing;however,thesmalleristhelargestBYgroup,thesmalleristhe>memoryfootprint.)2.TheSASdatasetWORK.CHECKhasavariablenamedId_Codein
5、it.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.NEWEMPLOYEENameDeptNamesSalary------------
6、---------------AlanSalesMichelle50000MichelleSalesParesh60000ASASprogramissubmittedandthefollowingiswrittentotheSASlog:101procsql;102selectdept,name103fromWORK.EMPLOYEE104wherename=(selectnamesfromnewemployeewheresalary>40000)ERROR:Subqueryevaluatedtomorethanonerow.105;10
7、6quit;Whatwouldallowtheprogramtosuccessfullyexecutewithouterrors?A.Replacethewhereclausewith:whereEMPLOYEE.Name=(selectNamesdelimitedwith','fromWORK.NEWEMPLOYEEwhereSalary>40000);B.Replaceline104with:whereEMPLOYEE.Name=ANY(selectNamesseparatedwith','fromWORK.NEWEMPLOYEEwh
8、ereSalary>40000);（any表示要有多个值，而=只能要求一个值。）C.ReplacetheequalsignwiththeINoperator.D.Qualifythecolum
