Hi all - been struggling with this for a little bit and it seems incredibly simple. I've tried a simple left join but it didn't give me the results I was hoping for. I have a dataset of hospitalizations containing patient identification numbers and various other characteristics. in the dataset, we have index events hospitalizations for a certain procedure + readmission hospitalizations. Thus, a specific patient ID number has 2 rows of data if they were readmitted (with the latter having readmission=1 and readmitdiagnosis. Values for these variables are null in the index hospitalization row. How can I collapse these rows so each patient just has one row containing all of their data + readmission, readmitdiagnosis from the latter line? Thank you in advance for the help.
... View more