LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2011, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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.

Back to: Top of message | Previous page | Main SAS-L page