But ugh. All this formatting stuff should be in a stylesheet, not the HTML itself.

I don't know how well SAS handles that. Ideally, you would create a template, and SAS would generate the stylesheet and appropriate STYLE= attributes for you. Or, in the case of HTML output and an existing stylesheet, you could specify the style directly, and all SAS would generate is the STYLE= attributes.

But I'm not up to date on ODS; can SAS do that?

-- JackHamilton@FirstHealth.com Development Manager, Technical Group METRICS Department, First Health West Sacramento, California USA

>>> "Lund, Pete" <Peter.Lund@CFC.WA.GOV> 11/03/2000 1:51 PM >>> Kim- This would be the thing that would cause me to jump ship to V8. Style elements can be attached to individual pieces of REPORT output, as well as TABULATE. The same is true of PRINT in V8.2. For the sake of quickness, here's an REPORT example stolen from the OnLine Docs:

compute after manager / style=[font_style=roman font_size=3 font_weight=bold background=white foreground=black];

line 'Subtotal for ' manager $mgrfmt. 'is ' sales.sum dollar7.2 '.'; endcomp;

compute sales; if sales.sum>100 and _break_=' ' then call define(_col_, "style", "style=[background=yellow font_face=helvetica font_weight=bold]"); endcomp;

I've had a lot of success using both the REPORT and TABULATE style options. I haven't tried the PROC PRINT style option yet, but it looks similar to REPORT.

I know this doesn't solve the V7 problem, but if V8 is available I'd go for it.

----------------------------------------------------------- Pete Lund WA State Caseload Forecast Council 515 15th Ave SE Olympia, WA 98504-0962 (360) 902-0086 voice (360) 902-0084 fax (360) 971-0962 pager peter.lund@cfc.wa.gov ----------------------------------------------------------------------

-----Original Message----- From: Kim LeBouton [mailto:Kim_LeBouton@TOYOTA.COM] Sent: Friday, November 03, 2000 1:23 PM To: SAS-L@LISTSERV.UGA.EDU Subject: ODS Headache #142

Okay, I'm having one of those ODS headache days!!!

I have an almost near perfect report, created with PROC REPORT, that everyone has signed off on, except for one small request. They would like different colors for the summary lines that are created with RBREAK and BREAK.

I'm using the D3D style. Has anyone found an easy way to do this with ODS? (One other caveat is that I'm using V7, although V8 is on-site.)

My somewhat modified code follows.

TIA, Kim LeBouton K.J.L. Computing A SAS Quality Partner (tm)

ods listing close; ods html file="c:\goodreport.htm" style=d3d; title Almost Perfect Report; footnote End of an Almost Perfect Report;

PROC REPORT DATA=dealer(drop=lr1 lr2 lr3 qlr) LS=213 PS=69 SPLIT="*" CENTER nowindows ;

COLUMN regnum dist master dlrcode billname expgrp earn3 ;

/* dlrinfo */ DEFINE regnum / group LEFT "***Reg" ; DEFINE dist / group LEFT "***Dist" ; DEFINE master / group LEFT "**Dealer*Master" ; DEFINE dlrcode / group LEFT "***Dealer" ; DEFINE billname / group flow "***Dealer Name" ; define expgrp / display format=$9. left " " /*"**Exp*Grp"*/;

/***********************/ /* monthly information */ /***********************/ DEFINE earns3 / SUM format=7. RIGHT "*Reserve*Level*$";

rbreak after / summarize; /* would like this to be blue */ break after regnum / summarize; /* would like this to be yellow */ break after dlrcode / summarize; /* the burgundy color is fine-no change necessary */

RUN;

ods html close;