How to Run Frequencies Using WHERE Criteria in SAS ODA – Demonstration
Channel: Monika Wahi
Date: 2021-11-24

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

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: https://youtu.be/mHhT0Bs4Rmo
📀Want an introduction to PROC FREQ? Watch this video: https://youtu.be/0jmzYjSGdnI 

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: https://www.linkedin.com/in/dethwench/ 
💛Follow Monika on Twitter: https://twitter.com/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:59 In this video, we are using the WHERE clause with PROC FREQ.
💿 If you have trouble getting the dataset into SAS, watch this video: https://youtu.be/mHhT0Bs4Rmo
📀 If you have trouble running PROC FREQ without the WHERE clause, watch this video: https://youtu.be/0jmzYjSGdnI
01:21 Description of the example dataset and previous video
02:01 New in this video: We are going to filter the output by restricting states through the WHERE clause which sets criteria
02:20 Discussion of DIABETE3 (diabetes) variable subject of the one-way frequency
02:44 Explanation of syntax around setting WHERE criteria in our code
03:03 Example of adding a title to PROC FREQ output
03:29 Running code and examining output
03:50 Reviewing the log file

How to Run Frequencies Using WHERE Criteria in SAS ODA – Demonstration