Date:         Fri, 16 Oct 2009 08:10:05 -0500
Reply-To:     "Data _null_;" <iebupdte@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Data _null_;" <iebupdte@GMAIL.COM>
Subject:      Re: PROC FREQ question or maybe TABULATE?
Comments: To: Peter Flom <peterflomconsulting@mindspring.com>
In-Reply-To:  <25550815.1255697717488.JavaMail.root@elwamui-royal.atl.sa.earthlink.net>
Content-Type: text/plain; charset=ISO-8859-1

EXCEL are you kidding?


proc freq data=sashelp.class order=freq;
   tables age sex;
   run;

On 10/16/09, Peter Flom <peterflomconsulting@mindspring.com> wrote:
> Hi all
>
> Is there an easy way to get PROC FREQ to output the table in order of the frequencies?
>
> e.g. I have
>
> proc freq data = poly;
>  table pattern2;
> run;
>
> where patern2 is a character variable.  I'd like the most common pattern2 to be first, then the next most common, etc.
>
> If it isn't simple, then I can do it by exporting to Excel and sorting there.
>
> thanks!
>
> Peter
>
> Peter L. Flom, PhD
> Statistical Consultant
> Website: www DOT peterflomconsulting DOT com
> Writing; http://www.associatedcontent.com/user/582880/peter_flom.html
> Twitter:   @peterflom
>