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

[000001994e66767c-dmarc-request]

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

[David Marso]

see ADD FILES and use BY subcommand.
see LAG function to compare!
---

000001994e66767c-dmarc-request wrote

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

[000001994e66767c-dmarc-request]

 

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