Date:         Thu, 29 Jun 2006 15:00:30 -0500
Reply-To:     Yu Zhang <zhangyu05@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Yu Zhang <zhangyu05@GMAIL.COM>
Subject:      Re: Proc tabulate order
Comments: To: mesecca L katram <mesecca@yahoo.com>
In-Reply-To:  <200606291940.k5TH54pI008205@mailgw.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Sorry, your data is not in the desired order. Can you try to specify
notsorted options in your proc format statement and specify order=formatted
in your class statement?


proc format;
value test (notsorted)
1='One'
other='Everything else'
3='Three'
;
run;



Yu

On 6/29/06, mesecca L katram <mesecca@yahoo.com> wrote:
>
> I have report whose data is in the following order
> the data set is this order
> 1.'Iowa'
> 2.'South Dakota'
> 3.'Minnesota'
> 4.'Montana'
> 5.'Nebraska'
> 6.'North Dakota'
> 7.'Wyoming'
> 8.'totals'
> 9.'total';
>
> but the report should appear in the following order(total and totals
> exchange thier positions)
>
> 1.'Iowa'
> 2.'South Dakota'
> 3.'Minnesota'
> 4.'Montana'
> 5.'Nebraska'
> 6.'North Dakota'
> 7.'Wyoming'
> 8.'total';
> 9.'totals'
>
> i am using a proc tabulte procedure I knwo there is something
> order=formated and order=unformated I cannot use there options
> 1) I have ordered by state in the previuos step as proc transpose
> procedures needs it to be ordered by state.
> is there any way we can control the order in the proc tabulate
> here my proc tabulate procedure
> PROC TABULATE  DATA=WORK.TCC;
> VAR A B C D;
> CLASS STATE /ORDER=FORMATTED  ;
> CLASS Claims / ORDER=UNFORMATTED MISSING;
> TABLE /* Row Dimension */
> STATE*
> Claims={LABEL=''}*
>    Sum={LABEL=''},
> /* Column DimensioN*/
> A
> B
> C
> D   ;
> ;
>
> RUN;
> Thanks in advance
>