turn on suggestions

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
- /
- using correct weights for readmission rates

Topic Options

- 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

10-23-2016 02:28 PM

I am trying to calculate readmission rates in patients who had the indexevent. In the sample data below, readmission is indicated by readmitcount variable. The first two observations had one readmission each (observations 4 and 5 are readmissions to observations 1 and 2).. So the readmit_key and re1_discwt are the readmission keys and readmission discharge weights respectively. The readmissions themselves do not have to have an index event.

Intuitively I know that readmission rate should be sum of weights during readmissions (4+3)/sum of weights where Indexevent=1 (5+9+6) ie 35%.

But I am having difficulty choosing different discharge weights for numerator and denominator since proc surveymeans only allows one weight statement.

any suggestions?

data test;

input key indexevent discwt readmit_key re1_discwt readmitcount;

datalines;

1000 1 5 1003 4 1

1002 1 9 1004 3 1

1005 1 6 . . 0

1003 0 4 . . 0

1004 0 3 . . 0

1007 0 7 . . 0

;

run;