This course is designed to apply knowledge gained from SAS Macro Language 1: Essentials to a comprehensive case study project. It includes a review of SAS Macro Language 1 material along with the case study. You will enhance a prewritten program, creating a macro program with parameters, conditionally execute pieces of the program, utilize indirect references and more! This course builds on the concepts that are presented in SAS Macro Language 1 and is not recommended if you have not taken the prerequisite.
Learn How To
Apply your skills from SAS Macro Language 1Perform text substitution in SAS code. Use macro variables and macro functions. Automate and customize the production of SAS code.Conditionally or iteratively construct SAS code.Write self-modifying, data-driven programs.Who Should Attend
SAS programmers and business analysts
Prerequisites
SAS Macro Language 1: Essentials or equivalent experience.
Course Outline
Case Study Kickoff
Data DiscoverySAS Macro Language 1 Review SAS Macro Facility Program flow Creating and using macro variablesStoring and Processing TextMacro functionsUsing SQL to create macro variablesUsing the DATA step to create macro variablesIndirect references to macro variablesWorking with Macro Programs Defining and calling a macroMacro variable scopeConditional processingIterative processingDeveloping Macro Applications Storing macrosGenerating data-dependent codeValidating parameters and documenting macros
Live Instructor Dates