color code excel tabs

[NJGIRL]

Hi all,

Can anyone direct me to a former post that has example logic on how to color code Excel tabs in ODS?

The following is my code thus far: Thanks!

ods tagsets.ExcelXP file="&output_name" style=Printer;

ods tagsets.ExcelXP options(orientation='landscape'

autofit_height='Yes'

autofilter='all'

sheet_name="Exposure XXX"

embedded_titles='yes'

embedded_footnotes='yes'

row_repeat='7'

frozen_headers='7'

width_points='10'

width_fudge='1'

zoom='80'

scale='60'

center_horizontal='Yes'

gridlines='Yes'

print_header='&L &A &C &D &T &R Page &P of &n'

print_footer="&program_name." );

[mklangley]

From this SAS support page, try using the TABCOLOR option:

tabcolor='blue'

[NJGIRL]

Darn, no luck:Unrecognized option: TABCOLORUnrecognized option: TAB_COLOR
As you can see I tried with/without the underscore.
I wonder if this is an underlying issue with the Proc Template style we are using ? ?

[Cynthia_sas · Accepted solution]

Hi:
For that code in the note to work, you have to download the tagset template code in the link, run that to create tagsets.ExcelXP_mod, as shown in the code. When I tried it, tabcolor= suboption worked for me with the modified tagset template, as shown below:

I believe that ODS EXCEL uses the tab_color suboption. You'd have to check the documentation. When I tried this (using tab_color with ODS EXCEL), it worked for me:

Cynthia

[NJGIRL]

Thanks Cynthia!