|Date: ||Fri, 30 Mar 2007 13:35:52 -0700|
|Reply-To: ||bigD <diaphanosoma@HOTMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||bigD <diaphanosoma@HOTMAIL.COM>|
|Subject: ||Re: preloading formats, working on order, not label|
|Content-Type: ||text/plain; charset="iso-8859-1"|
I have the order =data statement. This code used to work on a
different data set, except it now has both row and column formats,
whereas the previous tabulate had only the columns formated.
On Mar 30, 4:11 pm, "Andrew H Karp" <sfbay0...@aol.com> wrote:
> One of the PROC TABULATE gurus will probably give you a better answer,
> but my immediate thought is that you also need to add ORDER=DATA to
> your CLASS statement. Give that a try and see if it works. The same
> issue comes up with PROC MEANS and the PRELOADFMT option.
> Let us know if that works.
> Andrew Karp
> Sierra Information Serviceswww.SierraInformation.com
> On Mar 30, 10:15?am, "bigD" <diaphanos...@hotmail.com> wrote:
> > Hi,
> > Here's a vexing little problem.
> > I am producing reports that require a specific order for the rows and
> > columns. I make a format (notsorted) for all types of hsptls and
> > programs. Sas will put them in the right order, but it seems to be hit
> > or miss on the actual new label name. I made the labels shorter to fit
> > the table better, but some of the labels ?are still the long versions.
> > Here's some code.
> > What gives???
> > PROC FORMAT;
> > value $HSPTL_ORDER (NOTSORTED)
> > 'long hospital name' = 'name1'
> > 'very long hospitl name' = 'short name'
> > .
> > .
> > .
> > ;
> > value $pgm_order
> > 'very long pgm name'= 'short name'
> > 'super duper long name' = 'short name1'
> > .
> > ;
> > run;
> > proc tabulate data=new format=7.0 order = DATA ?;
> > class PROGRAM1 /PRELOADFMT ;
> > CLASS hsptl /PRELOADFMT;
> > VAR separations;
> > TABLE PROGRAM1='' ALL='Total',
> > HSPTL*(SEPARATIONS=''*(sum='N' Pctsum<hsptl>='%'*f=pctfmt.))
> > ALL='Total'*SEPARATIONS;
> > FORMAT HSPTL $HSPTL_ORDER. PROGRAM1 $PGM_ORDER.;
> > RUN;- Hide quoted text -
> - Show quoted text -