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
RSS ►https://www.sas.com/rss