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=
|
|
To do this...
|
Use this option...
|
|---|---|
|
Double-space the output
|
DOUBLE | NODOUBLE
|
|
Flow characters within
a column
|
FLOW | NOFLOW | FLOW=n |
FLOW=n m
|
|
To do this...
|
Use this option...
|
|---|---|
|
Specify whether PROC
SQL writes timing information for each statement to the SAS log
|
STIMER | NOSTIMER
|
Note: For a complete list of options,
see the SAS documentation for the SQL procedure.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.