Date: Fri, 3 Nov 2000 15:01:05 -0700
Reply-To: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject: Re: ODS Headache #142
Content-Type: text/plain; charset=US-ASCII
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;
