SAS Certification Prep Guide, 4th Edition

Resetting Options

Overview

After you specify an option, it remains in effect until you change it, or you re-invoke PROC SQL. You can use the RESET statement to add, drop, or change PROC SQL options without re-invoking the SQL procedure.

General form, RESET statement: RESET <option(s)>; Here is an explanation of the syntax: option(s) lists the options in any order.

Options are additive. For example, you can specify the NOPRINT option in a PROC SQL statement, submit a query, and submit the RESET statement with the NUMBER option, without affecting the NOPRINT option.

Example

Suppose you want to submit two PROC SQL queries in a single PROC SQL step. You want

• both queries to display only the first five rows of output