topic Renamin variables produced with Proc freq in SAS Programming

Renamin variables produced with Proc freq

Smithy — Tue, 21 May 2013 18:40:21 GMT

Two variables - disease and habit

Help me - calculate Cochran-Mantel-Haenzel, Chi-square and corresponding p-value. The output data set must have variables names: cmh_chi for Cochran-Mantel-Haenzel Chi-square and cmh_p for p value of Cochran-Mantel-Haenzel Chi-square.

disease	habit
cancer	smoking
cancer	no smoking
no cancer	no smoking
cancer	smoking
cancer	smoking
no cancer	smoking
cancer	no smoking
cancer	smoking

I know how to use proc freq and how to calculate the mentioned statistics and create a new data set. What I dont know is how to rename the variables.

THANKS!

Re: Renamin variables produced with Proc freq

Smithy — Tue, 21 May 2013 18:46:49 GMT

Data p1;

Set test."record$"n;

run;

proc freq data=p1;

tables disease*habit / cmh chisq;

output out=ChiSqData chisq pchi cmh;

title 'Chi-Square Tests for disease and habit';

run;

This is what I have so far help me modify it!

Re: Renamin variables produced with Proc freq

Reeza — Tue, 21 May 2013 18:47:58 GMT

Unless I'm missing something you can use any of the standard rename statements.

data want;

set have;

rename old_name=new_name;

run;

Re: Renamin variables produced with Proc freq

Smithy — Tue, 21 May 2013 19:29:54 GMT

I agree with you the problem is that I cant rename the variable if I dont have the name of it (old_variable) for some strange reason I cant find the correct number for the variables to be renamed. I go into the dataset but when I type what appears as the variable name it doesnt read it.

Thanks

Re: Renamin variables produced with Proc freq

Reeza — Tue, 21 May 2013 19:40:24 GMT

run a proc contents on the data to see the valid name vs the label.

It looks like you want 8 & 10. If your code isn't work post the code and log.

Alphabetic List of Variables and Attributes

Variable

Type

Len

Label

15	DF_CMHCO	Num	8	DF for CMH Nonzero Correlation
21	DF_CMHGA	Num	8	DF for CMH General Association
18	DF_CMHRM	Num	8	DF for CMH Row Mean Scores Differ
6	DF_LRCHI	Num	8	DF for Likelihood Ratio Chi-Square
9	DF_MHCHI	Num	8	DF for Mantel-Haenszel Chi-Square
3	DF_PCHI	Num	8	DF for Chi-Square
1	N	Num	8	Number of Subjects in the Stratum
16	P_CMHCOR	Num	8	P-value for CMH Nonzero Correlation
22	P_CMHGA	Num	8	P-value for CMH General Association

19	P_CMHRMS	Num	8	P-value for CMH Row Mean Scores Differ
7	P_LRCHI	Num	8	P-value for Likelihood Ratio Chi-Square
10	P_MHCHI	Num	8	P-value for Mantel-Haenszel Chi-Square
4	P_PCHI	Num	8	P-value for Chi-Square
14	_CMHCOR_	Num	8	CMH Nonzero Correlation
20	_CMHGA_	Num	8	CMH General Association
17	_CMHRMS_	Num	8	CMH Row Mean Scores Differ
12	_CONTGY_	Num	8	Contingency Coefficient
13	_CRAMV_	Num	8	Cramer's V
5	_LRCHI_	Num	8	Likelihood Ratio Chi-Square
8	_MHCHI_	Num	8	Mantel-Haenszel Chi-Square
2	_PCHI_	Num	8	Chi-Square
11	_PHI_	Num	8	Phi Coefficient

Re: Renamin variables produced with Proc freq

Smithy — Tue, 21 May 2013 20:31:59 GMT

Thank you for your help it worked!