Date:         Thu, 5 Jun 2008 12:36:56 -0700
Reply-To:     jfh@stanfordalumni.org
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject:      Re: Simple Proc Tabulate question
Comments: To: KJ <krutic@GMAIL.COM>
In-Reply-To:  <9816606a-7025-4436-8335-ca4dc3da247c@c58g2000hsc.googlegroups.com>
Content-Type: text/plain; charset="ISO-8859-1"

You could probably do it with a custom template.  Or maybe with PROC
REPORT using CALL DEFINEs.  Tabulate is not the procedure to use if you
want cell-by-cell customization of formatting (unless you want to write
custom templates, which I for one don't).


On Thu, 5 Jun 2008 10:26:32 -0700, "KJ" <krutic@GMAIL.COM> said:
> On Jun 3, 10:32 am, KJ <kru...@gmail.com> wrote:
> > Hello,
> >
> > I have the following basic Proc Tabulate code. It works and does what
> > I need it to do.
> >  I wanted to know how do I customize the colors? I can change certain
> > backgrounds and text but not all. I want to change the text color of
> > 'reason' and 'lob' variables(currently dark blue) and change their
> > background as well. So I want a different color for the name of the
> > variables and a different color for the value of those variables.
> >
> > Example:
> > ----------------------------------------
> > |                                    |Total|
> > |-------------------------------+------    |
> > |Reason for   |Line Of       |      |
> > |Supression  |Business    |      |
> > |---------------+---------------     |      |
> > |Disgruntled     |Mortgage |      |
> > |Customer       |               |  32|
> > ----------------------------------------
> >
> > So for the above - I want to change the color of the text for
> > 'disgruntled customer' (which is the reason) and for 'Mortgage' (which
> > is the LOB). And then I want a different color for the 'Total' and
> > different colors  for 'Reason for Suppression' and 'Line of
> > Business'.
> > Basically I am interested in transforming the whole html output with
> > the text and background colors I want.
> >
> > Thank you!
> >
> > CODE:
> >
> > ods html body='/x/supp.html';
> >
> >  title "There are &totalsup Suppressed Customers" ;
> >
> > proc tabulate data=one S=[foreground=blue background=lightyellow];
> >
> >    class  reason /style=[background=White];
> >    class lob /S=[background=Red];
> >
> >    table reason*lob, n='Total'*f=6.;
> >    run;
> >    title;
> >
> > ods html close;
>
> No one has answers for this? :(


--
Jack Hamilton
Sacramento, California
jfh@alumni.stanford.org  <== Use this, not jfh@stanfordalumni.org