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,
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.
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
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.
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.
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: