Date:         Thu, 9 Nov 2006 17:14:28 -0500
Reply-To:     Ken Avery <a79krgm@PRODIGY.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ken Avery <a79krgm@PRODIGY.NET>
Subject:      Frequency Summary (TABULATE OR REPORT) ?

Hello,

I'm trying to create a simple frequency summary organized in the layout
shown below (and using data 'TESTDATA'). With some effort I'm sure I can
create the table/report with DATA _NULL_.

However, I'd like funnel the data through a procedure (TABULATE OR REPORT)
using ODS. It seems simple, but I'm drawing a blank. I'd be interested in
hearing any suggestions that produces the design shown below. - Thanks

/*           PURCHASE AMOUNT CATEGORY COUNTS

                A. < $21.01   B. $21.01      C. $117.26 +   D. MISSING
                         -< $117.26
BIKER

     PURCHASE 1           2     2   2  0
     PURCHASE 2           1     3   1  1
     NET                 -1     1  -1  1

HIKER
     PURCHASE 1
     PURCHASE 2
     NET

RUNER
     PURCHASE 1
     PURCHASE 2
     NET

UNKNOWN
     PURCHASE 1
     PURCHASE 2
     NET
*/

DATA TESTDATA;
INPUT SPORTLINE $ PURCHASE_1 PURCHASE_2;
DATALINES;
RUNNER 13.5 17.25
HIKER 200.75 215.89
RUNNER 22.05 1.01
BIKER 322.55 17.28
UNKNOWN 52.55 29.23
RUNNER 16.34 16.01
HIKER 111.11 117.26
UNKNOWN 51.78 429.11
RUNNER 1.57 399.12
BIKER 456.55 21.01
BIKER 26.55
RUNNER 100.5
UNKNOWN 77.55
HIKER 401.75
RUNNER 522.05 21.01
UNKNOWN 652.55 629.23
BIKER 72.55 73.01
HIKER 11.11 17.26
HIKER 112.11 112.99
HIKER 312.11 52.99
BIKER 19.43 29.77
UNKNOWN 1.44 9.12
BIKER 9.43 669.77
RUN;

PROC FORMAT;
 VALUE BUYRANGE
 . = "D. MISSING "
 0-< 21.010 ="A. < $21.01 "
 21.010 -< 117.260 ="B. $21.01 -< $117.26 "
 117.260 - HIGH ="C. $117.26 + "
;
RUN;