BookmarkSubscribeRSS Feed
Dhana18
Obsidian | Level 7

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.

 FEMALEMSMMSW
 AlertNon-AlertSeedAlertNon-AlertSeedAlertNon-AlertSeed
 #%#%#%#%#%#%#%#%#%
TOTAL1122%20221%213%2244%879%319%1734%65169%1169%
GENDER 
Male00%00%00%22100%8598%3100%17100%649100%11100%
Female11100%202100%2100%00%00%00%00%00%00%
Male to Female00%00%00%00%22%00%00%00%00%
Unknown00%00%00%00%00%00%00%20%00%
RACE 
     African American11100%17687%2100%1777%5968%3100%1376%60997%982%
     White00%84%00%314%910%00%16%213%218%
     Other00%189%00%29%1922%00%318%213%00%
ETHNICITY 
     Hispanic19%63%150%314%78%133%212%244%218%
     Non-Hispanic1091%19197%150%1986%8092%267%1588%61296%982%
Unknown00%52%00%00%00%00%00%152%00%
GENDER SP 
     Male982%16484%1100%2195%7586%267%00%00%00%
     Female19%2613%00%00%00%00%15100%640100%11100%
     Both19%53%00%15%1214%133%00%00%00%
Unknown00%73%150%00%00%00%212%112%00%
SYMPTOMS 
     Dysuria00%52%00%523%2124%267%424%23536%764%
     Discharge436%4924%150%627%1011%267%529%49576%1091%
GC History 
     Yes00%2111%00%418%1821%00%00%16826%873%
     No11100%17990%2100%1882%6979%3100%17100%48074%327%
Unknown00%21%00%00%00%00%00%30%00%
3 REPLIES 3
Dhana18
Obsidian | Level 7







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.
 FEMALEMSMMSW
 AlertNon-AlertSeedAlertNon-AlertSeedAlertNon-AlertSeed
 #%#%#%#%#%#%#%#%#%
TOTAL1122%20221%213%2244%879%319%1734%65169%1169%
GENDER 
Male00%00%00%22100%8598%3100%17100%649100%11100%
Female11100%202100%2100%00%00%00%00%00%00%
Male to Female00%00%00%00%22%00%00%00%00%
Unknown00%00%00%00%00%00%00%20%00%
RACE 
     African American11100%17687%2100%1777%5968%3100%1376%60997%982%
     White00%84%00%314%910%00%16%213%218%
     Other00%189%00%29%1922%00%318%213%00%
ETHNICITY 
     Hispanic19%63%150%314%78%133%212%244%218%
     Non-Hispanic1091%19197%150%1986%8092%267%1588%61296%982%
Unknown00%52%00%00%00%00%00%152%00%
GENDER SP 
     Male982%16484%1100%2195%7586%267%00%00%00%
     Female19%2613%00%00%00%00%15100%640100%11100%
     Both19%53%00%15%1214%133%00%00%00%
Unknown00%73%150%00%00%00%212%112%00%
SYMPTOMS 
     Dysuria00%52%00%523%2124%267%424%23536%764%
     Discharge436%4924%150%627%1011%267%529%49576%1091%
GC History 
     Yes00%2111%00%418%1821%00%00%16826%873%
     No11100%17990%2100%1882%6979%3100%17100%48074%327%
Unknown00%21%00%00%00%00%00%30%00%
Reeza
Super User
A p-value is based on a test, what test are you performing? What's your hypothesis?

I suspect since you have count data that a Chi Square or Fishers Test are more appropriate.

https://stats.idre.ucla.edu/other/mult-pkg/whatstat/

Please do not post the same question multiple times.
Dhana18
Obsidian | Level 7
Hi Reeza,
Sorry I was not sure if it posted the first time I posted. My hypothesis id ALERT Group is from African American race, non- Hispanic ethnicity, Alert male have more male partners than any other group, Alert have more symptoms and had GCC in the past than other groups.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 682 views
  • 0 likes
  • 2 in conversation