topic Re: Proc import : language issues in SAS Procedures

Proc import : language issues

Liamb — Thu, 11 Mar 2021 18:42:15 GMT

Hello,

I imported an excel file with a column containing Kazakh (+++) and other languages (Russian, English) and I get this warning message "Some character data was lost during transcoding in column". My column values beyond those in English have all been changed. How can I solve this issue?

Thanks

Best regards,

Re: Proc import : language issues

SASKiwi — Thu, 11 Mar 2021 18:52:45 GMT

Check your SAS session encoding setting:

proc options option = encoding;
run;

Usually session encoding needs to be set to UTF-8 to handle multiple languages.

Re: Proc import : language issues

Liamb — Thu, 11 Mar 2021 19:43:46 GMT

Please see below the output I get :

proc options option=encoding;
run;

SAS (r) Proprietary Software Release 9.4 TS1M6

ENCODING=WLATIN1 Specifies the default character-set encoding for the SAS session.

How can I changes that to UTF-8?

Thanks

Re: Proc import : language issues

SASKiwi — Thu, 11 Mar 2021 19:53:36 GMT

Unfortunately this can only be done for the whole SAS session so needs to be set when starting SAS. Do you use SAS on your PC or a remote SAS server? If it is the latter then only a SAS administrator can deal with that.

Re: Proc import : language issues

Liamb — Thu, 11 Mar 2021 19:56:45 GMT

I use SAS on my PC.

Re: Proc import : language issues

SASKiwi — Thu, 11 Mar 2021 21:15:53 GMT

Locate the sasv9_usermods.cfg file in your PC's SAS Home directory and add this line:

-ENCODING UTF-8

Start a SAS session and check your ENCODING option again.

Re: Proc import : language issues

Ksharp — Fri, 12 Mar 2021 11:41:59 GMT

filename x 'c:\temp\x.csv' encoding='utf8' ;
proc import datafile=x out= ...............

Re: Proc import : language issues

Liamb — Mon, 15 Mar 2021 16:08:11 GMT

Sorry for my late reply

I did not have the authorizations to modify the sasv9_usermods.cfg file and if I convert my Excel file to CSV I lose my values written in Kazakhe. Finally, I used SAS Unicode supported to process my data file