This class teaches you how to improve the performance of SQL queries, and how to troubleshoot and tune other SAS processes that access relational database tables using SAS/ACCESS interfaces.
discuss formal benchmarking and tuning of production SQL queries
recognize correlated subqueries and the alternate techniques that can be used to improve performance
use SAS options to evaluate query efficiency
understand conditions that can prevent SQL pass-through for execution in the database
modify SQL queries to maximize pass-through capabilities.
Who Can Benefit
Data analysts and SAS programmers
Before attending this course, you should have at least six months of experience writing SAS programs including PROC SQL code, or have completed the SAS(R) SQL 1: Essentials course and have used PROC SQL in SAS for at least one month. The course builds on concepts presented in both the SAS(R) Programming I: Essentials and SAS(R) SQL 1: Essentials courses, and is not recommended for beginning SAS software users. Specifically, you should be able to
write and submit SAS programs, including PROC SQL steps
https://www.exitcertified.com/it-training/sas/foundation/programming/-51252-detail.htmlSQLMMSAS(R) SQL Methods and Morehttps://assets.exitcertified.com/assets/CourseImages/0b00c2bf0a/AdobeStock_112581843__FitMaxWzEwMDAsMTAwMF0.jpg325.00USDInStock/Training/SAS/Foundation/ProgrammingThis class teaches you how to improve the performance of SQL queries, and how to troubleshoot and tune other SAS processes that...325.00SASClassroom2017-02-24T01:34:44+00:00USD