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.
