topic How to transform names in European native language into English names in SAS Programming

How to transform names in European native language into English names

dayuan — Wed, 24 Feb 2016 01:53:23 GMT

Hi,

I am processing people names, and I find sometimes the names are in native language. For example, names are spelled like "André " or "Martínez". Currently I am manually tranforming such names into English one by one (e.g. "Andre" or "Martinez"), but there are so many names that I feel a little overwhelmed. I would really appreciate it if someone could kindly teach me a quicker way. Thank you very much in advance.

Re: How to transform names in European native language into English names

SASKiwi — Wed, 24 Feb 2016 02:52:28 GMT

If your problem is caused by different language encodings then this paper may help, in particular the conversion macro included:

http://support.sas.com/resources/papers/Multilingual_Computing_with_SAS_94.pdf

Re: How to transform names in European native language into English names

RW9 — Wed, 24 Feb 2016 10:23:35 GMT

Well, its a tricky one, as names could be anything. My suggestion would be to create a coded list. To do this, do a select distinct values of name from your dataset. Then go through the distinct list and add in the decoded value, e.g.:

CODE DECODE

André Andre

...

Then simply use that coded list to replce the original. I would imagine that you will need to do at least some manual review, I mean you could setup some programmatic conversions, but some will just be really random.

Re: How to transform names in European native language into English names

BrunoMueller — Wed, 24 Feb 2016 11:32:58 GMT

Have a look at the BASECHAR function, it might just do what you want.

Bruno

Re: How to transform names in European native language into English names

dayuan — Wed, 24 Feb 2016 16:24:42 GMT

Hi Bruno,

Thank you very much for the useful tip. In order to use the function of BASEDCHAR, should I install "National Language Support (NLS)" as an addition? Since currently the log suggests that "The function BASECHAR is unknown, or cannot be accessed"...

Re: How to transform names in European native language into English names

PGStats — Wed, 24 Feb 2016 18:30:01 GMT

Yes, you should install NLS.