PROC SQL Options

A Brief Overview

The SQL procedure offers a variety of options that control processing. Some options control execution. For example, you can limit the number of rows that are read or written during a query. Other options control output. For example, you can control the number of rows to be displayed in your output.

PROC SQL Statement Syntax

Syntax, PROC SQL statement:
PROC SQL <option(s)>;
option(s)
names the option(s) to be used.
After you specify an option, it remains in effect until you change it or you reset it.
The following tables list the options that are covered in this section. A description and an example of each option appear in the following sections.
Table 1.1 Controlling Execution Options ...

Get SAS Certified Professional Prep Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.