topic Re: Remove "Table of Variable1 by Variable2" Title in 2-by-2 Cross-Tabulation in PROC FREQ in SAS Procedures

Remove "Table of Variable1 by Variable2" Title in 2-by-2 Cross-Tabulation in PROC FREQ

EricCai — Mon, 29 Sep 2014 23:01:29 GMT

Dear Community,

If you run the following code,

proc freq

data = sashelp.class;

tables age * sex;

run;

you will find that the output table contains the title "Table of Age by Sex". How can I remove this title?

I have tried playing around with the "title" statement and searching on Google and this forum, but to no avail.

Thanks,

Eric

Re: Remove "Table of Variable1 by Variable2" Title in 2-by-2 Cross-Tabulation in PROC FREQ

art297 — Mon, 29 Sep 2014 23:09:29 GMT

: Take a look at: http://support.sas.com/resources/papers/freq92.pdf

Re: Remove "Table of Variable1 by Variable2" Title in 2-by-2 Cross-Tabulation in PROC FREQ

EricCai — Wed, 01 Oct 2014 18:36:15 GMT

Hi Art,

Thanks for the link. I solved my problem by modifying the template's code as given in the appendix. I also wanted my table to display only the variables' labels, not their names. Here are the steps that I took:

Delete the chunk of code starting from "delete TableOf" to its own end. Also, delete "TableOf" in the header statement within the first definition for crosstabs. This will rid the annoying "Table of Var1 by Var2" title.

Delete the relevant parts (_ROW_NAME_ or _ROW_LABEL_) in the definition of the RowsHeader and the ColsHeader to control the display of the variable name or label in the row/column.

Run this template before every analysis SAS script. I have a separate file for my library names and other SAS formatting options (like PROC FORMAT or clearing my log, output window, and results viewer), and I have added the code for this template (with my modifications) into that file. I then use the %include statement to run this file in my actual analysis SAS script.

Thanks again for your help, Art!