05-11-2015 01:30 PM
I am trying to import excel / text file with Chinese characters but the outcome is filled with " ??????? ".
Does anyone have an idea how to display Chinese characters properly in SAS?
05-11-2015 03:54 PM
Use an Unicode version (DBCS utf8) of your sas.exe. With some luck it is on your system.
The default en-language setting single byte will never process Chinese chars
05-12-2015 11:40 AM
I have 9.4 and not sure the language package or language support program was installed or not. Do I need to install any of those? because ENCODING='UTF-8' didn't work.
05-12-2015 10:12 AM
When deploying SAS, the default/mandatory supporting language is English with some optional languages including Simplified Chinese. Unless it is checked/selected, I don't see how you get to read Chinese characters. So start with your SAS admin or whoever installed your SAS, or if you have access to deployment summary: SAS(R) 9.3 Guide to Software Updates
05-12-2015 11:05 AM
When it is windows., look at the location
When it is Unix a similar location with the other /.
When that is there utf8 is present. The next one is getting it started. When not the installation has to be adjusted.
05-13-2015 08:28 AM
Check how to start SAS with utf-8 at :
National Language Support
You can change it at CONFIG file or
Start it with command .But Jaap pointed out , you should check it firstly .
"C:\Program Files\SAS\SASFoundation\9.2(32-bit)\sas.exe" -CONFIG "C:\Program Files\SAS\SASFoundation\9.2(32-bit)\nls\zh\SASV9.CFG" -encoding utf-8
and Check its LOG:
1 proc options option=encoding;
SAS (R) PROPRIETARY SOFTWARE RELEASE 9.2
ENCODING=UTF-8 Specifies default encoding for internal processing of data.
NOTE: 鈥淧ROCEDURE OPTIONS鈥濇墍鐢ㄦ椂闂达紙鎬诲鐞嗘椂闂达級:
瀹為檯鏃堕棿 0.01 绉?
CPU 鏃堕棿 0.01 绉?
05-12-2015 01:06 PM
You are missing the real location as that one can vary. Running a "proc options;run;" will show all settings and there should be namings like the one mentioned having the full name.
SAS 9.4 is a nice version as you are supposing to install them I assume you are on a open Windows desktop. Then with the that setup instaltation the language support is mentioned.
But check it before as it could be there having the Foundation location found.