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." );
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
From this SAS support page, try using the TABCOLOR option:
tabcolor='blue'
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.