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.

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

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
  • 1336 views
  • 0 likes
  • 2 in conversation