Monthly Subscription Starting at AED 99 + VAT

SAS Macro Language
  • Level Professional
  • Duration 21 hours
  • Course by SAS
  • Offered by

About

In this course, you learn advanced techniques within the DATA step and procedures to manipulate data. Course Learning Objectives: (3+ per course) “By the end of this course, a learner will be able to…” ● Perform 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.

Modules

Course Overview and Logistics

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Course Overview

2 Readings

  • Learner Prerequisites
  • Using Forums and Getting Help

Access SAS Software and Set Up Data for the Course (REQUIRED)

    • 2 Readings
Show info about module content

2 Readings

  • Access SAS Software for this Course
  • Set Up Data for This Course

Why SAS Macro?

    • 4 Videos
Show info about module content

4 Videos

  • Introduction
  • Benefits of Using SAS Macro
  • Efficiency of Macro-Based Applications
  • Developing Macro Applications

Module Overview

    • 1 Videos
Show info about module content

1 Videos

  • Introduction

Program Flow

    • 5 Videos
    • 3 Assignment
Show info about module content

3 Assignment

  • Question 2.01
  • Question 2.02
  • Question 2.03

5 Videos

  • SAS Programming Languages
  • Program Flow
  • Tokens
  • Tokenization
  • Tokenizing Code with Macro Triggers

Creating and Using Macro Variables

    • 9 Videos
    • 7 Assignment
Show info about module content

7 Assignment

  • 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

9 Videos

  • 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

Module Review

    • 1 Assignment
Show info about module content

1 Assignment

  • SAS Macro Facility

Module Overview

    • 1 Videos
Show info about module content

1 Videos

  • Introduction

Macro Functions

    • 7 Videos
    • 6 Assignment
Show info about module content

6 Assignment

  • 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

7 Videos

  • 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

Using SQL to Create Macro Variables

    • 2 Videos
    • 2 Assignment
Show info about module content

2 Assignment

  • 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

2 Videos

  • Creating Macro Variables in PROC SQL
  • Demo: Creating Macro Variables with a PROC SQL Query

Using the DATA Step to Create Macro Variables

    • 6 Videos
    • 5 Assignment
Show info about module content

5 Assignment

  • 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

6 Videos

  • 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

Indirect References to Macro Variables

    • 3 Videos
    • 3 Assignment
Show info about module content

3 Assignment

  • Activity 3.08
  • Level 1 Practice: Using Indirect References to Macro Variables
  • Level 2 Practice: Using Indirect References to Macro Variables

3 Videos

  • Scenario: Using Indirect References
  • Forward Rescan Rule
  • Demo: Indirect References to Macro Variables

Module Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Storing and Processing Text

Module Overview

    • 1 Videos
Show info about module content

1 Videos

  • Introduction

Defining and Calling a Macro

    • 8 Videos
    • 5 Assignment
Show info about module content

5 Assignment

  • 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

8 Videos

  • 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

Macro Variable Scope

    • 6 Videos
    • 5 Assignment
Show info about module content

5 Assignment

  • Question 4.04
  • Activity 4.05
  • Activity 4.06
  • Level 1 Practice: Understanding Symbol Tables
  • Level 2 Practice: Controlling Macro Variable Scope

6 Videos

  • Global Macro Variables
  • Local Macro Variables
  • Macro Variable Scope
  • Controlling Macro Variable Scope
  • Resolving Macro Variables
  • Nested Macro Calls

Conditional Processing

    • 7 Videos
    • 4 Assignment
Show info about module content

4 Assignment

  • 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

7 Videos

  • 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

Iterative Processing

    • 7 Videos
    • 4 Assignment
Show info about module content

4 Assignment

  • Activity 4.09
  • Code Challenge 4.10
  • Level 1 Practice: Using Iterative Processing and Indirect Referencing
  • Level 2 Practice: Using a %DO %UNTIL Loop

7 Videos

  • 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

Module Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Working with Macro Programs

Module Overview

    • 1 Videos
Show info about module content

1 Videos

  • Introduction

Storing Macros

    • 5 Videos
    • 1 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Activity 5.01
  • Activity 5.02
  • Activity 5.03

5 Videos

  • Compiled Macros
  • Autocall Macro Facility
  • Calling Autocall Macros
  • Adding Personal Macros to an Autocall Library
  • Demo: Macro Autocall Libraries

1 Readings

  • SAS Autocall Facility Options

Generating Data-Dependent Code

    • 2 Videos
    • 3 Assignment
Show info about module content

3 Assignment

  • Activity 5.04
  • Level 1 Practice: Generating Data-Dependent Listing Reports
  • Level 2 Practice: Exporting Data to Separate Worksheets in Microsoft Excel

2 Videos

  • Develop a SPLITTABLE Macro Application
  • Demo: Generating Data-Dependent Code

Validating Parameters and Documenting Macros

    • 6 Videos
    • 5 Assignment
Show info about module content

5 Assignment

  • 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

6 Videos

  • Enhancing Macro Applications
  • Validating Parameters
  • Additional Validation Techniques
  • Demo: Validating Parameters
  • Documenting a Macro
  • Complex Macro Enhancements

Module Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Developing Macro Applications

Certification Practice Exam

    • 1 ExternalTool
Show info about module content

1 External Tool

  • SAS Certification Practice Exam: SAS 9.4 Advanced Programming Performance-Based Exam

Macro Case Study

    • 3 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Test Your Case Study Results

3 Readings

  • The Business Problem and Required Deliverables
  • The Case Study Files
  • Select a Case Study Guide

Auto Summary

Elevate your SAS skills with the "SAS Macro Language" course on Coursera, designed for IT and Computer Science professionals. Master advanced techniques to manipulate data, perform text substitutions, use macro variables, automate code production, and create self-modifying programs. This professional-level course spans 1260 minutes and is available under the Starter subscription. Ideal for those looking to deepen their SAS programming expertise.

Stacey Syphus
Instructor

Stacey Syphus