Does anyone know how to do the pairwise comparison for Fisher's exact test?
Thanks,
Momi
Provide some example data and the research question. Fisher has more than one test.
But I might guess that you want proc freq with an Exact statement and the Fisher option. You may need to make sure your data is in the correct structure.
|
group1 | gorup2 | goup3 |
A | 7 | 6 | 11 |
B | 3 | 3 | 6 |
C | 15 | 1 | 7 |
D | 0 | 0 | 4 |
E | 13 | 8 | 14 |
F | 10 | 2 | 3 |
Here is the data. All caterogires are nominal. According to the Fisher's exact test, there is a siginificant relashionship between the gorups and the categories A - F. Unfortunaly, I can not provide the actual measurement. (Does this matter?) I was wondering if it would be possible to the pari comparisons of these.
Thank you,
Momi
data have;
infile cards expandtabs truncover;
input name $ group1 group2 group3;
cards;
A 7 6 11
B 3 3 6
C 15 1 7
D 0 0 4
E 13 8 14
F 10 2 3
;
proc transpose data=have out=want ;
by name;
var group1-group3;
run;
proc freq data=want;
weight col1;
tables name*_name_/chisq;
exact fisher /mc n=1000000;
run;
you can remove 'mc n=100000' to get the right fisher test,but that will cost you lots of time.
Monte Carlo Estimate for the Exact Test
Pr <= P 0.0375
99% Lower Conf Limit 0.0370
99% Upper Conf Limit 0.0380
therefore, category and group are not independent under alpha=0.05 .
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.