I have two tables. One contains detailed summary of visits (including inpatient admissions) ever made to the hospital. Another table has the readmissions summary. I need to calculate the number of visits (observations, follow ups etc) between the previous inpatient admission discharge date and the readmission date.
Readmissions table has fields: readmission_admit_date, previous_discharge_date, PatientID.
VisitSummary table has fields: PatientID, VisitID, VisitServiceDateTime.
Visits between the previous discharge and readmission.
VisitServiceDateTime>previous_discharge_date and VisitServiceDateTime<readmission_admit_date
How can I get this done? through Load Editor or by Set Analysis. I am open for any suggestion.
You might get more bites if you post a dummy inline table that mirrors the structure of your data. Three things I don't leave home without, my license to drive, my license to carry, and a code sample mirroring the problem I'm trying to solve.
