Date:         Mon, 1 Aug 2005 10:24:21 -0400
Reply-To:     "Livingston, Arthur (OIG/OAS)" <Arthur.Livingston@OIG.HHS.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Livingston, Arthur (OIG/OAS)" <Arthur.Livingston@OIG.HHS.GOV>
Subject:      Proc Report Problem V8 to V9
Content-Type: text/plain; charset="iso-8859-1"

The following code works in V8 but not in v9.1.2.  Any suggestions as why this is happening?

ODS LISTING CLOSE;
  ODS HTML FILE="C:\EXCEL FILES\SUMMARY.XLS" STYLE=STYLES.D3D ;
PROC REPORT DATA = MYDATA.FILEIN
                        OUT = MYDATA.FILEOUT (DROP = _BREAK_)
                        SPLIT='*' LS=120 PS=40 NOWD
                        STYLE(REPORT)={FRAME=BOX}
                STYLE(HEADER)={BACKGROUND=BLUE}
                        STYLE(COLUMN)={FOREGROUND=#000000 BACKGROUND=#9AADC7} ;

   TITLE ;
   COLUMN ('REVIEW OF MYDATA'
             'YEAR 2001'
             'SUMMARY OF MYDATA'
             'SCHEDULE OF MYDATA' ' '
            CODE COUNT AMOUNT1 AMOUNT2 AMOUNT3 AMOUNT4) ;

        DEFINE  CODE / GROUP FORMAT=$6.         WIDTH=8   SPACING=2     CENTER 'MYDATA CODE' ;
        DEFINE  COUNT / SUM FORMAT=COMMA9.              WIDTH=15                RIGHT  'MYDATA COUNT' ;
        DEFINE  AMOUNT1 / SUM FORMAT=DOLLAR20.2         WIDTH=15                RIGHT  'MYDATA AMOUNT1' ;
        DEFINE  AMOUNT2 / SUM FORMAT=DOLLAR20.2         WIDTH=15                RIGHT  'MYDATA AMOUNT2' ;
        DEFINE  AMOUNT3 / SUM FORMAT=DOLLAR20.2   WIDTH=15                      RIGHT  'MYDATA AMOUNT3' ;
        DEFINE  AMOUNT4 / SUM FORMAT=DOLLAR20.2         WIDTH=15                RIGHT  'MYDATA AMOUNT4 ' ;

        RBREAK  AFTER  / SUMMARIZE DOL DUL STYLE=
          {BACKGROUND=YELLOW FOREGROUND=BLACK};  ;

RUN ;
ODS HTML CLOSE;