SAS Macro Programming By Example
4.2 (122 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,722 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SAS Macro Programming By Example to your Wishlist.

Add to Wishlist

SAS Macro Programming By Example

Learn the syntax of SAS macro and see workout examples. understand use case, debugging, error handling, looping etc.
4.2 (122 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,722 students enrolled
Last updated 5/2017
English
Price: $20
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 10 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • SAS Analysts
  • SAS Programmers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
14 Lectures
01:29:36
+
Introduction to SAS macro programming
4 Lectures 26:18

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
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
10 Lectures 01:03:18

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.


Preview 08:33

Closing note
01:30
About the Instructor
Gopal Prasad Malakar
4.3 Average rating
1,582 Reviews
20,118 Students
16 Courses
Credit Card Analytics Professional - Trains on Data Mining

I am a seasoned Analytics professional with 16+ years of professional experience. I have industry experience of impactful and actionable analytics. I am a keen trainer, who believes that training is all about making users understand the concepts. If students remain confused after the training, the training is useless. I ensure that after my training, students (or partcipants) are crystal clear on how to use the learning in their business scenarios. My expertise is in Credit Card Business, Scoring (econometrics based model development), score management, loss forecasting and MS access based database application development.