Date:         Sun, 28 Jun 1998 07:47:07 +0100
Reply-To:     roland.rashleigh-berry@virgin.net
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Roland <roland.rashleigh-berry@VIRGIN.NET>
Organization: Wogs at Cause
Subject:      Re: Ordering in PROC REPORT
Content-Type: text/plain; charset=us-ascii

Frank Mwaniki wrote:
>
> Hi all,
> How does one change the ordering in proc report so that the order is in a
> computed variable or some other numeric variable?
> Thanks,
> Frank
 
You can set up variables in the dataset itself that give you the
order you want and then tell proc report they are there but ask
it not to print it. So iy you had two ordering variables called
order1 and order1 to sort your body system and indication then in
the column statement you would have:
 
proc report data=.... nowindows norkeys headline;
  columns order1 bodysys order2 indic ;
  break after bodysys / skip;
  define order1 / order noprint;
  define bodysys / group display;
  define order2 / order noprint;
  define indic / display;
 
Hope that helps.
 
Roland Rashleigh-Berry