data want;
string="test1::test2::test3::test4::test5::";
wanted_string=tranwrd(string,'::',',');
/* Remove final comma */
if substr(wanted_string,length(wanted_string))=',' then wanted_string=substr(wanted_string,1,length(wanted_string)-1);
run;
-- Paige Miller
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.