SAS programming on SAS Macro Language
4.3 (156 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.
799 students enrolled

SAS programming on SAS Macro Language

Learn SAS Macro step by step with examples
4.3 (156 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.
799 students enrolled
Created by sharon cheng
Last updated 9/2019
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 8 articles
  • 2 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
  • Create and Use Macro variables and Macro Functions: Automatic & User-Defined Macro Variables, Displaying Macro Variable Values in the SAS Log using SYMBOLGEN, Displaying Macro Variable Values in the SAS Log using PUT, Macro Functions including %STR, %UPCASE, %SUBSTR, %SCAN, %SYSFUNC, Combining Macro Variable References with Texts (text&variable; &variable&variable; &variabletext)
  • Create and Use Macro Programs: Basic Concepts: Defining, Compiling and Calling Macros; Developing and Debugging Macros with options: MPRINT, MLOGIC; Using Macro Parameters: Positional Parameters; Using Macro Parameters: Keyword Parameters; Using Macro Parameters: Mixed Parameters; Processing Statements Conditionally at the macro level: %IF%THEN%ELSE %DO%END; Processing Statements Interactively With the iterative %DO statement
  • Create and Use macro variables during execution of a data step: Use macro variables during execution of a data step: Symput routine; Create multiple macro variables with SYMPUT and Indirect referencing with &&; Obtaining Macro Variable Values during DATA Step Execution with SYMGET Function
  • Create and Use macro variables during execution of a proc SQL step: Creating Macro Variables during PROC SQL Step Execution: INTO clause; Creating a series of related Macro Variables with the INTO Clause in Proc SQL; Creating one macro variable holding a Delimited List of Values with INTO clause
Course content
Expand all 43 lectures 04:02:12
+ Course Overview and Supplements
4 lectures 29:49

The links to download SAS University Edition/ SAS studio provides by SAS.com:

https://www.sas.com/en_us/software/university-edition.html


This is a complete and step-by-step  guide to Install SAS studio

the complete and step-by-step guide to Install SAS studio
14:58

Video shows how to download zip files, and copy & paste the files into right folder. Video is using another course's materials as an example.

Downloadable course materials: SAS programs and Data used in the course
05:35
File path/directory in SAS studio
04:25
+ SAS Macro Introduction
6 lectures 19:53
Replacing Text Strings Using Macro Variables
05:56
Generating SAS Code Using Macros
06:04
Passing Information into a Macro Using Parameters
04:29
Quiz
4 questions
Coding Exercise
00:06
Coding Exercise: Solution
00:30
+ Macro Variables & Macro Functions
16 lectures 01:17:57
Automatic macro variables
03:23
User-Defined Macro Variables
06:21
Displaying Macro Variable Values in the SAS Log: using SYMBOLGEN
04:54
Displaying Macro Variable Values in the SAS Log: using %PUT
04:52
Using Macro Quoting Function to Mask Special Characters:%STR
05:36
More on Using Macro Quoting Functions to Mask Special Characters:%STR
04:53
Using Macro Functions to Manipulate Character Strings: %UPCASE
04:39
Using Macro Functions to Manipulate Character Strings: %SUBSTR
05:53
Using Macro Functions to Manipulate Character Strings: %SCAN
04:53
Using %SYSFUNC function to execute other SAS functions
04:53
Combining Macro Variable References with Texts
08:56
Using delimiter for a macro variable name immediately before text
05:10
More on using delimiter for a macro variable name immediately before text
06:54
Quiz
9 questions
Coding Exercise
00:24
Coding Exercise: Solution
00:36
+ Create & Use macro variables during a data step or a Proc SQL step
8 lectures 54:51
Create multiple macro variables with SYMPUT and Indirect referencing with &&
11:18
Obtaining Macro Variable Values during DATA Step Execution with SYMGET Function
04:47
Creating Macro Variables during PROC SQL Step Execution: INTO clause
07:51
Creating a series of related Macro Variables with the INTO Clause in Proc SQL
07:55
Creating one macro variable holding a Delimited List of Values with INTO clause
05:57
Quiz
7 questions
Coding Exercise
00:18
Coding Exercise: Solution
00:36
+ Creating and Using Macro Programs
9 lectures 59:40
Developing and Debugging Macros with options: MPRINT, MLOGIC
06:13
Using Macro Parameters: Positional Parameters
10:00
Using Macro Parameters: Keyword Parameters
10:34
Using Macro Parameters: Mixed Parameters
06:56
Processing Statements Conditionally at the macro level: %IF%THEN%ELSE %DO%END
10:30
Processing Statements Interactively With the iterative %DO statement
08:43
Quiz
7 questions
Coding Exercise
00:19
Coding Exercise: Solution
00:44
Requirements
  • Basic SAS programming skills
Description

Course Highlights:

  • "4 hours and 43 lectures" full coverage on SAS Macro programming --- a SAS advanced topic

    (The contents of this course is also included in SAS Programming Advanced Certification Prep Course: 3 in 1, which is a combined course with 4 individual courses. If you purchased SAS Programming Advanced Certification Prep Course: 3 in 1, you don't need to purchase this course)

  • easy to follow and code-by-code explanation teaching style

  • help prepare you for the SAS Advanced Certification Exam

  • downloadable data and SAS programs used in the course for practice (the course materials are ONLY for practice,  they are protected by copyright)

  • quizzes, coding exercises for practice


Course summary:     

The SAS macro language is often used to reduce the amount of regular SAS code. SAS macro allows us to avoid repetitive sections of code and write SAS programs that are efficient, reusable and dynamic. SAS Macros Language has been widely used for SAS users, especially advanced SAS users.  This course is an intermediate level course. It is designed to help you master SAS Macros Language programming skills and also help prepare you for the advanced SAS certification exam

Course Contents ( 4 hours and 43 lectures):

  • SAS Macro programming introduction:

    SAS Macro Overview;

    Replacing Text Strings Using Macro Variables;

    Generating SAS Code Using Macros;

    Passing Information into a Macro Using Parameters

  • Macro variables and macro Functions:

    Automatic & User-Defined Macro Variables,

    Displaying Macro Variable Values in the SAS Log: using SYMBOLGEN,

    Displaying Macro Variable Values in the SAS Log: using PUT,

    Using Macro Quoting Function to Mask Special Characters:%STR

    Using Macro Functions to Manipulate Character Strings: %UPCASE

    Using Macro Functions to Manipulate Character Strings: %SUBSTR

    Using Macro Functions to Manipulate Character Strings: %SCAN

    Using %SYSFUNC function to execute other SAS functions

    Combining Macro Variable References with Texts in various patterns (text&variable; &variable&variable; &variabletext) 

    Using delimiter for a macro variable name immediately before text

  • Macro variables and macro Functions: Automatic & User-Defined Macro Variables, Displaying Macro Variable Values in the SAS Log: using SYMBOLGEN, Displaying Macro Variable Values in the SAS Log: using PUT, SAS Functions including %STR, %UPCASE, %SUBSTR,  %SCAN, %SYSFUNC,  Combining Macro Variable References with Texts (text&variable; &variable&variable; &variabletext)

  • Creating and using macro variables during execution of a data step:

    Use macro variables during execution of a data step: Symput routine;

    Create multiple macro variables with SYMPUT and Indirect referencing with &&;

    Obtain Macro Variable Values during DATA Step Execution with SYMGET Function

  • Creating a macro variable during execution of  a proc sql step:

    Creating Macro Variables during PROC SQL Step Execution: INTO clause;

    Creating a series of related Macro Variables with the INTO Clause in Proc SQL;

    Creating one macro variable holding a Delimited List of Values with INTO clause

  • Creating and Using Macro Programs:

    Basic Concepts: Defining,  Compiling and Calling Macros;

    Developing and Debugging Macros with options: MPRINT, MLOGIC;

    Using Macro Parameters: Positional Parameters;

    Using Macro Parameters: Keyword Parameters;

    Using Macro Parameters: Mixed Parameters;

    Processing Statements Conditionally at the macro level: %IF%THEN%ELSE %DO%END;

    Processing Statements Interactively With the iterative %DO statement


REFERENCE:    

  • SAS certification prep guide: advanced programming for SAS 9 by SAS Institute   

  • SAS® 9.4 Macro Language: Reference, Fifth Edition 

A  SAS software licence allows SC statistical programming to create and sell video-based SAS programming online courses.

Who this course is for:
  • Students or professionals who wants to write efficient, reusable and dynamic SAS programs with SAS macro language
  • Students and Professionals who wants to become an advanced SAS programmer, and be more demanded and successful in their SAS career
  • Students or professionals who wants to take SAS Programming Advance Certification Exams