SAS SQL Procedure User’s Guide : 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

PROC SQL Summary Functions

Appendixes

SQL Macro Variables and System Options

PROC SQL and the ANSI Standard

Data Sets for Examples in SQL Procedure Reference

Last updated: October 8, 2026