This tutorial is for users wishing to learn PROC SQL in a step-by-step approach. PROC SQL is a powerful query language that can sort, summarize, subset, join and print results all in one step. Users who are continuously improving their analytical processing will benefit from this video. Follow along as Charu demonstrates the following elements to master PROC SQL: 1. Understand the syntax order in which to submit queries to PROC SQL. 2. Internalize the logical order in which PROC SQL processes queries. 3. Manage metadata using dictionary tables. 4. Join tables using join conditions like inner join and reflexive join. 5. Summarize data using Boolean operations. Download Data Files Here's the data Charu uses on GitHub – https://github.com/CharuSAS/SQL Proceedings Paper – https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/5167-2020.pdf Content Outline 00:00 – Introduction and Agenda 00:52 – Overview of PROC SQL 02:22 – Examining Syntax order 07:50 – Summarizing data using the Boolean Operation 22:31 – Managing metadata using DICTIONARY Tables and Views 28:40 – Join Tables using Inner Join and Reflexive Join Connections 38:42 – Logical Query Processing Order 41:44 – Step-by-Step breakdown of SQL Phases Additional resources Resource Hub for Data Professionals – https://www.sas.com/sas/offers/resource-hub/roles/data-professional.html?utm_source=youtube.com&utm_medium=referral&utm_campaign=sgf-4406690&utm_content=1xyHE8qI9Hk SAS 9.4 SQL Procedure User’s Guide – https://go.documentation.sas.com/?docsetId=sqlproc&docsetTarget=titlepage.htm&docsetVersion=9.4&locale=en PROC SQL Syntax Order blog – https://blogs.sas.com/content/sastraining/2012/04/24/go-home-on-time-with-these-5-proc-sl-tips/ PROC SQL DICTIONARY Tables PDF – https://www.pharmasug.org/proceedings/2018/BB/PharmaSUG-2018-BB11.pdf Working with Subquery in the SQL Procedure paper: Zhang, Lei, Yi, Danbo – https://www.lexjansen.com/nesug/nesug98/dbas/p005.pdf Boolean in SQL blog – https://blogs.sas.com/content/sastraining/2012/05/10/1-sas-programming-tip-for-2012/ Learn more about SAS Software 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=1xyHE8qI9Hk Contact SAS® – https://www.sas.com/en_us/contact.geo.html?utm_source=youtube.com&utm_medium=referral&utm_campaign=sgf-4406690&utm_content=1xyHE8qI9Hk 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 RSShttps://www.sas.com/rss