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;
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.