SAS CHARACTER FUNCTIONS - 5 | TRANWRD VS TRANSLATE | TRANWRD & TRANSLATE FUNCTIONS IN SAS

[@beans802]

“John is good girl. That girl is naughty.” Who knew tranwrd() could be this interesting?

[@pavanreddy4673]

Gud

[@johnbabu6126]

How to do multiple changes in a given data by using Tranwrd function

[@learnerea]

Interesting... give me an example.. I'll solve that for you..

[@parneet2232]

@@learnerea like i want to change 'is' and 'girl' both in the example sentence.

[@ajaykushwaha-je6mw]

Hi Sir if possible can you also provide git hub link for the data set you use in tutorial.

[@learnerea]

link is already givne in the desctiption -
github.com/LEARNEREA/Excel_Files

[@kusum9785]

data test;
set dempsept.namelsit;
if propcase(gender)='m' then name2=tranwrd(name, "mr.","ms.");
else if propcase(gender)='f' then name2 =tranwrd(name,"ms.","mr.");
else name2=name;
run; why this code is not working

[@learnerea]

propcase makes the first letter capital.. instead try using locase(gender) = 'm'
let me know if that still gives the error..