Specifying SQL Options
Remember that PROC SQL options
are specified in the PROC SQL statement.
General form, PROC SQL
statement:
PROC SQL <option(s)>;
option(s)
names the option(s)
to be used.
|
CAUTION:
After you specify an option, it remains
in effect until you change it or you re-invoke PROC SQL.
The following tables
list the options for controlling processing that are covered in this
chapter. A complete description and an example of each option appears
in the following sections.
To do this...
|
Use this option...
|
---|---|
Restrict the number
of input rows
|
INOBS=
|
Restrict the number
of output rows
|
OUTOBS=
|
Get SAS Certification Prep Guide, 4th Edition 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.