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...
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.