Controlling Output

Including a Column of Row Numbers

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.

Example

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;
PROC SQL Output with Number Option

Double-Spacing Output

In some cases, double-spacing your output can make it easier to read. The DOUBLE | NODOUBLE option ...

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.

Start your free trial