BookmarkSubscribeRSS Feed

The Power of SAS SQL

Started ‎05-16-2021 by
Modified ‎08-16-2021 by
Views 5,478
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.

Version history
Last update:
‎08-16-2021 08:27 AM
Updated by:

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Article Tags