SAS高级程序员考试大纲和考试经验精华(总结)

SAS高级程序员考试大纲和考试经验精华(总结)

SASCertifiedAdvancedProgrammerforSAS9Credential一、考试大纲

容·usingadvancedDATAstepprogrammingstatementsandefficiencytechniquestosolvecomplexproblems.(25%

requiredwhenregisteringwithPearsonVUE.Examtopicsinclude:AccessingDataUsingSQL·Generatedetailandsummaryreportsbyworkingwithasingletable,joiningtables,orusingsetoperatorsintheSQLprocedure.·Constructsub-queriesandin-lineviewswithin(构造子查询和内联视图)anSQLprocedurestep.·ComparesolvingaproblemusingtheSQLprocedureversususingtraditionalSASprogrammingtechniques.·AccessDictionaryTablesusingtheSQLprocedure.MacroProcessing·Createanduseuser-definedandautomaticmacrovariableswithintheSASMacroLanguage.·AutomateprogramsbydefiningandcallingmacrosusingtheSASMacroLanguage.·Understandtheuseofmacrofunctions.·Usevarioussystemoptionsthatareavailableformacrodebugging

anddisplayingvaluesofuser-definedandautomaticmacrovariablesintheSASlog.·Createdata-drivenprogramsusingSASMacroLanguage.AdvancedProgrammingTechniques·Demonstratetheuseofadvanceddatalook-uptechniquessuchasarrayprocessing,hashobjects(

象),formats,andcombining/mergingdata.·ReducecomputingresourcerequirementsbycontrollingthespacerequiredtostoreSASdatasetsusingcompressio

ntechniques,lengthstatements,oreliminatingvariablesandobservations.·ReduceprogrammingtimebydevelopingreusableSASprogramswhichincorporatedatastepviews,DATAstepsthatwriteSASprograms,andtheFCMPprocedure.·PerformeffectivebenchmarkingbyusingtheappropriateSASSystemoptionsandinterpretingtheresultingresourceutilizationstatistics.·Identifyappropriateapplicationsforusingindexes(

引)andcreatethemusingtheDATAstep,theDATASETSprocedure,ortheSQLprocedure.·Comparetechniquestoeliminateduplicatedata(消除重复数据)usingtheDATAstep,theSORTprocedure,andtheSQLprocedure.二、考试经验总结和已考内容1.复习要点和考试范围高级的skills很有用,SQL,MACRO及一些programmingutility(程序控制工具即,optimization(优化)settwo(bufno=6);其中bufno作用?③BUFSIZE=、BUFNO=、BUFSIZE*BUFNO。

TheyareintheOptimizationandefficiencypart,其中bufno的作用?2)compress=yes和数据变量以及字符变量联系起来复习,以及如何压缩的?reuse=yes在compress里什么作用?3)hashobject好处(可快速得到key对应的内存地址直接取数,不用扫描整个表,效率更高),和Keyvalues(关键码值)有关的知识一起复习,以及执行完后保存与否?array的相关知识?4)SELECTindatastep和IF-THEN/ELSE在efficiency上的不同?5)Advance中datastep和procdataset应用(以为PROCDATASETS会考多点,1~2道题有关)(11)SASFILE的作用?

联系客服:779662525#qq.com(#替换为@) 苏ICP备20003344号-4