Date:         Fri, 19 Jan 2007 15:15:38 -0500
Reply-To:     Ken Borowiak <EvilPettingZoo97@AOL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ken Borowiak <EvilPettingZoo97@AOL.COM>
Subject:      Multilabel formats and ACROSS variables

SAS-l,

I attempted to create a 'Total' column in PROC REPORT using an ACROSS
variable with a preloaded, multilabel format (as shown below), but to no
avail. There is no error message, but the output is not correct.

proc format ;
  value semester (multilabel)
  1 = 'Fall'
  2 = 'Spring'
  1-2 = 'Total' ;
 run ;

 data class ;
   set Sashelp.Class ;

   if mod(_n_,2)=1 then semester=1 ;
     else semester=2 ;
  run ;


ods rtf file="%sysfunc(pathname(work))\Junk(&sysdate.).rtf" style=minimal ;

   proc report data=class nowd ;
     column sex semester, height ;
  define sex / group ;
  define semester / across ' ' format=semester. preloadfmt ;
  define height / n ;
 run ;

ods rtf close ;


Could someone please point me to some documentation that indicates this is
not feasible? Or have I not specified some option to get this working? (BTW,
MLF is not an acceptable option in the DEFINE statment, as it is in
TABULATE's CLASS statement)

Thanks!
Ken