SAS Institute Of Management Studies - SAS Macro Language 

Course Overview

Introduction

Benefits of Using SAS Macro

Efficiency of Macro-Based Applications

Developing Macro Applications

Learner Prerequisites

Using Forums and Getting Help

Access SAS Software for this Course

Set Up Data for This Course

Introduction

SAS Programming Languages

Program Flow

Tokens

Tokenization

Tokenizing Code with Macro Triggers

Macro Variables

Creating Macro Variables With %LET

Deleting Macro Variables

Resolving Macro Variables

Using SYMBOLGEN to Troubleshoot Macro Variable References

Delimiting Macro Variable References

Displaying Macro Variables

Automatic Macro Variables

Updating Macro Variables

Question 2.01

Question 2.02

Question 2.03

Question 2.04

Activity 2.05

Activity 2.06

Activity 2.07

Activity 2.08

Level 1 Practice: Defining and Using Macro Variables for Substitution

Level 2 Practice: Using Macro Variable References with Delimiters

SAS Macro Facility Review

Introduction

Using Macro Functions

SAS Functions and Macro Functions

Processing Text with Macro Functions

Executing SAS DATA Step Functions During Tokenization

Evaluating Arithmetic Expressions

Using Special Characters

Demo: Using Macro Functions

Creating Macro Variables in PROC SQL

Demo: Creating Macro Variables with a PROC SQL Query

Scenario: Create Macro Variables in a DATA Step

DATA Step versus Macro Execution Timing

Creating Macro Variables in a DATA Step

Creating Macro Variables During DATA Step Execution

Demo: Creating Macro Variables with the DATA Step

Comparing the DATA Step and PROC SQL

Scenario: Using Indirect References

Forward Rescan Rule

Demo: Indirect References to Macro Variables

Activity 3.01

Question 3.02

Activity 3.03

Activity 3.04

Level 1 Practice: Using the %UPCASE and %SCAN Functions

Level 2 Practice: Using Macro Quoting Functions

Level 1 Practice: Using PROC SQL to Generate Macro Variables for Use in a Report Title

Level 2 Practice: Using PROC SQL to Generate Macro Variables for Use in Subsequent Steps

Activity3.05

Question 3.06

Activity 3.07

Level 1 Practice: Creating Macro Variables with the SYMPUTX Routine

Level 2 Practice: Using a DATA _NULL_ Step to Create a Series of Macro Variables

Activity 3.08

Level 1 Practice: Using Indirect References to Macro Variables

Level 2 Practice: Using Indirect References to Macro Variables

Storing and Processing Text Review

Introduction

Defining a Macro

Using the MCOMPILENOTE Option

Calling a Macro

Using the MPRINT Option

Macro Parameters

Demo: Defining a Macro with Parameters

Macro Keyword Parameters

Mixed Parameter Lists

Global Macro Variables

Local Macro Variables

Macro Variable Scope

Controlling Macro Variable Scope

Resolving Macro Variables

Nested Macro Calls

Conditional Processing

Conditionally Executing Program Steps

Scenario: Nested Conditional Processing

Conditionally Generating Program Steps

Conditionally Generating Complete and Partial Statements

Using the MLOGIC Option

Demo: Conditional Processing

Scenario: Generating Repetitive Code

%DO Iterative Statement

Demo: Iterative %DO Loops

Using a %DO Loop with Indirect References

Demo: %DO Loops with Indirect References

%DO WHILE Loops

%DO UNTIL Loops

Activity 4.01

Activity 4.02

Activity 4.03

Level 1 Practice: Defining and Using a Macro with Parameters

Level 2 Practice: Using a Macro to Generate PROC MEANS Code

Question 4.04

Activity 4.05

Activity 4.06

Level 1 Practice: Understanding Symbol Tables

Level 2 Practice: Controlling Macro Variable Scope

Activity 4.07

Activity 4.08

Level 1 Practice: Using Macro Conditional Processing to Choose Which SAS Statements are Generated

Level 2 Practice: Using Macro Conditional Processing in Open Code

Activity 4.09

Code Challenge 4.10

Level 1 Practice: Using Iterative Processing and Indirect Referencing

Level 2 Practice: Using a %DO %UNTIL Loop

Working with Macro Programs Review

Introduction

Compiled Macros

Autocall Macro Facility

Calling Autocall Macros

Adding Personal Macros to an Autocall Library

Demo: Macro Autocall Libraries

Develop a SPLITTABLE Macro Application

Demo: Generating Data-Dependent Code

Enhancing Macro Applications

Validating Parameters

Additional Validation Techniques

Demo: Validating Parameters

Documenting a Macro

Complex Macro Enhancements

SAS Autocall Facility Options

Activity 5.01

Activity 5.02

Activity 5.03

Activity 5.04

Level 1 Practice: Generating Data-Dependent Listing Reports

Level 2 Practice: Exporting Data to Separate Worksheets in Microsoft Excel

Activity 5.05

Activity 5.06

Activity 5.07

Level 1 Practice: Validating a Macro Parameter

Level 2 Practice: Validating Macro Parameters with Data Values

Developing Macro Applications Review

The Business Problem and Required Deliverables

The Case Study Files

Select a Case Study Guide

Test Your Case Study Results