Help using Base SAS procedures

using correct weights for readmission rates

Reply
Regular Learner
Posts: 1

using correct weights for readmission rates

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;

Ask a Question
Discussion stats
  • 0 replies
  • 234 views
  • 0 likes
  • 1 in conversation