Date:         Fri, 15 Oct 2010 10:55:39 -0400
Reply-To:     "Chaitovsky, Avi-Gil" <Avi-Gil.Chaitovsky@ANTHEM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Chaitovsky, Avi-Gil" <Avi-Gil.Chaitovsky@ANTHEM.COM>
Subject:      Conditional Formatting
Content-Type: text/plain; charset="us-ascii"

My last few questions have been about my program's input - this one is
about the output.

 

I'm trying to use conditional formatting to get my output in PROC PRINT
to look similar to what I can generate in Excel.

In Excel, I can use conditional formatting to say that if cell A2 > cell
A1, then make A2's font color red, and if A2 < A1, then make A2's font
color green.  Then I can copy this down the rows, so that the same
comparison would be made between B1 and B2, C1 and C2, etc.  In SAS, the
most I've been able to figure out is how to change the color if A2 > [a
constant, e.g., 10,000].  I need my coloring to be more dynamic than
that - I'm sure there's a way, and I look forward to learning it from
all of you.

 

Thanks,

Avi

 

Avi-Gil Chaitovsky

WellPoint, Inc.

Empire BlueCross BlueShield

HealthCare Analytics

Business Information Analyst II

165 Broadway, 14th Floor

New York, NY 10006

Avi-Gil.Chaitovsky@anthem.com <mailto:Avi-Gil.Chaitovsky@anthem.com> 

(212) 476-1483



CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, 
is for the sole use of the intended recipient(s) and may contain confidential
and privileged information or otherwise protected by law.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not the
intended recipient, please contact the sender by reply e-mail and destroy
all copies of the original message.