Chi square

[L_L]

Dear all,

I would like to add in a contingency table (created by proc tabulate) the corrispondence p-value: is it possible?
Anyway, how can I do it?

Thanks in advance
Regards

[Paige]

I don't think PROC TABULATE will do this.

I believe you have to create the table in PROC FREQ and use the CHISQ option.

[L_L]

Ok. The PROC FREQ output (with the chi square option) is
1) contingency table
2) Chi square test
I would like to have in the contingency table the p-value, for example:
Group1 Group2 Group3 *
Male xxx xxx xxx
xx% xx% xx%
Female xxx xxx xxx
xx% xx% xx%
*p=x.xxx

Any ideas?
thx

[Paige]

It shouldn't be hard.

proc freq data=whatever;
table gender*group/chisq;
run;

[L_L]

Thank you. Unfortunaley it's not exactly what I mean.
The aim is to improve the output and to have all the information in one table.
Maybe I have to use a PUT on a file and a PRINTTO...

[SPR]

Hello L&L,

Is this what you need?
[pre]
ODS output CHISQ=Chi (keep=Statistic Prob where=(Statistic="Chi-Square"));
proc freq data=SASHELP.CLASS;
table sex*age/out=freq chisq;
run;
proc transpose data=freq out=r(drop=_:) prefix=Age_;
var percent;
id age;
by sex;
run;
data r;
length Sex $10;
set r CHI(in=c rename=(Statistic=Sex Prob=Age_11));
if c then Sex="p-value";
run;
[/pre]
Sincerely,
SPR Message was edited by: SPR

[L_L]

Yes!! Thank you so much :-))