Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- SAS Procedures
- /
- Testing if change in % is signifcant from one year...

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

01-07-2009 04:47 PM

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

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

01-07-2009 05:10 PM

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

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Doc_Duke

01-08-2009 11:57 AM

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

Thanks

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

01-08-2009 12:20 PM

Here is an example of how to do a frequency table on counts

http://support.sas.com/documentation/cdl/en/procstat/59629/HTML/default/procstat_freq_sect003.htm

http://support.sas.com/documentation/cdl/en/procstat/59629/HTML/default/procstat_freq_sect003.htm