topic Multiple argument for TRANWRD function in SAS Programming

Multiple argument for TRANWRD function

SASdevAnneMarie — Tue, 24 Aug 2021 12:25:59 GMT

Hello Experts,

I would like to replace the "â" by "a" and the "ô " by "o" in the column My_data.

Could I use TRANWRD function with multiple arguments like My_data2=TRANWRD(My_data,"â",a,"ô",o) ?

There is some function that runs with multiple arguments please and replace the character?

PaigeMiller — Tue, 24 Aug 2021 12:32:11 GMT

I think the TRANSLATE function does what you want.

Tom — Tue, 24 Aug 2021 12:42:54 GMT

Check you ENCODING setting. You can check the automatic macro variable SYSENCODING.

If you are using a single byte encoding like WLATIN1 then solution like in this question using TRANSLATE() will work.

Otherwise if you are using a multi-byte encoding like UTF-8 then you will need to use the KTRANSLATE() function instead.

SASdevAnneMarie — Tue, 24 Aug 2021 12:48:11 GMT

Thank you, Tom !
That works !

Ksharp — Tue, 24 Aug 2021 13:28:05 GMT

Also check function BASECHAR()