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"

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.