Available in:
Efficiency Tips for Database Programming in SAS®
ETDP : ETDP1F
This class teaches you how to tune your SAS programs for faster execution, especially those that access relational database tables using SAS/ACCESS interfaces or SAS Viya data connectors.
Learn How To
- Use SAS options to evaluate efficiency when accessing database data.
- Tune SAS programs for faster processing.
- Understand how relational database tables are accessed on the SAS Compute Server and in SAS Cloud Analytic Services (CAS).
- Understand conditions that can prevent SQL pass-through for execution in the database.
- Modify SAS programs to maximize pass-through to the database and minimize execution time.
Who Should Attend
Data scientists, data analysts, and SAS programmers
Prerequisites
Before attending this course, you should either have at least six months of experience writing SAS programs that include PROC SQL code or have completed the SAS SQL 1: Essentials course and used PROC SQL in SAS for at least one month. The course builds on concepts presented in both the SAS Programming 1: Essentials and SAS SQL 1: Essentials courses, and it is not recommended for beginning SAS software users. Specifically, you should be able to:
- Access existing SAS data libraries using a LIBNAME statement.
- Write and submit SAS programs to access and manipulate data using the DATA step and PROC SQL.
- Read and interpret the SAS log.
- Diagnose and correct syntax errors in SAS.
SAS Products Covered
SAS/ACCESS;Base SAS
Course Outline
Foundational Concepts
- Introduction.
- The SAS/ACCESS LIBNAME Engine.
- Implicit Pass-Through Basics.
- Tuning SAS Programs.
- Mitigating Common Problems.
- Rules of Thumb for LIBNAME Access.
- Cross-Library Operations.
- Accelerating Cross-Library Operations.
- Implicit versus Explicit Pass-Through.
- Explicit Pass-Through with PROC SQL.
- Explicit Pass-Through with PROC FEDSQL.
- Introduction to CAS.
- SQL Pass-Through in CAS.
- Working with CAS Tables.
Live Class Schedule
Duration: 7 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
Live Class Schedule
SOLD SEPARATELY
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.