In the following PROC
SQL set operation, INOBS=5 is specified. As indicated in the log,
only five rows from each source table, Sasuser.Mechanicslevel1 and
Sasuser.Mechanicslevel2, are used. The resulting table contains 10
rows.
proc sql inobs=5;
select *
from sasuser.mechanicslevel1
outer union corr
select *
from sasuser.mechanicslevel2;
Table 8.4 SAS Log
183 proc sql inobs=5;
184 select *
185 from sasuser.mechanicslevel1
186 outer union corr
187 select *
188 from sasuser.mechanicslevel2;
WARNING: Only 5 records were read from SASUSER.MECHANICSLEVEL1
due to INOBS= option.
WARNING: Only 5 records were read from SASUSER.MECHANICSLEVEL2
due to INOBS= option.
|
Tip
You can use the PROMPT | NOPROMPT
option with the INOBS= and OUTOBS= options so that you are prompted
to stop or continue processing when the limits set by these options
are reached.
CAUTION:
In a simple query,
there might be no apparent differences between using INOBS= or OUTOBS=.
Other times, it is important to choose the correct option. For example,
using the average function on a column with the PROC SQL option INOBS=10
returns an average of only the 10 values read for that column.