topic Re: how to remove mulitple word in SAS Programming

how to remove mulitple word

Aayushi_17 — Wed, 02 Sep 2020 12:59:43 GMT

if i have input as 'aaaaaabbbbcccccccc' then output should be populated with single value like 'abc'.

Thanks in advance

PeterClemmensen — Wed, 02 Sep 2020 13:01:00 GMT

What if it was "aaaaaabbbbccccccccaaaaaaa" ?

Aayushi_17 — Wed, 02 Sep 2020 13:03:23 GMT

yes order can be different

PeterClemmensen — Wed, 02 Sep 2020 13:04:39 GMT

But would the string I posted result in "abc" or "abca" ?

Aayushi_17 — Wed, 02 Sep 2020 13:07:25 GMT

it should be abc no mulitple a can be used

PeterClemmensen — Wed, 02 Sep 2020 13:09:50 GMT

Ok try this

data _null_;
   s1 = "aaaaaabbbbcccccccc";
   s2 = prxchange("s/(.)(?=\1{1})//", -1, s1);
   put s2=;
run;