Help using Base SAS procedures

Testing if change in % is signifcant from one year to the next

Reply
N/A
Posts: 0

Testing if change in % is signifcant from one year to the next

Can anyone tell me the appropriate statistical test in SAS for seeing if a change in percent or rate is significant?

I am looking at two different things:
1. mortality rates from 1 year to the next as well as over a ten year period to see if there was a statistically significant increase or decrease.

2. Percent of a county's births that are low birth weight from 1 year to the next and over a ten year period looking to see if change was significant.

Thanks
Trusted Advisor
Posts: 2,115

Re: Testing if change in % is signifcant from one year to the next

Posted in reply to deleted_user
In just comparing two years, you could do it with a simple chi-squared test (PROC FREQ).

In looking at a longer time period, you might best do that with a logistic regression model treating year as a predictor variable (that would look for a linear trend in the change). (The MEASURES option in PROC FREQ will do ordinal association, to look at a monotonic change.)

Doc Muhlbaier
Duke
N/A
Posts: 0

Re: Testing if change in % is signifcant from one year to the next

Thanks. When looking at % low birth weight between two years I just compared the overall average: 2005 at 7.7% and 2006 at 7.9%. When I plug this into proc freq/chisq it thinks I only have two observations, which I can understand why sas thinks that based on my number of observations but in reality LBW is calculated from thousands of records. How can I overcome this without putting every observation in sas?

Thanks
Trusted Advisor
Posts: 2,115

Re: Testing if change in % is signifcant from one year to the next

Posted in reply to deleted_user
Ask a Question
Discussion stats
  • 3 replies
  • 124 views
  • 0 likes
  • 2 in conversation