Date:         Mon, 1 Aug 2005 10:26:29 -0400
Reply-To:     "Neff, Dena" <dhn7@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Neff, Dena" <dhn7@CDC.GOV>
Subject:      Re: Proc Report Problem V8 to V9
Content-Type: text/plain; charset="US-ASCII"

What errors are being generated in the log file?


Dena Neff
SAS & SAS/IntrNet(r) Programmer
SAIC
CDC/ATSDR/NIP/OD/SODA,
Corp. 1213, MS E-57
dhn7@cdc.gov
404.639.6281 (Phone)
404.639.8555 (Fax)


 "Our greatest glory is not in never falling, but in rising every time
we fall." -- Confucius


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Livingston, Arthur (OIG/OAS)
Sent: Monday, August 01, 2005 10:24 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Proc Report Problem V8 to V9

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;