Crash Course : SAS Macro Programming By Example

Learn the syntax of SAS macro and see workout examples. understand use case, debugging, error handling, looping etc.

Created byGopal Prasad Malakar

Last updated 12/2023

English

What you'll learn

Understand the SAS macro syntax
SAS Macro usage
Technique to understand the execution of SAS Macros
Download SAS Macro codes for their usage and modifications
See some workout examples of SAS macros
Understand how to handle SAS macro errors

Course content

2 sections • 18 lectures • 1h 46m total length

Curriculum details - How does the course progress?2:13
Getting free access to SAS for academics3:30
Understand SAS for academics - environment6:31
How to study this course? - get best out of this course1:23
What is a SAS macro and what are multiple ways to define a SAS macro?9:24
SAS code - you will learn the syntax,
To detect number of variables in a dataset
Create loop to run for all the variables of a dataset
Detect number of distinct categories for all variables
Pass a parameter to macro to make a condition for number of distinct categories
Run proc freq for some cases meeting above condition
Run univariate for numeric variables How to put descriptive titles
How to make SAS macro function and define a loop inside SAS macro?5:07
SAS code will help you learn the syntax,
To detect number of variables in a dataset
Create loop to run for all the variables of a dataset
Detect number of distinct categories for all variables
Pass a parameter to macro to make a condition for number of distinct categories
Run proc freq for some cases meeting above condition
Run univariate for numeric variables
How to put descriptive titles
Syntax for conditional execution, data type conversion & debugging in SAS macro9:34
Continuation of lecture 3
To detect number of variables in a dataset
Create loop to run for all the variables of a dataset
Detect number of distinct categories for all variables
Pass a parameter to macro to make a condition for number of distinct categories
Run proc freq for some cases meeting above condition
Run univariate for numeric variables
How to put descriptive titles

Workout Example 1- Part A- Variable type and values based SAS execution3:35
you will learn the syntax,
To detect number of variables in a dataset
Create loop to run for all the variables of a dataset
Detect number of distinct categories for all variables
Pass a parameter to macro to make a condition for number of distinct categories
Run proc freq for some cases meeting above condition
Run univariate for numeric variables
How to put descriptive titles
Workout Example 1- Part B- Variable type and values based SAS execution10:15
SAS syntax explanation
Workout Example 2 - Part A- Putting substr, scan, uppercase into use1:34
You will learn how to use scan, substr, uppercase, do until etc. in this use case
Workout Example 2 - Part B- Putting substr, scan, uppercase into use9:21
Workout Example 3- Precaution and Advantage of SAS macro programming6:08
Workout Example 4- generating multiple SAS macro and using them using &&4:33
Workout Example 5- Generate SAS code using SAS call execute procedure9:07
Learn to generate SAS code using Excel and then
Learn to generate SAS code directly within SAS using Call Execute
Workout Example 6- Smart way of handling SAS macro error8:42
Appendix topic - SAS Array8:33
Though it is not SAS macro, but many students have told me that in terms of utility, it is extremely handy and little difficult to understand in the first go. That's why i have decided to provide the same along with this course.
Bonus Topic - Analytics / Data Science / Machine Learning Interview questions5:59
Closing note1:30

Requirements

Basic SAS

Description

This course is all about SAS macro. SAS is synonymous of analytics. SAS macro is considered an advance topic in SAS programming.

It helps SAS programmers to

save his time,
write error free code and
put more time into analysis rather than just writing the code.

In this course students will learn the syntax of SAS macro, see the use cases and will go through some workout examples. After doing the course students should become comfortable in writing SAS macros.

The course will have two sections

Introduction - in this section, students will be introduced to various syntax options and they will be demonstrated the same using SAS
Workout - in this section students will learn to put together various SAS syntax for a purpose. They will learn the objective of the use case and see how it was achieved. All the code will be explained in step by step manner.

The course has been designed to explain basic concepts of SAS macro programming through examples. Users should be able to learn the syntax by seeing how it is solving a practical situation. This course is concise and packs only those materials, which are most frequently used. Students should download reference materials and practice along with the course to get full confidence.

Who this course is for:

SAS Analysts
SAS Programmers

Crash Course : SAS Macro Programming By Example

What you'll learn

Explore related topics

Course content

Introduction to SAS macro programming7 lectures • 38min

Workout Examples11 lectures • 1hr 9min

Requirements

Description

Who this course is for: