I'm using the most recent version of ExcelXP to create spreadsheets. I have some particular cells I want to add a bottom border two. I figured out how to use compute blocks to change the formatting on those cells but not how to change borders.
I would like to know how to modify the formatting below to include a bottom border for each of these cells. I tried htmlstyle= but that didn't work. Any clues?
if rptline=50 then call define(_col_,'style','style=[background=silver font_weight=bold]');
else if rptline=23 then call define(_col_,'style','style=[font_weight=bold]');
to your style. Of course you can use other values, although Excel doesn't do much with
width, there is really only 1-4 for that.
The border style can have a lot of settings. The ODS style is on the left, the corresponding Excel style is on the right. Excel doesn't have as many as ODS does.
Use the ODS style in your over rides, it is case insensitive.
I tried adding borderbottomstyle= etc to the style in my call define but I got the error message "ERROR 22-322: Syntax error, expecting one of the following: ;, ABSTRACT, ACTIVELINKCOLOR, ASIS, BACKGROUND, BACKGROUNDIMAGE, BODYSCROLLBAR, BODYSIZE,..." It doesn't know those particular attributes.
I know how to make my own style with proc template but I can't figure out how to apply that style in a call define.
Hi: Some of the style attributes may be SAS 9.2 attributes. I think there were some of these borderxxx attributes that were pre-prodution for RTF only. (http://support.sas.com/rnd/base/ods/odsrtf/rtf901.html) So they might not work for other destinations if you're not at SAS 9.2.
Also, the other thing that you could be running into is the PLACE where you're trying to use the attribute is not an OK place. For example, you are trying to use the attribute on the PROC REPORT statement, but the attribute can only be used on the DEFINE or RBREAK (and other statements) inside Proc Report. In a CALL DEFINE statement, you should be able to alter attributes that are CELL related (but not TABLE related). In other words, a CALL DEFINE for a particular column or calculated report item would not be able to alter the style for the -whole- table.
To find out which situation you're running into, your best bet for help might be to contact SAS Tech Support.