SAS Tutorial | Getting the Most out of SAS Macro and SQL

Показать описание

Watch as John presents two of his favorite macro and SQL tricks.
Trick 1: Instantly delete every user-defined macro variable in the global symbol table with the DELETEALL macro. This useful tip saves memory and keeps the global symbol table clean of user defined macro variables.
Trick 2: Learn to create a macro variable that contains a delimited list of the unique values of a selected SAS variable from a selected SAS dataset using the VALUELIST macro. The resulting macro variable can be referenced for purposes of report-writing or data-driven macro parameter validation.

Content Outline
00:00 – Overview
02:30 – Learn More links of interest
04:40 – Scenario 1: PROC SQL demo for a detailed listing
07:03 – Scenario 2: Macro program demo and mcompilenote option
12:13 – Scenario 3: Create a macro variable and a report with noprint on and off
15:40 – Scenario 4: Generate a list of distinct values
17:45 – Scenario 5: Building validation lists in a Macro program
23:23 – Scenario 6: Reference one Macro program from another
27:15 – Scenario 7: Validation to allow for human error
33:18 – Scenario 8: Eliminate selected macro variables in the Windowing environment
40:49 – Scenario 9: Eliminate selected macro variables using escape character
42:33 – Scenario 10: Eliminate selected macro variables in SAS Studio and SAS Enterprise Guide

Learn more about SAS Software

SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS #SASGF

ABOUT SAS
SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.

CONNECT WITH SAS