Hi,

I have multiple SPSS databases regarding the same patients. My goal is to merge all this data in one single database. The problem I encountered is that some of these databases use different 'lines' per patientID, for example two times the same patientID for length and weight separated instead of put together next to each other, like this:

ID - measurement - outcome

1. - lenght - 173

1. - weight - 85

2. - lenght - 188

I woudl like to see them put togeher (so that every patientID only occurs one time):

ID - measurement - outcome - measurement2 - outcome2

1. - length - 173 - weight - 85

2. - length - 188

The one-to-one merge works well if a patient ID only occurs one time in a database. The one-to -many merge unfortunaltely still leaves me with duplicate patientID numbers and separated data over different 'lines'.

Is there a way in which I could merge files together based on patientID's while putting the different variables per patient in the same line (next to each other) like the second option?

Thanks in advance!