Hello Experts,
I'm wondering how to change the color on yellow for 2 last columns with proc tabulate :
My code is :
data shoes;
set sashelp.shoes (obs=20);
run;
ods excel file = "\\XXXXX\mon_fichier_2.xlsx"
options(start_at = "2,2"
embedded_titles = "on"
embed_footnotes_once = "on"
autofilter = "1-9"
frozen_headers = "on"
frozen_rowheaders = "2"
absolute_column_width = "15,15,15,15,15,15,15,15,15,15"
row_heights = "15,15,15,15,15,15"
sheet_name = "Tableau"
tab_color = "yellow")
style=Listing;
proc tabulate data=shoes;
title "Question";
class region product Subsidiary;
table (Product ALL ='TOTAL1'), (product ALL='TOTAL2')(Subsidiary ALL='TOTAL3');
keylabel n=' ';
run;
ods excel close;
How can I change also the grey color ?
Thank you ror your help !
... View more
