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.

SAS Innovate 2025: Call for Content

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!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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