Hello,
I have this calculated and I am trying find if the differences in this three groups are significant or not. I know we did not have equal number of sample in each group. I have never done statistical test so i am wondering if some one canhelp me find the 95% CI and pvalue of each variable i am comparing here.
FEMALE | MSM | MSW | ||||||||||||||||
Alert | Non-Alert | Seed | Alert | Non-Alert | Seed | Alert | Non-Alert | Seed | ||||||||||
# | % | # | % | # | % | # | % | # | % | # | % | # | % | # | % | # | % | |
TOTAL | 11 | 22% | 202 | 21% | 2 | 13% | 22 | 44% | 87 | 9% | 3 | 19% | 17 | 34% | 651 | 69% | 11 | 69% |
GENDER | ||||||||||||||||||
Male | 0 | 0% | 0 | 0% | 0 | 0% | 22 | 100% | 85 | 98% | 3 | 100% | 17 | 100% | 649 | 100% | 11 | 100% |
Female | 11 | 100% | 202 | 100% | 2 | 100% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% |
Male to Female | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 2 | 2% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% |
Unknown | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 2 | 0% | 0 | 0% |
RACE | ||||||||||||||||||
African American | 11 | 100% | 176 | 87% | 2 | 100% | 17 | 77% | 59 | 68% | 3 | 100% | 13 | 76% | 609 | 97% | 9 | 82% |
White | 0 | 0% | 8 | 4% | 0 | 0% | 3 | 14% | 9 | 10% | 0 | 0% | 1 | 6% | 21 | 3% | 2 | 18% |
Other | 0 | 0% | 18 | 9% | 0 | 0% | 2 | 9% | 19 | 22% | 0 | 0% | 3 | 18% | 21 | 3% | 0 | 0% |
ETHNICITY | ||||||||||||||||||
Hispanic | 1 | 9% | 6 | 3% | 1 | 50% | 3 | 14% | 7 | 8% | 1 | 33% | 2 | 12% | 24 | 4% | 2 | 18% |
Non-Hispanic | 10 | 91% | 191 | 97% | 1 | 50% | 19 | 86% | 80 | 92% | 2 | 67% | 15 | 88% | 612 | 96% | 9 | 82% |
Unknown | 0 | 0% | 5 | 2% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 15 | 2% | 0 | 0% |
GENDER SP | ||||||||||||||||||
Male | 9 | 82% | 164 | 84% | 1 | 100% | 21 | 95% | 75 | 86% | 2 | 67% | 0 | 0% | 0 | 0% | 0 | 0% |
Female | 1 | 9% | 26 | 13% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 15 | 100% | 640 | 100% | 11 | 100% |
Both | 1 | 9% | 5 | 3% | 0 | 0% | 1 | 5% | 12 | 14% | 1 | 33% | 0 | 0% | 0 | 0% | 0 | 0% |
Unknown | 0 | 0% | 7 | 3% | 1 | 50% | 0 | 0% | 0 | 0% | 0 | 0% | 2 | 12% | 11 | 2% | 0 | 0% |
SYMPTOMS | ||||||||||||||||||
Dysuria | 0 | 0% | 5 | 2% | 0 | 0% | 5 | 23% | 21 | 24% | 2 | 67% | 4 | 24% | 235 | 36% | 7 | 64% |
Discharge | 4 | 36% | 49 | 24% | 1 | 50% | 6 | 27% | 10 | 11% | 2 | 67% | 5 | 29% | 495 | 76% | 10 | 91% |
GC History | ||||||||||||||||||
Yes | 0 | 0% | 21 | 11% | 0 | 0% | 4 | 18% | 18 | 21% | 0 | 0% | 0 | 0% | 168 | 26% | 8 | 73% |
No | 11 | 100% | 179 | 90% | 2 | 100% | 18 | 82% | 69 | 79% | 3 | 100% | 17 | 100% | 480 | 74% | 3 | 27% |
Unknown | 0 | 0% | 2 | 1% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 3 | 0% | 0 | 0% |
I am trying to see if the differences in these three groups are significant or not. I know we did not have same sample size but wanted to see the difference we have seen here are real. Please help me, i have not done any statistical test before.
FEMALE MSM MSW Alert Non-Alert Seed Alert Non-Alert Seed Alert Non-Alert Seed # % # % # % # % # % # % # % # % # % TOTAL 11 22% 202 21% 2 13% 22 44% 87 9% 3 19% 17 34% 651 69% 11 69% GENDER Male 0 0% 0 0% 0 0% 22 100% 85 98% 3 100% 17 100% 649 100% 11 100% Female 11 100% 202 100% 2 100% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% Male to Female 0 0% 0 0% 0 0% 0 0% 2 2% 0 0% 0 0% 0 0% 0 0% Unknown 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 2 0% 0 0% RACE African American 11 100% 176 87% 2 100% 17 77% 59 68% 3 100% 13 76% 609 97% 9 82% White 0 0% 8 4% 0 0% 3 14% 9 10% 0 0% 1 6% 21 3% 2 18% Other 0 0% 18 9% 0 0% 2 9% 19 22% 0 0% 3 18% 21 3% 0 0% ETHNICITY Hispanic 1 9% 6 3% 1 50% 3 14% 7 8% 1 33% 2 12% 24 4% 2 18% Non-Hispanic 10 91% 191 97% 1 50% 19 86% 80 92% 2 67% 15 88% 612 96% 9 82% Unknown 0 0% 5 2% 0 0% 0 0% 0 0% 0 0% 0 0% 15 2% 0 0% GENDER SP Male 9 82% 164 84% 1 100% 21 95% 75 86% 2 67% 0 0% 0 0% 0 0% Female 1 9% 26 13% 0 0% 0 0% 0 0% 0 0% 15 100% 640 100% 11 100% Both 1 9% 5 3% 0 0% 1 5% 12 14% 1 33% 0 0% 0 0% 0 0% Unknown 0 0% 7 3% 1 50% 0 0% 0 0% 0 0% 2 12% 11 2% 0 0% SYMPTOMS Dysuria 0 0% 5 2% 0 0% 5 23% 21 24% 2 67% 4 24% 235 36% 7 64% Discharge 4 36% 49 24% 1 50% 6 27% 10 11% 2 67% 5 29% 495 76% 10 91% GC History Yes 0 0% 21 11% 0 0% 4 18% 18 21% 0 0% 0 0% 168 26% 8 73% No 11 100% 179 90% 2 100% 18 82% 69 79% 3 100% 17 100% 480 74% 3 27% Unknown 0 0% 2 1% 0 0% 0 0% 0 0% 0 0% 0 0% 3 0% 0 0%
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.