LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (June 2006, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 >


Back to: Top of message | Previous page | Main SAS-L page