Usage Note 20076: Importing multilingual Excel files (Chinese, Japanese, Korean) in
Enterprise Guide 4.x
Enterprise Guide 4.1 and SAS 9.1.3 do NOT support the import of
multilingual data, such as an Excel file that contains Japanese,
Chinese, and Korean or a mix thereof.
For example, when you use Enterprise Guide 4.1 to open Japanese data
when the selected language setting is Korean and pointing to SAS 9.1.3
(Korean), this error message appears
The character is incorrect. There was a transcoding error when trying
to read the data values. This can happen with characters that are
invalid for the current encoding.
Korean encoding (EUC-KR) and Japanese encoding (Shift-JIS) are not
compatible, so transcoding error messages appear if transcoding is
handled by the SAS server.
Here is one way to handle this issue:
- Select Start>Settings>Control Panel>Regional and Language
Options.
- Select the Advanced tab.
- Under Language for non-Unicode programs, select the appropriate
language. For the example above, you would select Japanese.
- Select OK.
- Reboot.
If you do not want to reset the regional and language settings on your
operating system and reboot, here is a workaround for this issue:
- Open the Excel file that contains the multilingual data.
- Select File>Save As.
- In the Save As dialog box, for "Save as type", select "Unicode
Text (*.txt)".
- Open SAS 9.1 (English with DBCS and Unicode Support) in a Unicode
session.
Note: to configure SAS 9.1 (English with DBCS and Unicode Support)
as a Unicode session:
- Open Notepad.
- Navigate to C:\Program Files\SAS\SAS 9.1\nls\1d.
- Open sasv9.cfg.
- Make these changes:
-DBCS
-DBCSTYPE PCMS
/* -DBCSLANG JAPANESE */
-ENCODING="utf-8"
- Select File>Save.
- Use PROC IMPORT with the ENCODING option set to UTF16:
FILENAME IN "C:\<filename>.txt" Encoding="utf-16";
PROC IMPORT OUT= WORK.<filename>
DATAFILE= IN
DBMS=TAB REPLACE;
GETNAMES=YES;
DATAROW=2;
RUN;
Note: Excel saves Unicode as UTF16. So, to import in SAS you must use
UTF16 encoding,
Note: If you have issues viewing the resulting SAS data set in a SAS
Viewtable, you can view the data set in HTML. To configure SAS
to produce the results in HTML, follow these steps:
- Select Tools>Options>Preferences.
- Select the Results tab.
- Under HTML, select the Create HTML checkbox.
- Select OK.
Note:See SAS Note #020428 for more information.
Note: To verify the encoding of your SAS session, submit this code:
proc options option=encoding; run;
Note: SAS will address multilingual support in a future SAS
release.
Operating System and Release Information
SAS System | SAS Enterprise Guide | Microsoft Windows 2000 Professional | 4.1 | | 9.1 TS1M3 SP1 | |
Microsoft Windows XP Professional | 4.1 | | 9.1 TS1M3 SP1 | |
Microsoft Windows NT Workstation | 4.1 | | 9.1 TS1M3 SP1 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Usage Note |
Priority: | high |
Topic: | System Administration ==> Installation ==> NLS (National Language Support)
|
Date Modified: | 2008-06-12 08:39:34 |
Date Created: | 2007-04-30 08:03:35 |