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%
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.