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