This course is designed to take attendees to the next level of macro understanding in SAS software. This course demonstrates the use of macros in every day business situations, which enhance productivity and efficiency in not only processing, but time to build programs. The creation of dynamic code based on data values and the set up of generic, reusable code libraries will be discussed. Macros as they apply to SAS/CONNECT, SAS/STAT, SAS/GRAPH and other modules of SAS will be taught. This course will also cover the use of autocall libraries, data step function calls and debugging techniques.
This course is designed for SAS Programmers and Analysts who use macros.
Upon completion of this course, the participant will be able to:> Use macros in every day business situations> Create dynamic code based on data values> Use autocall libraries, data step function calls and debugging techniques
Web based formatting macros Nesting and recursive macros The use of quoting functions Using macros with your operating system Macro return codes Compiled macro libraries Statement and Command style macros Macro Do Loops Proc SQL creation of macro values The RESOLVE function Evaluation Functions%EVAL%SYSEVALF Data Step Functions%SYSFUNC%QSYSFUNC%SYSCALLATTRN Macro Routines and UtilitiesMoving members and data between locationsWorking with System Dates and TimesExamining Operating System permissionsAutomated reading and filtering of dataAutomated analysis of values found in any set of columnsDetermining the existence ofa macro variablea data setUnderstanding the SAS supplied macro utilitiesMacro arraysEfficiency techniques and tipsSampling with macrosExecution time macro processingSoftware Used: Base SAS software
Macro Processing course or equivalent experience is required.
"I work with a lot of resellers and TEK is by far the best! TEK is always incredibly professional and well organized. Thank you!" – A TEKsystems Client