data have;
input ID $8. Description $;
cards;
001 Text1
002:003 Text2
;
data Need;
length _id $20;
set have;
do _n_=1 to countw(id,':');
_id=scan(id,_n_,':');
output;
end;
drop id;
rename _id=id;
run;
Catch up on SAS Innovate 2026
Dive into keynotes, announcements and breakthroughs on demand.