SAS ADVANCE (63题,无答案版,适合独立练习使用)

《SAS ADVANCE (63题,无答案版,适合独立练习使用)》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Item1of63MarkitemforreviewWhenattemptingtominimizememoryusage,themostefficientwaytodogroupprocessingwhenusingtheMEANSprocedureistouse:A.theBYstatement.B.GROUPBYwiththeNOTSORTEDspecification.C.theCLASSstatement.D.multipleWHEREstatements.Item2of63MarkitemforreviewTheSASdatasetWORK.CHECKhasavariab

2、lenamedId_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.NEWEMPLOYEENameDeptNamesS

3、alary---------------------------AlanSalesMichelle50000MichelleSalesParesh60000ASASprogramissubmittedandthefollowingiswrittentotheSASlog:101procsql;102selectdept,name103fromWORK.EMPLOYEE104wherename=(selectnamesfromnewemployeewheresalary>40000)ERROR:Subqueryevaluatedtomorethanonerow.105;106quit;

4、Whatwouldallowtheprogramtosuccessfullyexecutewithouterrors?A.Replacethewhereclausewith:whereEMPLOYEE.Name=(selectNamesdelimitedwith','fromWORK.NEWEMPLOYEEwhereSalary>40000);B.Replaceline104with:whereEMPLOYEE.Name=ANY(selectNamesseparatedwith','fromWORK.NEWEMPLOYEEwhereSalary>40000);C.Replacethe

5、equalsignwiththeINoperator.D.Qualifythecolumnnameswiththetablenames.Item4of63MarkitemforreviewGiventheSASdatasetSASUSER.HIGHWAY:SteeringSeatbeltSpeedStatusCount---------------------------------absentNo0-29serious31absentNo0-29not1419absentNo30-49serious191absentno30-49not2004absentno50+serious2

6、16ThefollowingSASprogramissubmitted: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:GROU

7、PSseparatedby','D.into&GROUPSseparatedby','Item5of63MarkitemforreviewTheSASdatasetWORK.CHECKhasanindexonthevariableCodeandthefollowingSASprogramissubmitted.procsortdata=WORK.CHECK;byCode;run;WhichdescribestheresultofsubmittingtheS