Date: Thu, 13 Oct 2011 07:47:10 -0700
Reply-To: "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Subject: call define style with borders?
Content-Type: text/plain; charset="us-ascii"
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,
flag = mod(_N_,4);
proc report data=myclass nowd;
define flag / noprint display;
if flag eq 1 then
e.g. the below doesn't work
Investment Business Intelligence
Investment Management & Research
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.