Hi, according to me you can again use the same set of conditional statements. with a few changes data one; input name $1-24; cards; BANGE RICHARD M AARON J BOWLER ; run; data two; set one; length new_name $24; if length(scan(name,1)) = 1 then new_name = substr(name, 3); else new_name = name; run; proc print; run; guess that would work. 🙂
... View more