The Power of SAS SQL скачать в хорошем качестве

The Power of SAS SQL

PROC SQL is a powerful language that can express many of your queries simply and with clarity. In this presentation, you learn to maximize human and computing efficiency with multiple SQL techniques. The instructor has collected many best practices from helping customers with real-world business problems after teaching SAS for more than 10 years to thousands of learners. Throughout the session, you learn efficiency tips to help improve performance. Users who are continuously improving processes and looking for PROC SQL efficiencies to analyze and process data will benefit from this session. You will learn how to: • Craft an efficient query using code. • Join a table using joins, subqueries and inline views. • Use a macro efficiency tip interfacing with PROC SQL to store data for reuse. PRESENTER: Charu Shankar, SAS Education Content Outline 00:00 - Introduction 01:45 - Meet the Chefs and their dishes 02:28 - Data Overview 07:32 - Section 1: Craft An Efficient Query (concept) 09:01 - Section 1: Craft An Efficient Query (code) 18:20 - Section 1: Grouping (concept) 21:05 - Section 1: Grouping (code) 31:13 - Section 1: Recap 31:30 - Section 2: 3 Ways To Join Tables (concept) 34:13 - Section 2: 3 Ways To Join Tables (code) 40:34 - Section 2: Subquery (concept) 42:29 - Section 2: Subquery (code) 46:46 - Section 2: InlineView (code) 50:27 Section 3: Store SQL Query In Macro (concept) 53:45 Section 3: Store SQL Query In Macro (code) 1:05:08 Closing Remarks Additional resources ◉ Download Charu’s code and data sets from the Demos folder in the sas-global-forum-2021 GitHub repository - https://github.com/sascommunities/sas... ◉ SAS 9.4 Proc Sql User’s guide - https://go.documentation.sas.com/?cdc... ◉ What’s In A Name – SQL Join Or Set? - https://blogs.sas.com/content/sastrai... ◉ A database professional’s best friend - https://blogs.sas.com/content/sastrai... ◉ Life saver tip for comparing PROC SQL join with SAS data step merge - https://blogs.sas.com/content/sastrai... ◉ Go home on time with these 5 PROC SQL Tips - https://blogs.sas.com/content/sastrai... ◉ Step-by-Step PROC SQL -    • SAS Tutorial | Step-by-Step PROC SQL   ◉ Working with Subquery in the SQLProcedure - https://www.lexjansen.com/nesug/nesug... ◉ Know Thy Data: Dictionary tables SAS Global Forum Paper - https://support.sas.com/resources/pap... Join the party! Try the recipes featured in the video. ◉ Authentic Chana Chickpeas - https://www.drukgirl.com/authentic-ch... ◉ Chunky Channa Masala - https://charuyoga.com/2013/12/30/chun... ◉ Crunchy Currie Chickpea Tacos - https://www.onegreenplanet.org/vegan-... ◉ Leblebi (North African Chickpea Soup) - https://alexandracooks.com/2016/01/28... ◉ Portuguese Chickpea Salad - https://www.homemadeinterest.com/port... ◉ Spanish-Style Cod and Chickpea Stew - https://www.deliciousmagazine.co.uk/r... ◉ Za’atar Spiced Crispy Chickpeas - https://jamiegeller.com/recipes/zaata... ◉ Chickpea Tuna Salad - https://www.wellplated.com/chickpea-t... 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