Date:         Sat, 23 Aug 2003 19:50:10 +0100
Reply-To:     Roland <roland@RASHLEIGH-BERRY.FSNET.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Roland <roland@RASHLEIGH-BERRY.FSNET.CO.UK>
Organization: Universe Monitors
Subject:      Re: Formattin the Report in Proc Format

"Anbu Arasu" <aarumugam@STTHOMAS.EDU> wrote in message
news:200308231832.h7NIWrc08850@listserv.cc.uga.edu...
> Thanks for the reply. Can you give an example. Because I am a beginner.
> Thanks for the effort;

It can't be done all in one proc report step. You have got to get the
dataset out that has the labels "N" "Mean" etc. and assign a numeric value
so that you can sort in the right order. And then you define your sort
variable as the column in front of your category variable (the one that has
the name "N" "Mean" as its contents) and then declare that as "order
noprint" to proc report. And then it should come out in the right order.


I have a macro that does thi sort of reporting but I don't know if it would
be suitable. Bt it should not detract from what I have suggested above.

http://www.datasavantconsulting.com/roland/sumtab.sas

Trouble is it calls loads of other macros as well.

Roland