Programming the statistical procedures from SAS

Chi square

Reply
Contributor L_L
Contributor
Posts: 56

Chi square

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
Super Contributor
Posts: 281

Re: Chi square

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.
Contributor L_L
Contributor
Posts: 56

Re: Chi square

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
Super Contributor
Posts: 281

Re: Chi square

It shouldn't be hard.

proc freq data=whatever;
table gender*group/chisq;
run;
Contributor L_L
Contributor
Posts: 56

Re: Chi square

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...
Super Contributor
Super Contributor
Posts: 365

Re: Chi square

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=_Smiley Happy 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
Contributor L_L
Contributor
Posts: 56

Re: Chi square

Yes!! Thank you so much :-))
Ask a Question
Discussion stats
  • 6 replies
  • 1070 views
  • 0 likes
  • 3 in conversation