SAS Macro Language by SAS Institute via Coursera: Fee, Duration, How to Apply

Quick Facts

particular	details
Medium of instructions English	Mode of learning Self study	Mode of Delivery Video and Text Based

Course overview

The ‘SAS Macro Language’ online certification program is designed for the students to gain expertise with the statistical analytical system by learning about the tools and techniques for Data steps and processes to handle the data. This intermediate-level course is provided by the Coursera education portal with the SAS. The students can finish the course classes within twenty hours during three weeks.

The instructors for this course are academic and industry professionals such as Stacey Syphus, a senior manager of Education. This certification program is offered as part of the SAS advanced performer professional certificate and the students are allowed to study with adjustable deadlines for the assessments and tests. The students from different language backgrounds will benefit from the subtitles that are available in French, Portuguese, Russian, English, Spanish for the course materials.

The ‘SAS Macro Language’ online training program equips students with the course certificate at the end of the course after completion of the training, graded assessments, tests.

Course and certificate fees

The ‘SAS Macro Language’ certification fee is paid for the students to get access to the certificates, graded assessments, and other benefits. Students of this course can pay the program fee using the EMI options.

SAS Macro Language fee structure

Audit Mode	Nil
One month(15 hours/week)	₹4,117
Three months(5 hours/week)	₹8,234
Six months(3 hours/week)	₹12,352

certificate availability

Yes

certificate providing authority

Coursera

Who it is for

Software developer Data analyst Statistician

The ‘SAS Macro Language’ online certification program is directed at the students and professionals belonging to computer science and software development, to improve their programming skills.

Eligibility criteria

Certificate qualifying details

The students of the ‘SAS Macro Language’ certification by Coursera will become eligible to receive the certificate by SAS after completing the course of study, graded assessments, and the evaluation of case studies at the end of the training.

What you will learn

Programming skills Statistical skills Database management

The ‘SAS Macro Language’ certification syllabus is framed for the students to enable them to get engaged with the following aspects,

Carry out text substitution in SAS code.
Utilize macro functions and macro variables.
Automize and modify for the generation of SAS code.
Building of SAS code on conditional and iterative terms.
Draft customizable data-driven programs.

The syllabus

Module 1: Introduction

Videos

Course Overview
Introduction
Benefits of Using SAS Macro
The efficiency of Macro-Based Applications
Developing Macro Applications

Readings

Learner Prerequisites
Using Forums and Getting Help
Access SAS Software for this Course
Set Up Data for This Course

Module 2: SAS Macro Facility

Videos

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

Quizzes

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

Module 3: Storing and Processing Text

Videos

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

Quizzes

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

Module 4: Working with Macro Programs

Videos

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

Quizzes

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

Module 5: Developing Macro Applications

Videos

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

Reading

SAS Autocall Facility Options

Quizzes

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

Module 6: Case Study (Honors) and Certification Practice Exam

Admission details

The admission for the ‘SAS Macro Language’ online course is done online by registering through the Coursera website.

Step 1: Go to the course page using the link,

https://www.coursera.org/learn/sas-macro-language

Step 2: Find the ‘Enroll for Free’ option.

Step 3: Fill in the details.

Step 4: Choose the preferred mode.

Step 5: Pay the course fee.

Step 6: Join the program.

Filling the form

The students can register for the ‘SAS Macro Language’ online classes by entering their name, email address, and password for the course account or can sign up using their Google, Facebook, or Apple ID.

Scholarship Details

The students of this ‘SAS Macro Language’ certification program are given financial assistance to pay the course fee.
The link for the application for the financial aid is present on the course page as ‘Financial Aid Available’.
The selected candidates are intimated independently about the financial support.

How it helps

The ‘SAS Macro Language’ certification benefits the students by equipping them with the knowledge of the strategies involved in data management. The students of this online program will benefit from unlimited access to the course materials and the certificate for career development.