LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (August 2005, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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;


Back to: Top of message | Previous page | Main SAS-L page