Remove the second '.' in the variable.

[Sathish_jammy]

Hello,

I would like to remove the Second '.' of value in the character variable.

For Example 

(5.8.8) turn it as (5.88)

Kindly suggest code to solve it.

Thank you.

[PeterClemmensen · Accepted solution]

Here is one way

data _null_;
    a='5.8.8';
    b=prxchange('s/(.*\..*)(\.)(.*)/$1$3/', -1, a);
    put b;
run;

[Ksharp]

data _null_;
x='(5.8.8)';
f=findc(x,'.');
s=findc(x,'.',f+1);
want=cats(substr(x,1,s-1),substr(x,s+1));
put want=;
run;