02-25-2017 02:26 PM
Hey SAS community,
I'm trying to figure out what kind of analysis I should perform/is it possible to determine if there is a correlation between state mortality rates for a condition and the proportion of a state population that has a characteristic.
I have my dataset set up like this:
State Year Deaths Total_Population Mortality_rate Percent_of_Population_with_Characteristic
what should I do?
02-25-2017 04:17 PM
ALWAYS start your analysis at the basics.
Do some summary tables so you understand the distributions and create graphs that show the trends over time overall and for the different states.
You can't do a basic linear regression because need to account for the multiple measurements at each state, PROC GLM. I think this is similar to your problem: