topic Re: What do i miss using tranwrd() in SAS Programming

What do i miss using tranwrd()

Shmuel — Tue, 05 May 2020 09:53:17 GMT

73         data _null_;
 74           x = '111 abc 222';
 75           t = tranwrd(x,"efg","abc");
 76           put x= t=;
 77         run;
 
 x=111 abc 222 t=111 abc 222

Why tranwrd() did not replace the substring as coded ?

Re: What do i miss using tranwrd()

ed_sas_member — Tue, 05 May 2020 09:56:44 GMT

Hi @Shmuel

Didn't you mean the following instead of tranwrd(x, "efg", "abc") ? -> tranwrd(x, "abc", "efg")

 71         data _null_;
 72         x='111 abc 222';
 73         t=tranwrd(x, "abc", "efg");
 74         put x=t=;
 75         run;
 
 x=111 abc 222 t=111 efg 222

Re: What do i miss using tranwrd()

Kurt_Bremser — Tue, 05 May 2020 10:00:01 GMT

It is an inconsistency between TRANSLATE() and TRANWRD(). The order of "from" and "to" is reversed between the two.

Re: What do i miss using tranwrd()

Shmuel — Tue, 05 May 2020 10:24:05 GMT

I misunderstood the word "target" in the next syntax found in sas9.2 doc.:

Syntax

TRANWRD(source,target,replacement)

Thanks @Kurt_Bremser and @ed_sas_member for your quick answer.