Carpenter's Complete Guide to the SAS REPORT Procedure

Chapter 6: Refining Our Understanding of the PROC REPORT Step 111

In the following example, CLINNAME appears as a GROUP variable. Since GROUP implies an

ordering of the values, the default presentation would be for the values to appear in ascending

order. The DESCENDING option reverses that order.

* Using DESCENDING;

options nocenter;

title1 'Refining REPORT Appearance';

title2 'Using the DESCENDING Option';

proc report data=rptdata.clinics

(where=(region in('1','2','3'))) nowd;

columns clinname ht wt;

define clinname / group descending;

define ht / analysis mean format=6.1;

define wt / analysis mean format=6.1;

run;

The clinic ...