how to replace the two consecutive special characters with single character

[raja777pharma]

Hi Team,

I have string with two colons (::) and would like to repalce this two colons with single special charcters like '@' or '$' or  ',' or ';'

String : "test1::test2::test3::test4::test5::" 

Expected out put string :  "test1,test2,test3,test4,test5" 

Thank you,

Rajasekhar.

[PaigeMiller]

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;