Actually, no, although everything depends on what you want to do after having massaged the files. In general, having several instances of the same variable on the same record is bad practice.
I would probably start with merging the files so that you have age and gender info and one diagnosis on each record. This will make it much easier to deal with the fact that you have several diagnoses for each patient.
Code: Select all
Match files /table=agegenderdatabase
and then you can aggregate, if you need number of diagnoses per patient or something like that. Otherwise it is much easier to get variances, frailty or similar stuff right with a (quasi) normalized data structure.