Hi, I try to create a table from the proc freq, but I would like a white background for the 'Total' cells and keep the column and row label with a blue background. Someone now how can I do that? Here is my code to get the previous table proc template; define crosstabs Base.Freq.CrossTabFreqs; row_var_style=rowheader {backgroundcolor=white VERTICALALIGN=MIDDLE font_weight=bold}; col_var_style=header {backgroundcolor=white VERTICALALIGN=MIDDLE font_weight=bold}; define header tableof; end; define header rowsheader; text _row_label_ / _row_label_ ^= ' ' ; text _row_name_ ; style={background=CX99CCFF VERTICALALIGN=MIDDLE font_weight=bold}; end; define header colsheader; text _col_label_ / _col_label_ ^= ' '; text _col_name_; style={background=CX99CCFF VERTICALALIGN=MIDDLE font_weight=bold}; end; cols_header=colsheader; rows_header=rowsheader; header tableof; end; run; ods rtf file; ODS NOPROCTITLE; options validvarname=ANY; proc freq DATA=ALL(RENAME=(Sex_var="Sexe"n Age_var="Age"n)) ORDER=DATA; TABLE "Sexe"n*"Age"n / nopercent nocol norow; label "Sexe"n=; label "Age"n=; run; ods rtf close;
... View more