This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SAS programming on SAS Macro Language
Course Overview and Supplements
Course Overview (2:12)
Course Supplements (0:22)
SAS Macro Introduction
SAS Macro Overview (2:42)
Replacing Text Strings Using Macro Variables (5:28)
Generating SAS Code Using Macros (5:33)
Passing Information into a Macro Using Parameters (4:01)
Quiz
Coding Exercise
Coding Exercise: Solution
Macro Variables
SAS macro variables: Introduction (5:08)
Automatic macro variables (3:05)
User-Defined Macro Variables (5:40)
Displaying Macro Variable Values in the SAS Log: using SYMBOLGEN (4:17)
Displaying Macro Variable Values in the SAS Log: using PUT (4:13)
Using Macro Quoting Function to Mask Special Characters:%STR (5:07)
More on Using Macro Quoting Functions to Mask Special Characters:%STR (4:26)
Using Macro Functions to Manipulate Character Strings: %UPCASE (4:14)
Using Macro Functions to Manipulate Character Strings: %SUBSTR (5:28)
Using Macro Functions to Manipulate Character Strings: %SCAN (4:23)
Using %SYSFUNC function to execute other SAS functions (4:17)
Combining Macro Variable References with Texts (7:50)
Using delimiter for a macro variable name immediately before text (4:34)
More on using delimiter for a macro variable name immediately before text (6:14)
Quiz
Coding Exercise
Coding Exercise: Solution
Use macro variables during execution of a data step or a proc SQL step
Use macro variables during execution of a data step: Symput routine (13:46)
Create multiple macro variables with SYMPUT and Indirect referencing with && (9:49)
Obtaining Macro Variable Values during DATA Step Execution with SYMGET Function (4:16)
Creating Macro Variables during PROC SQL Step Execution: INTO clause (6:41)
Creating a series of related Macro Variables with the INTO Clause in Proc SQL (6:59)
Creating one macro variable holding a Delimited List of Values with INTO clause (5:27)
Quiz
Coding Exercise
Coding Exercise: Solution
Creating and Using Macro Programs
Basic Concepts: Defining, Compiling and Calling Macros (5:11)
Developing and Debugging Macros with options: MPRINT, MLOGIC (5:37)
Using Macro Parameters: Positional Parameters (8:45)
Using Macro Parameters: Keyword Parameters (9:04)
Using Macro Parameters: Mixed Parameters (6:08)
Processing Statements Conditionally at the macro level: %IF%THEN%ELSE %DO%END (9:31)
Processing Statements Interactively With the iterative %DO statement (7:44)
Quiz
Coding Exercise
Coding Exercise: Solution
Creating Macro Variables during PROC SQL Step Execution: INTO clause
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock