Hi fellow statalisters,
Hoping you can offer some assistance with this, as it's turned out to be more complicated than I initially thought.
I'm working with the HCUP State Inpatient Database for 2013. I'm trying to calculate 30-day readmission rates.
I have two primary variables:
visitlink: this is a unique patient identifier across the year
daystoevent: this is an encrypted date variable
This is the process for calculating readmission rate:
1. Identify "index" hospitalizations. These are identified as follows: 1) the first hospitalization for any patient 2) a hospitalization occurring more than 30 days after/before any other index hospitalization
2. Identify readmissions. These are hospitalizations occurring 30 days or less after an index hospitalization. Only the first instance of this is counted as a hospitalization (this means that the maximum readmission rate can be 100%).
Example, if hospitalizations happen on the following days:
Day 5: index
Day 10: readmission
Day 20: neither a readmission nor an index
Day 40: index
I don't think I've properly identified all index hospitalizations, and I'm having some trouble identifying readmissions in a systematic way.
The basic idea I've implemented so far is this:
1) Identify all first hospitalizations as index (this is easy, and done)
2) Identify any 2nd hospitalization occurring 30 days or fewer after the first index hospitalization as a readmission.
3) Identify any 2nd hospitalization occurring more than 30 days after the first index hospitalization as an index hospitalization.
But this isn't very systematic and doesn't generalize.
Hoping that someone hear has ideas!
Thanks!
Hoping you can offer some assistance with this, as it's turned out to be more complicated than I initially thought.
I'm working with the HCUP State Inpatient Database for 2013. I'm trying to calculate 30-day readmission rates.
I have two primary variables:
visitlink: this is a unique patient identifier across the year
daystoevent: this is an encrypted date variable
This is the process for calculating readmission rate:
1. Identify "index" hospitalizations. These are identified as follows: 1) the first hospitalization for any patient 2) a hospitalization occurring more than 30 days after/before any other index hospitalization
2. Identify readmissions. These are hospitalizations occurring 30 days or less after an index hospitalization. Only the first instance of this is counted as a hospitalization (this means that the maximum readmission rate can be 100%).
Example, if hospitalizations happen on the following days:
Day 5: index
Day 10: readmission
Day 20: neither a readmission nor an index
Day 40: index
I don't think I've properly identified all index hospitalizations, and I'm having some trouble identifying readmissions in a systematic way.
The basic idea I've implemented so far is this:
1) Identify all first hospitalizations as index (this is easy, and done)
2) Identify any 2nd hospitalization occurring 30 days or fewer after the first index hospitalization as a readmission.
3) Identify any 2nd hospitalization occurring more than 30 days after the first index hospitalization as an index hospitalization.
But this isn't very systematic and doesn't generalize.
Hoping that someone hear has ideas!
Thanks!
Comment