The NUMBER | NONUMBER option specifies whether the output from a query should include a column named ROW, which displays row numbers. NONUMBER is the default. The option is similar to the NOOBS option in the PRINT procedure.

The following PROC SQL step specifies the NUMBER option. Output from the step includes a column named Row, which contains row numbers.

proc sql inobs=10 number;
   select flightnumber, destination 
      from sasuser.internationalflights;

In some cases, double-spacing your output can make it easier to read. The DOUBLE | NODOUBLE option specifies whether PROC SQL output is double-spaced. The default is NODOUBLE.

The following PROC SQL step specifies the DOUBLE option. The listing output from this step is double spaced. The HTML output from this step remains single-spaced.

proc sql inobs=10 double; 
   select flightnumber, destination 
      from sasuser.internationalflights;

The FLOW | NOFLOW | FLOW=n | FLOW=n m option controls the appearance of wide character columns in listing output. The FLOW option causes text to be flowed in its column instead of wrapping the entire row. Specifying n sets the width of the flowed column. Specifying n and m floats the width of the column between limits to achieve a balanced layout.

The following PROC SQL step does not specify the FLOW option. Notice that in the output the name and values for the column ZipCode appear under the name and values for the column FFID due to the wide character columns.

proc sql inobs=5;
   select ffid, membertype, name, address, city, 
          state, zipcode
      from sasuser.frequentflyers
      order by pointsused;

Specifying flow=10 15 causes the text within each character column to float between 10 and 15 spaces, which prevents the ZipCode column from wrapping underneath the FFID column.

 proc sql inobs=5 flow=10 15;
    select ffid, membertype, name, address, city, 
           state, zipcode
       from sasuser.frequentflyers
       order by pointsused;