Date:         Wed, 16 Oct 2002 14:45:50 -0400
Reply-To:     "Fehd, Ronald J. (PHPPO)" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J. (PHPPO)" <rjf2@CDC.GOV>
Subject:      Re: proc format order
Comments: cc: CKalisetty <ckalisetty@AOL.COM>
Content-Type: text/plain

> From: CKalisetty [mailto:ckalisetty@AOL.COM]
> Is there any way I can change the order in proc format.?
> proc format
> value $rep
>  'Y' ='yes'
>  'N' = 'no'
>  'U' = 'not known'
> ;
> It seems SAS is using some soring order of it's own
> in the final listing.
> What I want to do is get the final list like
>
>  'not known'
>  'yes'
>  'no'
> Can I change the order?

where do you want this new order to show up?

there are options in proc FREQ to change the display order:

proc FREQ data  =  LIBRARY.WHATEVER
          order =  data           %*default,formatted freq internal;
          ;

Ron Fehd  the macro maven  CDC Atlanta GA USA RJF2@cdc.gov