| DURATION | PRICE | inc-VAT | |
|---|---|---|---|
| 14 hours | £850 | £1,020 | |
Do you run your programs more than once? The Macro course teaches you techniques to make your programs smarter and easier to maintain. Learn how to write dynamic, data-dependent code using macro variables and macro programs. | |||
WHAT YOU SHOULD ALREADY KNOW...
In order to get the most out of this course, it expected that you should have attended the, 'Foundations: The Language of SAS' and 'Data Step Techniques: The Language of SAS' courses (or comparable course of study), covering topics including:
- Use of Global statements e.g. LIBNAME FILENAME and OPTIONS
- Use of functions to transform character data (e.g. SCAN, FIND, SUBSTR)
- Use of functions to transform numeric data (e.g. CEIL, INT, FLOOR, ROUND)
- Use of functions to transform dates (e.g. DAY, MONTH, YEAR, INTCK)
- KEEP and DROP to select variables
- IF and WHERE statements to select observations
- Conditional Processing with IF-THEN-ELSE
- Iterative DO Loops
- Conditional Do Loops - DO WHILE, DO UNTIL
- Compile-Time statements (e.g. LENGTH, RETAIN)
- Combining Data Sets vertically and horizontally
- Summarising data with the FREQ, MEANS and TABULATE procedures
WHAT YOU'LL BE TAUGHT...
Review of 'Foundations - The Language of SAS'
- Compilation and Execution of DATA Steps
- Selecting Observations
- Conditional Processing
- Iterative Processing
- Sorting Data
Introduction to Macro Processing
- Tokenization
- Macro Triggers
- The %PUT Statement
Introduction to Macro Variables
- Macro Variable Storage
- Macro Variable Resolution
- User-Defined Macro Variables
- The %LET Statement
- The SYMBOLGEN Option
- Delimiting Macro Variables
Macro Functions
- Character Manipulation Functions
- Using Macro Functions
- Numeric Functions
- The %SYSFUNC Function
Macro Programs
- Compilation
- Macro Calls
- Generating Code
- The MPRINT Option
- Storage
- Autocall Macros
- Best Practices
- Macro Program Parameters
Global and Local Symbol Tables
- The Global Symbol Table
- The Local Symbol Table
- Nested Macros
- Creating and Updating Macro Variables
- Resolving Macro Variables
Conditional Processing
- %IF - %THEN - %ELSE
- The MLOGIC Option
- Conditionally Returning a Program Step
- Conditionally Retuning a Statement
- Conditionally Returning a Partial Statement
- %DO - %END
- The %INCLUDE Statement
DATA Step and PROC SQL
- Create Macro Variable in a DATA Step
- CALL SYMPUTX
- Create a Series of Macro Variables
- Create Macro Variables in PROC SQL
