topic Re: Replace multiple instances to one in SAS Programming

Replace multiple instances to one

Anuz — Tue, 30 Nov 2021 21:32:48 GMT

Hi,

I have a peculiar situation.

I have a column in a dataset that can have values as below

002-0002==NON-FINAL/INTERNAL TEST|009-0004==CUSTOM/RELATIONSHIP

002-0002==NON-FINAL/INTERNAL TEST

What I want as output is to replace '==' with just one '='

so desired output

002-0002=NON-FINAL/INTERNAL TEST|009-0004=CUSTOMER/RELATIONSHIP

002-0002=NON-FINAL/INTERNAL TEST

What function can I use for the same ?

Thank you.

PaigeMiller — Tue, 30 Nov 2021 21:36:52 GMT

How about the TRANWRD function? Example:

newstring=tranwrd(oldstring,'==','=');

Anuz — Tue, 30 Nov 2021 21:42:23 GMT

@PaigeMiller - thank you . that worked. I had tried translate but that did not treat the two == as one occurence ..