topic Re: Using label in two-way freq table in Statistical Procedures

Using label in two-way freq table

Snow_Belssas — Tue, 08 Sep 2009 14:53:04 GMT

Dears

Does any of you managed to create a two-way table from PROC FREQ which only uses var label text but not default "Var-name (Var-label)".
Many thanks in advance for your help.

Snow

Re: Using label in two-way freq table

sbb — Tue, 08 Sep 2009 15:42:09 GMT

From what I read, SAS 9.2 can address this requirement.

The only other technique may be to use PROC FREQ with OUT=, and then attempt some PROC TRANSPOSE to achieve the two-way cross-tab output report, possibly.

Scott Barry
SBBWorks, Inc.

Customizing FREQ Procedure Output in SAS 9.2
http://support.sas.com/resources/papers/freq92.pdf

SAS Procedures Guide: Statistical Procedures, PROC FREQ
Example 3.1 Output Data Set of Frequencies
http://support.sas.com/documentation/cdl/en/procstat/59629/HTML/default/procstat_freq_sect024.htm

Re: Using label in two-way freq table

Snow_Belssas — Tue, 08 Sep 2009 19:10:52 GMT

Hi SBB

Many thanks for your info given. I am working with SAS 9.2, but when I tested the samples copied from (in the first link) techno paper, either RTF or original HTML format, my SAS simply crached. Any idea about that?

Regards
Snow

Re: Using label in two-way freq table

Snow_Belssas — Tue, 08 Sep 2009 19:18:12 GMT

Hi again

Sorry, I forgot to post the used sample program see as printed.

data class;
set sashelp.class;
label sex="Gender"
age="Age in Years";
run;
proc template;
define crosstabs Base.Freq.CrossTabFreqs;
define header tableof;
text "Table of " _row_label_ " by " _col_label_;
end;
define header rowsheader;
text _row_label_ / _row_label_ ^= " ";
text _row_name_;
end;
define header colsheader;
text _col_label_ / _col_label_ ^= " ";
text _col_name_;
end;
cols_header=colsheader;
rows_header=rowsheader;
header tableof;
end;
run;

ods listing close;
ods HTML file="body.html";
proc freq data=class;
tables sex*age;
run;
ods html close;
ods listing;

Re: Using label in two-way freq table

sbb — Tue, 08 Sep 2009 20:44:09 GMT

You will be best served by contacting SAS Support to open a track if you are not getting the expected results, especially where involving a SAS system/environment failure.

Scott BarryS
SBBWorks, Inc.

Re: Using label in two-way freq table

Snow_Belssas — Wed, 09 Sep 2009 09:04:31 GMT

Thanks, I have submitted the problem to our dear SAS tech support.