To better understand what it is you are trying to do please provide a more accurate representation of what the input data from TableIn in your example code is like and the expected output. ... View more

Consider Art's code and drop the variable 'column' from the want data set if you want only two variables column1 and column2. data want(drop=column);   set have;   format column1 column2 $25.;   column1=scan(column,1,";");   column2=scan(column,2,";"); run; proc print data=want; run; Regards, Vish ... View more

Thank you, it worked ... View more