SAS programming on SAS Macro Language
4.5 (12 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.
110 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SAS programming on SAS Macro Language to your Wishlist.

Add to Wishlist

SAS programming on SAS Macro Language

Learn SAS Macro Programming step by step with examples
4.5 (12 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.
110 students enrolled
Created by Sharon Cheng
Last updated 8/2017
English
Current price: $10 Original price: $35 Discount: 71% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Students will be able to master majority of the SAS Macro programming skills
View Curriculum
Requirements
  • Basic SAS programming skills
Description

Please Note: I have a SAS business license which allows me to create and sell my online prerecorded video-based SAS programming courses.

Course summary:

Do you want to become a more advanced SAS programmer, and be more demanded and successful in your SAS career? If Yes, SAS Programming on SAS Macros Language should be your next programming skill to conquer.

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 programing skills and also help prepare you for the advanced SAS certification exam.

In this course, you will learn essential SAS Macro programming skills including:

  • Macro variables
  • Macro functions
  • Create and using macro variables during execution of a data step
  • Creating a macro variable during execution of a proc sql step
  • Creating and Using Macro Programs

As the same as my other SAS programming courses, this course provides ultimate easy-to-learn environment to make your learning efficient:

  • Each lecture shows hands-on coding examples in SAS programming environment as well as detailed step-by-step explanations
  • The course supplements (including SAS codes and data used in lectures) are in their own formats and stored in Zip folders for easy downloading
  • The SAS programs created in this course are compatible across all SAS programming environments including free SAS environments that offered by SAS.

REFERENCE:

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

SAS® 9.4 Macro Language: Reference, Fifth Edition

Who is the target audience?
  • 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
Compare to Other SAS Courses
Curriculum For This Course
34 Lectures
03:42:18
+
Course Overview and Supplements
3 Lectures 13:32

Course Supplements
00:22

This video is to help you correctly install SAS studio and virtualization software, as well as set up file path/directory in SAS studio.

It is using the same SAS program used in the lecture 'Read data delimited by blanks using list input' in the course 'SAS programming for beginners'. 

Install SAS studio & file path/file directory in SAS studio
10:58
+
SAS Macro Introduction
4 Lectures 19:17

Replacing Text Strings Using Macro Variables
05:56

Generating SAS Code Using Macros
06:04

Passing Information into a Macro Using Parameters
04:29
+
Macro Variables
14 Lectures 01:16:56

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
+
Use macro variables during execution of a data step or a proc SQL step
6 Lectures 53:57

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
+
Creating and Using Macro Programs
7 Lectures 58:36

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
About the Instructor
Sharon Cheng
4.0 Average rating
320 Reviews
1,410 Students
8 Courses
online instructor; a SAS certified programmer

Before I become an online SAS programming instructor, I have worked as a statistician/SAS programmer for 7 years. I am a SAS certified professional and highly proficient in SAS programming, and I enjoy teaching as well. Now I would like to use my SAS programming skills to help people learning SAS in an easy and affordable way. 

My website also offers: 

free SAS programming videos (also available on my YouTube channel SC statistical programming) 

free SAS programming articles

affordable online SAS programming courses at various levels