SAS Tutorial | Mastering the WHERE Clause in PROC SQL скачать в хорошем качестве

SAS Tutorial | Mastering the WHERE Clause in PROC SQL

Get ready for a romp in the snow with SAS Technical Trainer Charu Shankar and her dog Miko. In this SAS How To Tutorial, Charu shares her PROC SQL expertise and shows you how to master the WHERE clause using real winter weather data. View Code and Download Data Files https://github.com/sascommunities/sas... Chapters 00:00 – Introduction 01:03 – Mandatory clauses in SQL 05:32 – The WHERE clause 08:32 – WHERE filtering on a calculated column 12:03 – WHERE with the AND operator 14:13 - WHERE with the OR/IN operator 17:56 – WHERE with the LIKE operator for pattern matching 20:00 – WHERE with the BOOLEAN 23:55 – Summary Additional Resources ◉ SAS Documentation|Base SAS Procedures Guide, PROC SQL – https://support.sas.com/documentation... ◉ SAS Programming Community – https://communities.sas.com/t5/Progra... Other Videos and Resources from Charu ◉ Speaking to Microsoft Excel with PROC SQL in SAS Viya –    • Speaking to Microsoft Excel with PROC...   ◉ The Power of SAS SQL –    • The Power of SAS SQL   ◉ Step-by-Step Proc SQL –    • SAS Tutorial | Step-by-Step PROC SQL   ◉ SAS Conference Proceedings | The Shape of SAS Code – https://www.sas.com/content/dam/SAS/s... ◉ SAS Blog|Help! Why does the WHERE clause chole on the INPUT function? – https://blogs.sas.com/content/sastrai... ◉ Free webinar | Top 5 Handy SQL Tips – https://www.sas.com/en_us/webinars/ha... SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS 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 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