SAS(R) SQL Methods and More

Course Details
Code: SQLMM
Tuition (USD): $325.00 • Classroom (4 hours)

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.

Skills Gained

  • 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

Prerequisites

  • 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
  • read and interpret the SAS log
  • diagnose and correct syntax errors
  • access and manipulate data in SAS data libraries.

Course Details

Introduction

  • course overview
  • course logistics

Performance Considerations

  • computer resources and efficiency
  • benchmarking

Implicit versus Explicit Pass-Through

  • implicit pass-through with the LIBNAME statement
  • using data set options with implicit pass-through
  • explicit pass-through in PROC SQL and PROC FedSQL

Perplexing Performance Problems

  • correlated subqueries
  • cross-library operations

Learning More

  • learning more