topic How to convert unsupported characters to English characters in SAS in SAS Procedures

How to convert unsupported characters to English characters in SAS

null — Thu, 16 Jan 2020 03:12:51 GMT

Hi All,

The problem I met is that I want to convert unsupported characters to English characters in SAS.

For example, for text ASÃ, it needs to be ASA.

I dummy one dataset for testing.

data test;
infile datalines dsd;
input char $;
datalines;
FÃ‰B
FÉBR
ASÃ
ASÍA
Ljusröd
Mörkröd
abc def
bd-fa
;
run;

Would you please help me with this?

Thanks!!!

Re: How to convert unsupported characters to English characters in SAS

unison — Thu, 16 Jan 2020 03:38:26 GMT

There's no perfect 1:1 mapping, look into https://communities.sas.com/t5/SAS-Programming/Removing-non-Unicode-characters-from-a-variable/m-p/343298/highlight/true#M78806

You can try making translate rules like the following:

data have;
	infile datalines dsd;
	input char $;
	datalines;
FÃ‰B
FÉBR
ASÃ
ASÍA
Ljusröd
Mörkröd
abc def
bd-fa
;
run;

data want;
	set have;
	new_char=translate(upcase(char), 'A', 'Ã');
run;

Re: How to convert unsupported characters to English characters in SAS

PGStats — Thu, 16 Jan 2020 03:55:42 GMT

You don't say what output you want. To convert alphabetic characters, use BASECHAR:

data test;
infile datalines dsd;
input char $;
asciiChar = basechar(char);
datalines;
FÃ‰B
FÉBR
ASÃ
ASÍA
Ljusröd
Mörkröd
abc def
bd-fa
;

proc print data=test noobs; run;

char 	asciiChar
FÃ‰B 	FA‰B
FÉBR 	FEBR
ASÃ 	ASA
ASÍA 	ASIA
Ljusröd 	Ljusrod
Mörkrö 	Morkro
abc def 	abc def
bd-fa 	bd-fa

Re: How to convert unsupported characters to English characters in SAS

null — Thu, 16 Jan 2020 07:55:52 GMT

Thanks a lot, unison. It's helpful.

Re: How to convert unsupported characters to English characters in SAS

null — Thu, 16 Jan 2020 07:57:07 GMT

Thanks a lot PG! This is exactly what I want.