Hello,

I have a data which looks like below: Some of the patients have multiple diagnosis.

ID(200 patients)   Diag (100 unique Diag-200 in general)   Proc (50 uniqe Proc)  DOB (200)   Gender (200)   
a                           daig1
b                           diag2
c                            diag1

I want to reformat this data to :

ID   diag1 diag 2 diag 3..  diagx   proc1   proc2   proc3... procx  DOB  Gender
a1011  20F

Thanks a lot for your help and time.
 
Best,Farnoosh Sheikhi
	[[alternative HTML version deleted]]

