HI I have the data like this and i would like to calculate p-value to to see if the populations differ statistically in terms of these variable (event).
FEMALE | |||||
Alert | Non-Alert | ||||
# | % | # | % | ||
TOTAL | 11 | 202 | |||
GENDER | |||||
Male | 0 | 0% | 0 | 0% | |
Female | 11 | 100% | 202 | 100% | |
Male to Female | 0 | 0% | 0 | 0% | |
Unknown | 0 | 0% | 0 | 0% | |
RACE | |||||
African American | 11 | 100% | 176 | 87% | |
White | 0 | 0% | 8 | 4% | |
Other | 0 | 0% | 18 | 9% | |
ETHNICITY | |||||
Hispanic | 1 | 9% | 6 | 3% | |
Non-Hispanic | 10 | 91% | 191 | 95% | |
Unknown | 0 | 0% | 5 | 2% | |
GENDER SP | |||||
Male | 9 | 82% | 164 | 81% | |
Female | 1 | 9% | 26 | 13% | |
Both | 1 | 9% | 5 | 2% | |
Unknown | 0 | 0% | 7 | 3% | |
SYMPTOMS | |||||
Dysuria | 0 | 0% | 5 | 2% | |
Discharge | 4 | 36% | 49 | 24% | |
GC History | |||||
Yes | 0 | 0% | 21 | 10% | |
No | 11 | 100% | 179 | 89% | |
Unknown | 0 | 0% | 2 | 1% |
@Dhana18 wrote:
HI I have the data like this and i would like to calculate p-value to to see if the populations differ statistically in terms of these variable (event).
I don't see a variable named EVENT.
Please refer to the exact position(s) in the table that you want to compare via a statistical test.
I also don't understand the percents shown, for example, next to unknown, there are 2 "Non-Alert" and 1%? How do you get 1% out of 2 observations?
P-value implies a statistical test. Which specific test do you want to conduct? If you can provide exactly want kind of question you
I would guess that the easiest test might be a chi-square but you have so many empty cells or counts < 5 that the test may not be reliable that is one of the least sensitive to small sample size tests.
This p-value can be computed from PROC FREQ, but I think we would need to see a portion of your actual data before we can provide code that you can use. Please follow these instructions to provide a portion of your data for us to see: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...
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!
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.