Hi Cherric , I have a another automated way which you can try, here you dont have to type name if the string have 1000 names. . data all; drop string; string = ' name1*name2*name3~name4*name5~name6 '; do until(word=' '); count+1; word = scan(string, count,'*~'); output; end; run; if you want it in horizontal way you can transpose the same
... View more