| 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 |
Arjen,
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
technique (http://www2.sas.com/proceedings/sugi26/p003-26.pdf).
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
> 'templates')
>
> 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
|