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.html?ctry=us&crs=MAC1
SAS SQL 1: Essentials class – https://support.sas.com/edu/schedules.html?ctry=us&crs=SQL1
Free SAS Online Training – https://www.sas.com/en_us/training/offers/free-training.geo.html?utm_source=youtube.com&utm_medium=referral&utm_campaign=sgf-4406690&utm_content=sM3sidYPT-o
Contact SAS® – https://www.sas.com/en_us/contact.geo.html?utm_source=youtube.com&utm_medium=referral&utm_campaign=sgf-4406690&utm_content=sM3sidYPT-o
SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS #SASGF
https://www.youtube.com/SASUsers?sub_confirmation=1
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 ► https://www.facebook.com/SASsoftware
Twitter ► https://www.twitter.com/SASsoftware
LinkedIn ► https://www.linkedin.com/company/sas
Blogs ► https://blogs.sas.com
RSS ►https://www.sas.com/rss
Видео SAS Tutorial | Getting the Most out of SAS Macro and SQL канала SAS Users
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.html?ctry=us&crs=MAC1
SAS SQL 1: Essentials class – https://support.sas.com/edu/schedules.html?ctry=us&crs=SQL1
Free SAS Online Training – https://www.sas.com/en_us/training/offers/free-training.geo.html?utm_source=youtube.com&utm_medium=referral&utm_campaign=sgf-4406690&utm_content=sM3sidYPT-o
Contact SAS® – https://www.sas.com/en_us/contact.geo.html?utm_source=youtube.com&utm_medium=referral&utm_campaign=sgf-4406690&utm_content=sM3sidYPT-o
SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS #SASGF
https://www.youtube.com/SASUsers?sub_confirmation=1
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 ► https://www.facebook.com/SASsoftware
Twitter ► https://www.twitter.com/SASsoftware
LinkedIn ► https://www.linkedin.com/company/sas
Blogs ► https://blogs.sas.com
RSS ►https://www.sas.com/rss
Видео SAS Tutorial | Getting the Most out of SAS Macro and SQL канала SAS Users
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![SAS Tutorial | Beyond the Basics of Macro](https://i.ytimg.com/vi/P1LZ2_sjvtc/default.jpg)
![PROC SQL part -1 Basic syntax select and others](https://i.ytimg.com/vi/eruwV5wTfJY/default.jpg)
![MERGE VS JOIN in SAS | MERGE and JOIN in SAS | PROC SQL Joins VS SAS Merge |](https://i.ytimg.com/vi/C5EbMqEk8xQ/default.jpg)
![Best Clinical SAS Training From Hyderabad India](https://i.ytimg.com/vi/heZtPyAGqVc/default.jpg)
![Twenty Ways to Run Your SAS Program Faster and Use Less Space](https://i.ytimg.com/vi/mXBaDFCZLX0/default.jpg)
![Session 20- Character Functions in SAS (I)](https://i.ytimg.com/vi/iGj3wyK0sdY/default.jpg)
![how to Install SAS University Edition (SAS studio): the complete and step-by-step guide](https://i.ytimg.com/vi/G4a-kYzW42k/default.jpg)
![SAS Tutorial | Doing More with SAS Enterprise Guide: Tips and Advanced Techniques](https://i.ytimg.com/vi/GX9qqfVIpM8/default.jpg)
![SAS Tutorial | Using SAS Macro Variable Lists to Create Dynamic Data-Driven Programs](https://i.ytimg.com/vi/fFfxPqNzNJc/default.jpg)
![Finding count of non missing variables in a row with SAS](https://i.ytimg.com/vi/Xrkfyfn1Uok/default.jpg)
![SAS Formats and Informats | MaziWorld - SAS Online Training Videos](https://i.ytimg.com/vi/vhfwLBUjUAk/default.jpg)
![Arrays in SAS](https://i.ytimg.com/vi/s2O6h3fJFWA/default.jpg)
![How to Use SAS - Special Topic - Macro Coding and Macro Variables](https://i.ytimg.com/vi/bEXKgIJSfzg/default.jpg)
![SAS Clinical TLFS DM Listing - +918008079304](https://i.ytimg.com/vi/Sr4qXzlIt_Y/default.jpg)
![SAS Tutorial | SAS SQL Methods and More](https://i.ytimg.com/vi/BX4ko81HR_g/default.jpg)
![SAS Tutorial | Migrating SAS 9.4 Jobs to SAS Viya](https://i.ytimg.com/vi/VV7j4UsiXBw/default.jpg)
![SAS Tutorial | How to Create Macro Variables and Use Macro Functions](https://i.ytimg.com/vi/ODq6V69IX2Y/default.jpg)
![SAS Clinical ADaM ADSL--+918008079304 [Vinay Praveen ]](https://i.ytimg.com/vi/RmBb1U5-nHQ/default.jpg)
![SAS Tutorial | Merging Data Sets in SAS using SQL](https://i.ytimg.com/vi/dhf747bz_nE/default.jpg)