SAS 9.4 SQL Procedure User’s Guide, Fourth Edition : SAS Help Center

Syntax Conventions for the SAS Language

Using the SQL Procedure

Introduction to the SQL Procedure

Retrieving Data from a Single Table

Retrieving Data from Multiple Tables

Creating and Updating Tables and Views

Programming with the SQL Procedure

Practical Problem-Solving with PROC SQL

SQL Procedure Reference

SQL Procedure Components

Appendixes

SQL Macro Variables and System Options

PROC SQL and the ANSI Standard

Example Code Shown in Using the SQL Procedure

Data Sets for Examples in SQL Procedure Reference

Last updated: April 9, 2026