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