Date:         Mon, 31 Aug 2009 15:22:32 -0500
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: PROC FREQ Order=Formatted and Missing Data
Comments: To: msz03@albany.edu
In-Reply-To:  <32921.150.142.232.4.1251746844.squirrel@webmail.albany.edu>
Content-Type: text/plain; charset=ISO-8859-1

I know that using PRELOADFMT and ORDER=DATA works for proc means/summary and
tabulate, but I'm not sure about FREQ (doesn't have PRELOADFMT).  You may
need to use a different PROC, and/or use ODS OUTPUT and manipulate that.

-Joe

On Mon, Aug 31, 2009 at 2:27 PM, Mike Zdeb <msz03@albany.edu> wrote:

> hi ... any way to make PROC FREQ put the MISSING data last in the table
> in the following ORDER=FORMATTED is 'honored' for all categories except
> missing
>
>
> data class;
> set sashelp.class end=last;
> output;
> if last then do; age = .; output; end;
> label
> age = "Student's Age"
> sex = "Student's Gender"
> ;
> run;
>
> proc format;
> value age
> low - 12   = '3: <13'
> 13  - 14   = '2: 13-14'
> 15  - high = '1: 15+'
> . = '4: MISSING'
> ;
> run;
>
> proc freq data=class order=formatted;
> table age*sex / norow nocol nopercent missing;
> format age age.;
> run;
>
>
> --
> Mike Zdeb
> U@Albany School of Public Health
> One University Place
> Rensselaer, New York 12144-3456
> P/518-402-6479 F/630-604-1475
>