Скачать или смотреть How to Use a Macro Variable in SAS ODA – Demonstration

*Note: I may be compensated, but you will not be charged, if you click on the links below.

💡 If you are a public health practitioner looking for a targeted program for enhancing your data science skills, please sign up to participate in my 30-minute market research interview so I can get your feedback: https://buff.ly/3UnLqmq

In this video, Monika Wahi shows you how to use WHERE criteria with PROC FREQ in SAS OnDemand for Academics to run frequency tables.

GITHUB
Access code and dataset here: https://buff.ly/3xxhcEB

💿Need help importing the dataset? Watch this video:    • How to Import a SAS Dataset into SAS ODA –...  
📀Want a better understanding of PROC FREQ? Watch:
💿 this video:    • How to Run Frequencies in SAS ODA with PRO...   and
📀 this video:    • How to Run Frequencies Using WHERE Criteri...  

COURSE & BOOK
💿Want to start using free, online SAS OnDemand for Academics – but don’t know how? Take Monika’s FREE online course, “Getting Started with SAS OnDemand for Academics (ODA): https://buff.ly/3CQVPxG
📀Want to run a SAS data warehouse? Learn how by reading Monika’s book, “Mastering SAS Programming for Data Warehousing”: https://buff.ly/31Hz1mg

WANT TO SUPPORT MONIKA ON SOCIAL MEDIA?
❤️Subscribe to Monika's YouTube channel: https://buff.ly/2W6ijuc
🧡Follow/connect with Monika on LinkedIn:   / dethwench  
💛Follow Monika on Twitter:   / phexaminer  
💚Try Monika’s courses on LinkedIn Learning: https://linkedin-learning.pxf.io/NKN0JO
💙Try Monika's boutique research methods and data science courses here: https://buff.ly/3zM243P

Timestamps for easy navigation:
00:55 We will be demonstrating a macro variable in the context of a PROC FREQ. Therefore, it might be helpful to first watch:
💿This video, which shows you how to import a SAS dataset into SAS ODA:    • How to Import a SAS Dataset into SAS ODA –...  
📀This video, which explains PROC FREQ:    • How to Run Frequencies in SAS ODA with PRO...   and
💿This video, which shows how to set WHERE criteria in PROC FREQ:    • How to Run Frequencies Using WHERE Criteri...  
01:27 Review of PROC FREQ code at the top – the DIABETE3 variable, and the frequencies by _STATE = 12 (Florida)
02:24 We can make the code more flexible by not having to hardcode _STATE = 12 (Florida) and allowing us to change the state each time it runs through using a macro variable
02:54 Review of revised code using a macro variable and the %LET statement
03:33 We created a macro variable called selected_state, and set it to the value of 12
03:42 Reviewing PROC FREQ code with the new macro variable in it instead of hardcoding
03:54 How to refer to the macro variable in the WHERE criterion – using the ampersand (&)
04:33 How to refer to the macro variable in the title
05:11 Running code and reviewing output
05:31 Reviewing the log file – looks identical to hardcoding, so it is verified.
05:51 Testing the macro variable function using other values of _STATE (_STATE = 25)
06:04 Running revised code and reviewing output
06:24 Reviewing the log file to confirm evaluation of WHERE clause to 25

How to Use a Macro Variable in SAS ODA – Demonstration