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 2002, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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?
Comments:   To: arjen.raateland@ymparisto.fi
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


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