topic Re: Remove the second '.' in the variable. in SAS Programming

Remove the second '.' in the variable.

Sathish_jammy — Tue, 07 Jan 2020 12:59:10 GMT

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 — Tue, 07 Jan 2020 13:13:32 GMT

Here is one way

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

Ksharp — Wed, 08 Jan 2020 12:42:59 GMT

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;