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.

Hmmm.

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 -