topic translate special vowels in SAS Viya in SAS Viya

translate special vowels in SAS Viya

USP2405 — Mon, 20 Nov 2023 12:11:22 GMT

I am using translate function to replace these all vowels into their case equivalent. Since these vowels are with special values translate function is not working for me. Can anyone please help on it?

e.g.

translate from - 'à' , 'À' , 'è' , 'È' , ''î' , 'Î' , 'ô' , 'Ô'

Translate to - a, A, e, E, i, I, o, O

Re: translate special vowels in SAS Viya

BrunoMueller — Mon, 20 Nov 2023 13:09:10 GMT

You could use the BASECHAR function to do this, like so:

data want;
  text = 'abc*àÀèÈîÎôÔ*def' ;
  baseText = basechar(text);
run;

SAS Viya is always running with UTF-8 encoding, some function are byte based and will not work with UTF-8 encoding.

You can also use the KTRANSLATE function, just replace TRANSLATE with KTRANSLATE