Hi Guys, I am trying to convert one dataset into another (example given below) Input Data Name Age String John 28 A,BB Jack 25 M,BM,M4m,44,65 Jill 26 Output Data Name Age String_Old String_New John 28 A,BB A John 28 A,BB BB Jack 25 M,BM,M4m,44,65 M Jack 25 M,BM,M4m,44,65 BM Jack 25 M,BM,M4m,44,65 M4m Jack 25 M,BM,M4m,44,65 44 Jack 25 M,BM,M4m,44,65 65 Jill 26 This is getting too complicated for the SAS skills that i have. Can anyone help solve the same? Regards,
... View more