topic Re: Invalid ASCII character in name. in SAS Programming

Invalid ASCII character in name.

msharma1788 — Wed, 14 Feb 2018 15:25:51 GMT

Requirement is to replace invalid character with valid character.

In case a dataset has the below values.

FIELD	FLDVALUE
FNAME	José
LNAME	Colón
LNAME	Colón
LNAME	Burgos-Suárez
LNAME	Nogueras-López
LNAME	Camacho-De León
LNAME	Padilla-Rodríguez
LNAME	Vilaró
MID	C>
LNAME	Vázquez-Hernández
LNAME	Montaño
LNAME	Camacho-De León
FNAME	Michaéla

We need the value as José = Jose

Burgos-Suárez= Burgos-Suarez

This data id pulled from EFT File and we need to reformat this data.

Please suggest.

Re: Invalid ASCII character in name.

RW9 — Wed, 14 Feb 2018 15:34:38 GMT

Use National Language support, change SAS session to UTF-8 encoding. Do a tranwrd() stastement for each character to change e.g.

want=tranwrd(have,"é","e");

Re: Invalid ASCII character in name.

ballardw — Wed, 14 Feb 2018 15:39:00 GMT

You do not tell us all characters are "invalid".

Likely you are looking for the TRANSLATE function which you provide a search string and a replacement string. Every character in the search string would be replaced by the corresponding character in the replacement string.

Suppose I want to replace > with a space and ! with and L in a variable then

str = translate(str,' L','>!');

note that the replacement list comes first and the search list of characters second. The number of characters in the replacement and search lists must match. if you want to replace every value in the search list with a blank then you need one blank for each character such as

str = translate(str,' ','!@#$%^&*()');

you would also need to ensure that you have the matching cases such as

str = translate(str,'aenN','áéñÑ');

Re: Invalid ASCII character in name.

Ksharp — Wed, 14 Feb 2018 16:07:20 GMT

data have;
 want=basechar('José');
 put want=;
run;

Re: Invalid ASCII character in name.

msharma1788 — Thu, 15 Feb 2018 07:54:43 GMT

Thanks! this really helps 🙂