Optimizing Your SQL Usage
Overview: Optimizing Your SQL Usage
Tracing and Evaluating SQL Generation
About the DBIDIRECTEXEC System Option
Passing Functions to the DBMS Using PROC SQL
Date Arithmetic with Queries
Passing Joins to the DBMS
When Passing Joins to the DBMS Fails
Using the DIRECT_SQL= LIBNAME Option
Passing the WHERE Clause to the DBMS
Advanced PROC SQL Optimization Hints
Last updated: February 3, 2026