Business
Data & Analytics
SAS
SAS Macro Programming By Example
4.1 (160 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,890 students enrolled

SAS Macro Programming By Example

Learn the syntax of SAS macro and see workout examples. understand use case, debugging, error handling, looping etc.
4.1 (160 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,890 students enrolled
Created by Gopal Prasad Malakar
Last updated 7/2019
English
English
Preview this course
SAS Macro Programming By Example
Current price: $11.99 Original price: $19.99 Discount: 40% off
3 days left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 1 article
  • 15 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
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 

  1. save his time, 
  2. write error free code and 
  3. 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

  1. Introduction - in this section, students will be introduced to various syntax options and they will be demonstrated the same using SAS
  2. 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.
Who this course is for:
  • SAS Analysts
  • SAS Programmers
Course content
Expand all 18 lectures 01:46:59
+ – Introduction to SAS macro programming
7 lectures 37:42
Curriculum details - How does the course progress?
Preview 02:13
Getting free access to SAS for academics
03:30
Understand SAS for academics - environment
06:31
How to study this course? - get best out of this course
01:23

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
What is a SAS macro and what are multiple ways to define a SAS macro?
Preview 09:24

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


How to make SAS macro function and define a loop inside SAS macro?
05:07

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


Syntax for conditional execution, data type conversion & debugging in SAS macro
09:34
+ – Workout Examples
11 lectures 01:09:17

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 A- Variable type and values based SAS execution
03:35

SAS syntax explanation

Workout Example 1- Part B- Variable type and values based SAS execution
10:15

You will learn how to use scan, substr, uppercase, do until etc. in this use case

Workout Example 2 - Part A- Putting substr, scan, uppercase into use
01:34
Workout Example 2 - Part B- Putting substr, scan, uppercase into use
09:21
Workout Example 3- Precaution and Advantage of SAS macro programming
06:08
Workout Example 4- generating multiple SAS macro and using them using &&
04:33
  • Learn to generate SAS code using Excel and then
  • Learn to generate SAS code directly within SAS using Call Execute
Workout Example 5- Generate SAS code using SAS call execute procedure
09:07
Workout Example 6- Smart way of handling SAS macro error
08:42

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.


Appendix topic - SAS Array
Preview 08:33
Bonus Topic - Analytics / Data Science / Machine Learning Interview questions
Preview 05:59
Closing note
01:30