The REPORT Procedure

Example 2: Ordering the Rows in a Report

Procedure features:

PROC REPORT statement options:

BREAK statement options:

COMPUTE statement arguments:

AFTER

DEFINE statement options:

ENDCOMP statement

LINE statement:

	with quoted text
	with variable values

Data set:

GROCERY

Formats:

$MGRFMT. and $DEPTFMT.

This example

arranges the rows alphabetically by the formatted values of Manager and the internal values of Department (so that sales for the two departments that sell nonperishable goods precede sales for the two departments that sell perishable goods)
controls the default column width and the spacing between columns
underlines the column headers and writes a blank line beneath the underlining
creates a default summary of Sales for each manager
creates a customized summary of Sales for the whole report.

libname proclib 'SAS-data-library';

options nodate pageno=1 linesize=64 pagesize=60
        fmtsearch=(proclib);

proc report data=grocery nowd
            colwidth=10
            spacing=5
            headline headskip;

   column manager department sales;

   define manager / order order=formatted format=$mgrfmt.;
   define department / order order=internal format=$deptfmt.;

   define sales / analysis sum format=dollar7.2;

   break after manager / ol
                         summarize
                         skip;

   compute after;
      line 'Total sales for these stores were: '
           sales.sum dollar9.2;
   endcomp;

   where sector='se';

   title 'Sales for the Southeast Sector';
 run;