SAS Tutorial | Getting the Most out of SAS Macro and SQL скачать в хорошем качестве

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 SAS Macro Language 1: Essentials class – https://support.sas.com/edu/schedules... SAS SQL 1: Essentials class – https://support.sas.com/edu/schedules... Free SAS Online Training – https://www.sas.com/en_us/training/of... Contact SAS® – https://www.sas.com/en_us/contact.geo... SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS #SASGF https://www.youtube.com/SASUsers?sub_... 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 SAS ► https://www.sas.com/contact SAS Customer Support ► https://support.sas.com SAS Communities ► https://communities.sas.com SAS Analytics Explorers ► https://explorers.sas.com Facebook ►   / sassoftware   Twitter ►   / sassoftware   LinkedIn ►   / sas   Blogs ► https://blogs.sas.com RSS ►https://www.sas.com/rss