SAS
楂樼骇绋嬪簭鍛樿�冭瘯澶х翰鍜岃�冭瘯缁忛獙绮惧崕
(
鎬荤粨
)
SASCertifiedAdvancedProgrammerforSAS9Credential
涓�銆?/p>
鑰冭瘯澶?/p>
绾?
锛?
闇�
鎺?
鎻?
濡?
涓?
鍐?
瀹?/p>
路
usingadvancedDA
TAstepprogrammingstatementsandefficiencytechniq
uestosolvecomplexproblems.(25%
绋?
搴?
浼?
鍖?
requiredwhenregisteringwithPearsonVUE.Examtopicsinclude:Accessing
DataUsingSQL路
Generatedetailandsummaryreportsbyworkingwithasinglet
able,joiningtables,orusingsetoperatorsintheSQLprocedure.路
Constructsub-
queriesandin-lineviewswithin(
鏋?/p>
閫?/p>
瀛?/p>
鏌?/p>
璇?/p>
鍜?/p>
鍐?/p>
鑱?/p>
瑙?/p>
鍥?/p>
)anSQLprocedurestep.路
ComparesolvingaproblemusingtheSQLprocedur
eversususingtraditionalSASprogrammingtechniques.路
AccessDictionaryTa
blesusingtheSQLprocedure.MacroProcessing路
Createanduseuser-defineda
ndautomaticmacrovariableswithintheSASMacroLanguage.路
Automateprog
ramsbydefiningandcallingmacrosusingtheSASMacroLanguage.路
Understa
ndtheuseofmacrofunctions.路
Usevarioussystemoptionsthatareavailablefor
macrodebugging
锛?
鐢?
浜?
瀹?
璋?
璇?
锛?
anddisplayingvaluesofuser-definedandautomaticmacrovariablesintheSASl
og.路
Createdata-drivenprogramsusingSASMacroLanguage.AdvancedProgr
ammingTechniques路
Demonstratetheuseofadvanceddatalook-uptechniques
suchasarrayprocessing,hashobjects(
鏁?
鍒?
瀵?
璞?/p>
),formats,andcombining/mergingdata.路
Reducecomputingresourcerequir
ementsbycontrollingthespacerequiredtostoreSASdatasetsusingcompressio