Advanced SAS Programming Exam.pdf

《Advanced SAS Programming Exam.pdf》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、SASAdvancedProgrammingExamforSAS9SuccessfulcandidatesfortheSASCertifiedAdvancedProgrammercredentialshouldhaveexperienceinprogramminganddatamanagementusingSAS.TheywillbeknowledgeableinusingadvancedDATAstepprogrammingstatementsandefficiencytechniquestosol

2、vecomplexproblems,writingandinterpretingSASSQLcode,andcreatingandusingtheSASMACROfacility.CandidatesshouldalsobefamiliarwiththeenhancementsandnewfunctionalitythatareavailableinSAS9.ExamDetails65multiple-choicequestionsMustanswer42correctlytopass2hoursto

3、completeexamPrometricExamID-(A00-212)SuccessfulcandidatesshouldhaveexperienceinprogramminganddatamanagementusingSAS9andshouldbeabletouseadvancedDATAstepprogrammingstatementsuseefficiencytechniquestosolvecomplexproblemswriteandinterpretSASSQLcodecreatean

4、dusetheSASMACROfacilityTestContentAccessingDataUsingSQLGeneratedetailreportsbyworkingwithasingletableorjoiningtablesusingPROCSQLandtheappropriateoptionsGeneratesummaryreportsbyworkingwithasingletableorjoiningtablesusingPROCSQLandtheappropriateoptionsCon

5、structsubquerieswithinaPROCSQLstepComparesolvingaproblemusingtheSQLprocedureversususingtraditionalSASprogrammingtechniquesAccessDictionaryTablesusingtheSQLprocedureDemonstrateadvancedPROCSQLskillsbycreatingandupdatingtables,updatingdatavalues,workingwit

6、hindexesusingthemacrointerface/creatingmacrovariableswithSQL,definingintegrityconstraints,SQLviewsandSEToperatorsPage3MacroProcessingCreatingandusinguser-definedandautomaticmacrovariableswithintheSASMacroLanguageAutomateprogramsbydefiningandcallingmacro

7、susingtheSASMacroLanguageUnderstandtheuseofmacrofunctionsRecognizevarioussystemoptionsthatareavailableformacrodebugginganddisplayingvaluesofuser-definedandautomaticmacrovariablesintheSASlogAdvancedProgrammingTechniquesDemonstrateadvanceddatasetprocessin

8、gtechniquessuchasupdatingmasterdatasets,transposingdata,combining/mergingdata,samplingdata,usinggenerationdatasets,integrityconstraintsandaudittrailsReducethespacerequiredtostoreSASdatasetsandnumericvariableswithinSASdatasetsbyus