MRN | AdmitDate | DischargeDate |
2 | 2019-01-05 | 2019-01-07 |
2 | 2019-01-30 | 2019-02-03 |
3 | 2019-11-20 | 2019-11-25 |
4 | 2019-05-12 | 2019-05-15 |
4 | 2019-05-19 | 2019-05-26 |
4 | 2019-07-29 | 2019-08-04 |
5 | 2019-04-08 | 2019-04-14 |
6 | 2019-03-09 | 2019-03-13 |
6 | 2019-03-18 | 2019-03-23 |
6 | 2019-08-01 | 2019-08-09 |
I am trying to calculate 30 day readmission rates for unique patients in a large dataset. I am familiar with how to use the datetime difference formula to calculate length of stay or 30 day intervals between a discharge and admit date. Where I am stuck, is how to calculate the 30 day readmission rates with the condition of unique patient identifiers?
I included dummy data with similar structure to see if anyone on the forums can assist me. Is anyone able to walk me through the tool or code that can accomplish this?
Solved! Go to Solution.
Hi there, I'm a student and having a difficult time trying to read the pick to get the formulas for both the Readmit Times and Readmit Flag. Can you please advise?
Thanks
Donna