|Date: ||Thu, 1 Aug 2002 07:32:17 -0700|
|Reply-To: ||Lauren Haworth <haworthl@GENE.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Lauren Haworth <haworthl@GENE.COM>|
|Organization: ||Genentech, Inc.|
|Subject: ||Re: highlighting in PROC REPORT output?|
|Content-Type: ||text/plain; charset=us-ascii|
You can do this easily with PROC REPORT. All you need to do is set up a
format to assign colors to ranges and then use the STYLE option on PROC
REPORT to assign the foreground or background color of a cell to that color.
See my paper "ODS for Print, Report, and Tabulate" for an example of this
With a little more creativity, you can use a compute statement to change the
color of the entire row. There's an example of shading alternate rows in
that paper that could probably be adapted to meet your needs.
-- Lauren Haworth
Arjen Raateland wrote:
> I built a SAS application which among other things produces a few
> reports by the use of PROC REPORT. Currently the user prints the reports
> direct from the PROC REPORT window.
> Certain lines in the printed report are then highlighted by the user
> with a felt marker (textliner) based on the value of one particular
> variable (viz. the abundance of blue-green algae).
> Would it be possible to do the highlighting in the application, so the
> user doesn't have to go through the list with a feltpen?
> I was thinking of making the background of the line grey - or some fancy
> color - but in the output window that's not likely to be possible.
> However, I could make the output go to a PDF or an RTF file instead and
> perhaps use a template. I have no experience with templates, especially
> not with modifying them.
> The ultimate in fancy reporting would have all report lines color-coded
> in the same way as our maps, in which the dots are color-coded based on
> the abundance variable.
> See: http://www.vyh.fi/ajankoht/tiedote/leva/leva02/ka020731.htm
> (the legend and other texts are in Finnish & Swedish only .... however,
> underlying values for abundance are numerical .X, 0, 1, 2, 3; those GIF
> maps which show observed values are produced by the application and the
> relevant HTML files are also produced by the application based on some
> Thanks for any clues about if this can be done and hints as to how it
> could be done.
> Arjen Raateland
> Finnish Environment Institute SYKE
> Research Dept.
> SAS Support
> phone +358 9 4030 0350