Date:         Fri, 1 Nov 2002 14:13:00 -0500
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 freq column order
Comments: cc: William Kossack <kossackw@NJC.ORG>
Content-Type: text/plain

> From: William Kossack [mailto:kossackw@NJC.ORG]
> How can I reverse the order of columns outputed by proc freq?
>
> I'm not sure I want to do it with formats because I have a
> couple hundred binary variables and they are not all 0,1 (or
> 1, 0 which is the order I want the columns in).

take a look at your FREQ options:

proc FREQ data  = <libref.>DATA
          order = data           %*default,formatted freq internal;
          ;
          tables  Var
                / noprint
          out   = FREQ;

if none of those work, consider:

proc SORT data  = FREQ;
          by      descending Var;

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

"Nothing is particularly hard
if you divide it into small jobs."
- Henry Ford, Industrialist