Date: Tue, 8 Apr 2003 14:27:28 -0400
Reply-To: Karen Masse <KMasse@PREVISIONMARKETING.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Karen Masse <KMasse@PREVISIONMARKETING.COM>
Subject: Conditional Formatting (Traffic Lighting...)
Content-Type: text/plain; charset="iso-8859-1"
I am looking to take a two part reporting process (SAS processing then Excel
formatting) and put it into one process. Step 1 performs a proc means by a
class variable and determines whether the class mean for each variable is
statistically significant compared to the population mean. Thus, the final
dataset contains the following variables:
X01 - Xn...
P01 - Pn...
Step two of this process takes the resulting dataset and formats it in
Excel. The Excel process uses some fairly straight forward VBA, but it is
is old code and not straight forward to use. Essentially the Excel program
looks at Xn and compares it to its respective p-value. If the value is
significantly larger than the population mean for that record (or row) and
the p-value is greater than .05, the Xn cell is shaded, bolded and the font
size is increased by 1 (key reason Excel conditional formatting doesn't
work...). The font size is correspondingly decreased if the Xn value is
smaller than the population mean.
My question: Is it possible to perform step 2 in SAS? and if so, how?
Karen Kinsey Masse
PreVision Marketing, LLC
55 Old Bedford Rd.
Lincoln, MA 01773