Suppose you want to
quickly review the types of values that are stored in a table, without
printing out all the rows. The following PROC SQL query selects data
from the table Sasuser.Flightschedule, which contains more than 200
rows. To print only the first 10 rows of output, you add the OUTOBS=
option to the PROC SQL statement.
proc sql outobs=10;
select flightnumber, date
from sasuser.flightschedule;
|
|
When you limit the number
of rows that are displayed, a message similar to the following appears
in the SAS log.
Table 2.2 SAS Log
WARNING: Statement terminated early due to OUTOBS=10 option.
|
Note: The OUTOBS= and INOBS= options
affect tables that are created by using the CREATE TABLE statement
and your report output.
Note: In many of the examples in
this chapter, OUTOBS= is used to limit the number of rows that are
displayed in output.