Date: Thu, 13 Oct 2011 09:50:32 -0500
Reply-To: Joe Matise <snoopy369@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Joe Matise <snoopy369@GMAIL.COM>
Subject: Re: call define style with borders?
In-Reply-To: <0F548D585A011E4484D77C7B095EC53F090F9B37@TAC-CMS001.prod.ds.russell.com>
Content-Type: text/plain; charset=ISO-8859-1
I usually like to use PROC TEMPLATE here to define a style ahead of
time, and then just use that in the proc report. Cleaner, easier to
maintain and read, and avoids some of these issues. I haven't
specifically worked with border colors, though, so not sure there. I
do know that borders in general are a bit finicky in excel tagsets,
and IIRC there are different ways of dealing with them depending on
the specific issue.
-Joe
On Thu, Oct 13, 2011 at 9:47 AM, Terjeson, Mark <Mterjeson@russell.com> wrote:
> Hi All,
>
> re: proc report to ods excel
>
> Here is an example of more than one cosmetic
> attribute being set per row. However, am having
> great difficulty trying to find any syntax to set
> border colors as well. Two problems occur, if
> you use any borderxxx options all your other
> settings do not get executed and second you
> do not get all the borders. Is there a trick to
> having multiple attributes set as well as setting
> the border color?
>
> Have tried bordercolor,borderleftcolor,
> bordertopcolor, etc.
>
>
>
>
> data myclass;
> set sashelp.class;
> flag = mod(_N_,4);
> run;
> proc report data=myclass nowd;
> define flag / noprint display;
> compute flag;
> if flag eq 1 then
> call define(_row_,"style",
> "style={background=#EBEAD5
> foreground=#FF0000}");
> else
> call define(_row_,"style",
> "style={background=white}");
> endcomp;
> run;
>
>
> e.g. the below doesn't work
>
> /*
> call define(_row_,"style","style={background=#EBEAD5
> borderleftcolor=#969696
> borderrightcolor=#969696
> bordertopcolor=#969696
> borderbottomcolor=#969696
> }");*/
>
>
>
> Mark Terjeson
> Investment Business Intelligence
> Investment Management & Research
> Russell Investments
> 206-505-2367
>
>
> Russell
> Global Leaders in Multi-Manager Investing
>
> SEVENTY-FIVE YEARS of Russell Innovation
> The information contained in this message is intended only for the use of the recipient named above. This message may contain privileged, confidential or undisclosed information. If the reader of this message is not the intended recipient or an agent responsible for delivering to the intended recipient, you are hereby notified that you have received this message in error, and that any review, dissemination, distribution or copying of it is strictly prohibited. If you have received this message in error, please notify us by telephone immediately at (253) 505-2367. Thank you for your cooperation.
>
| 
