topic How to replace all but last occurences of a substring in SAS Programming

How to replace all but last occurences of a substring

chris2377 — Tue, 31 Aug 2021 12:55:45 GMT

Hi,

How can I replace all dots, except for the last one in the string? I want something like this

data ds;
input have :$15. want :$15.;
datalines;
abc.def.ghi abcdef.ghi
xyz.zyx xyz.zyx
1.234.567.8 1234567.8
134.56 134.54
;
run;

I know how to replace all dots, but I don't how to leave the last one

Re: How to replace all but last occurences of a substring

Ksharp — Tue, 31 Aug 2021 13:01:44 GMT

How about this one ?

data ds;
input have :$15. want :$15.;
datalines;
abc.def.ghi abcdef.ghi
xyz.zyx xyz.zyx
1.234.567.8 1234567.8
134.56 134.54
;
run;
data want;
 set ds;
 n=countc(have,'.')-1;
 new_want=prxchange('s/\.//',n,have);
run;

Re: How to replace all but last occurences of a substring

chris2377 — Tue, 31 Aug 2021 13:08:07 GMT

@Ksharp
Perfect. Thanks!