The REPORT Procedure

Example 8: Condensing a Report into Multiple Panels

Procedure features:

PROC REPORT statement options:

	FORMCHAR=
	HEADLINE
	LS=
	PANELS=
	PS=
	PSPACE=

BREAK statement options:

SKIP

Other features:

SAS system option FORMCHAR=

Data set:

GROCERY

Formats:

$MGRFMT. and $DEPTFMT.

The report in this example

uses panels to condense a two-page report to one page. Panels compactly present information for long, narrow reports by placing multiple rows of information side by side.
uses a default summary to place a blank line after the last row for each manager.
changes the default underlining character for the duration of this PROC REPORT step.

Program

libname proclib 'SAS-library';

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

proc report data=grocery nowd headline
            formchar(2)='~'
            panels=99 pspace=6
            ls=64 ps=18;

   column manager department sales;

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

   break after manager / skip;

   where sector='nw' or sector='sw';

   title 'Sales for the Western Sectors';
run;

Output

                 Sales for the Western Sectors                 1

 Manager  Department    Sales      Manager  Department    Sales
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 Adams    Paper        $40.00                                  
          Canned      $225.00      Reveiz   Paper        $60.00
          Meat/Dairy  $350.00               Canned      $420.00
          Produce      $80.00               Meat/Dairy  $600.00
                                            Produce      $30.00
 Brown    Paper        $45.00                                  
          Canned      $230.00      Taylor   Paper        $53.00
          Meat/Dairy  $250.00               Canned      $120.00
          Produce      $73.00               Meat/Dairy  $130.00
                                            Produce      $50.00
 Pelfrey  Paper        $45.00                                  
          Canned      $420.00                                  
          Meat/Dairy  $205.00                                  
          Produce      $76.00

Top of Page