less verbose PROC FREQ output

[AndrewZ]

I invoke PROC FREQ like the following, and I would prefer to clean up the output.  Omitting Fisher's exact test would be a good start.  Also, I only need the basic Chi-Square statistic and not the 6 others.

proc freq data= year_ago;

    tables a * b / chisq nocol nopercent;

run;

Do I need some obscure ODS commands, or output to a data set and go from there, or is there an easier way?

[Reeza · Accepted solution]

You can select the tables/results you'd like to see using the ODS SELECT TABLENAMES statement.

To figure out the ODS TABLE names check the docs for proc freq or run your procedure with ODS TRACE ON;

Just a note though, in my version I think fishers only shows up when it thinks its necessary, versus all the time.

ods select crosstabfreqs chisq;

proc freq data=sashelp.heart;

table Chol_Status*sex/chisq nocol nopercent;

run;