matching admission data to discharge data for multiple admission of same subject

Posted by 000001994e66767c-dmarc-request on Sep 09, 2014; 4:36pm
URL: http://spssx-discussion.165.s1.nabble.com/matching-admission-data-to-discharge-data-for-multiple-admission-of-same-subject-tp5727191p5727193.html

 

Dear List Serve,

I have a data set with assessments of hospitalized patients on admission and the same assessments on discharge. Currently, all of the admission data is in one file and all of the discharge data in a second. There are a number of subjects who have had multiple hospitalizations within the time frame of the data set and each hospitalization generates another case (row) in the admission assessment file and discharge assessment file. Each subject has a unique ID number; each case also has the date of the assessment. There is missing data in the discharge assessment file so it is possible that there may be two hospitalizations (and therefore two cases in the admission assessment file) for the same subject and only one discharge assessment which should be paired with either the first admission assessment if the discharge occurred before the second hospitalization or with the second admission assessment if the discharge occurred after the second hospitalization. Because the admission and discharge data are currently in separate files, I'm struggling to automate determination of which admission assessment I should pair each discharge assessment with.

Any thoughts?

Thank you,

Steve Hahn

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD