SAS Tutorial | Step-by-Step PROC SQL скачать в хорошем качестве

SAS Tutorial | Step-by-Step PROC SQL

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/s... 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/resour... SAS 9.4 SQL Procedure User’s Guide – https://go.documentation.sas.com/?doc... PROC SQL Syntax Order blog – https://blogs.sas.com/content/sastrai... PROC SQL DICTIONARY Tables PDF – https://www.pharmasug.org/proceedings... Working with Subquery in the SQL Procedure paper: Zhang, Lei, Yi, Danbo – https://www.lexjansen.com/nesug/nesug... Boolean in SQL blog – https://blogs.sas.com/content/sastrai... Learn more about SAS Software Free SAS Online Training – https://www.sas.com/en_us/training/of... Contact SAS® – https://www.sas.com/en_us/contact.geo... SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS #SASGF https://www.youtube.com/SASUsers?sub_... 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 ►   / sassoftware   Twitter ►   / sassoftware   LinkedIn ►   / sas   Blogs ► https://blogs.sas.com RSS ►https://www.sas.com/rss