topic Re: Proc freq ods output in ODS and Base Reporting

Proc freq ods output

jack_nicholson — Mon, 14 Jan 2013 19:32:39 GMT

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;

Re: Proc freq ods output

Reeza — Mon, 14 Jan 2013 19:50:23 GMT

I'd suggest using proc tabulate instead, you can apply styles within the procedure rather than mess with the template code.

http://www2.sas.com/proceedings/sugi29/085-29.pdf

Re: Proc freq ods output

Cynthia_sas — Mon, 14 Jan 2013 21:08:35 GMT

Hi:

I agree. I think it is easier to use either PROC TABULATE or PROC REPORT than to change the template for PROC FREQ. Given that there already is an investment in PROC FREQ, the OP would have to define a specific header section in order to apply style changes to the header. PROC PRINT, PROC REPORT and PROC TABULATE already have those controls in place.

See code below using SASHELP.CLASS.

cynthia

proc format;
value agef 11-12 = 'Pre-teens'
13-16 = 'Teens';
run;

ods rtf file='c:\temp\tabulate_report.rtf';
proc tabulate data=sashelp.class f=3.0;
title 'Use Tabulate instead of PROC FREQ';
class age sex /
    style={background=CX99CCFF
           font_weight=bold};
classlev age sex/
     style={background=white foreground=black font_weight=bold};
table sex=' ' all='Total',
        age*n=' ' all=' '*n='Total' /
        box={label='Sexe' s={background=cx99ccff}};
format age agef.;
keyword all n/
    style={background=CX99CCFF
           font_weight=bold};
run;

** make length of SEX variable longer;

** to use TOTAL label at report summary;

** because otherwise, SEX variable is a length of $1;

data class;
length sex $8;
set sashelp.class;
run;

proc report data=class nowd
style(Header)={background=CX99CCFF
                 font_weight=bold}
style(summary)={background=CX99CCFF font_style=roman font_weight=bold};
title 'Use REPORT instead of PROC FREQ';
column ('Sexe' sex) ('Age' age,n ('Total' age=agetot));
define sex / group ' ';
define age / across ' ' f=agef.
         style(header)={background=white
                        font_weight=bold};
define n / ' ';
define agetot / ' ';
rbreak after / summarize;
compute after;
     sex='Total';
     call define('_c2_','style','style={background=white}');
     call define('_c3_','style','style={background=white}');
     call define('_c4_','style','style={background=white}');
endcomp;
run;
ods rtf close;

Re: Proc freq ods output

jack_nicholson — Tue, 15 Jan 2013 13:29:28 GMT

OK Thanks you!!