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的作用？