Explore

SAS Macro Language

Approx. 19 hours to complete

Save Course

Go to Course

Description

In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.

Outline

Introduction
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

SAS Macro Facility
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

Storing and Processing Text
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

Working with Macro Programs
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

Developing Macro Applications
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

Case Study (Honors) and Certification Practice Exam
The Business Problem and Required Deliverables
The Case Study Files
Select a Case Study Guide
Test Your Case Study Results

Summary of User Reviews

Discover the power of SAS Macro Language with this online course on Coursera. Students have praised the course for its comprehensive curriculum, engaging instructors, and practical exercises. Overall, the course has received positive reviews from satisfied learners.

Key Aspect Users Liked About This Course

Many users have appreciated the practical approach of the course, which has helped them apply the concepts they learned to real-world scenarios.

Pros from User Reviews

Comprehensive curriculum covering all aspects of SAS Macro Language
Engaging instructors who explain the concepts clearly and concisely
Practical exercises and assignments that help learners apply the concepts to real-world scenarios
Flexible schedule that allows students to learn at their own pace
Great value for money compared to other SAS courses available online

Cons from User Reviews

Some users have found the course material to be too basic, especially if they have prior experience with SAS programming
Occasional technical glitches and issues with the online platform
Limited interaction with other students and the instructors, which can be a disadvantage for those who prefer a more collaborative learning environment
Some users have reported that the course is not suitable for advanced learners who are looking for more challenging material
No certificate of completion offered for the free version of the course

Recommended for you

Programming in SAS for beginners

Become an expert SAS analyst. Learn basics of SAS programming and advanced topics like SAS SQL Procedure and SAS Macros SAS Programming - from beginners to advanced users...

Save Course

SAS Base Programming

Basic Programming concepts of SAS This course describes the basic concepts of SAS programming language starting from the SAS console,importing and exporting the datasets to all the functions used in SAS....

Save Course

Complete SAS Bootcamp

A gentle and complete course on SAS programming, learn data analysis and visualization with SAS SQL and SAS Maro. Anyone interested in full information, visit our disclaimer at the bottom....

Save Course

SAS Advanced Programmer Professional Certificate

Grow Your Career with a SAS® Credential. Master the skills required for the SAS® Advanced Programming Professional certification. These skills prepare you for the SAS Advanced Programming Professional certification exam....

Save Course