The Power of SAS SQL

[#1]

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.

Watch the Presentation

Watch The Power of SAS SQL as presented by Charu Sankar, SAS Education

 

Additional Resources

Download Charu’s code and data sets from the Demos folder in the sas-global-forum-2021 GitHub repository
SAS 9.4 PROC SQL User’s guide
What’s In A Name – SQL Join Or Set?
A database professional’s best friend
Life saver tip for comparing PROC SQL join with SAS data step merge
Go home on time with these 5 PROC SQL Tips
Step-by-Step PROC SQL
Working with Subquery in the SQLProcedure
Know Thy Data: Dictionary tables SAS Global Forum Paper

Join the party! Try the recipes featured in the video.

• Authentic Chana Chickpeas
• Chunky Channa Masala
• Crunchy Currie Chickpea Tacos
• Leblebi (North African Chickpea Soup)
• Portuguese Chickpea Salad
• Spanish-Style Cod and Chickpea Stew
• Za’atar Spiced Crispy Chickpeas
• Chickpea Tuna Salad