导入外部文件不成功,SAS提供以下错误说明:
"
An error occured executing the workspace job ''program'. Integration technologies failed to submit the code.[error] Failed to
transcode data from U_UTF8_CE to U_WLATIN1_CE encoding because it contained characters which are not supported by your SAS session encoding. Please review your encoding= and locale= SAS system options to ensure that they can accommodate the data that you want to process. A portion of the source string, in hex representation is:
[None] 5c88184:3b 2a 27 3b 2a 22 3b 2a 2f 3b 71 75 69 74 3b 72 |;*';*";*/;quit;r|
[None]5c88194: 75 62 3b 0d 0a 4f 50 54 49 4f 4e 53 20 50 41 47 |un;..OPTIONSPAG|
[Error] Some code points did not transcode.
"
原文请看下面。
我觉得问题可能在两个方面:1。外部数据包含SAS系统不识别的文字 2。外部数据产生的系统与SAS所在系统不匹配。
我的系统是windows,SAS是英文版EG, 察看proc options group=languagecontrol; run; Log 如下:
GOPTIONS ACCESSIBLE;
15 proc options group=languagecontrol; run;
SAS (r) Proprietary Software Release 9.3 TS1M0
Group=LANGUAGECONTROL
DATESTYLE=MDY Identify sequence of month, day and year when ANYDATE informat data is ambiguous
DFLANG=ENGLISH Language for EURDF date/time formats and informats
NOLOCALELANGCHG Do not change the language of SAS message text in ODS output when the LOCALE
option is specified
PAPERSIZE=LETTER Size of paper to print on
RSASIOTRANSERROR Display a transcoding error when illegal data values for a remote application
TRANTAB=(lat1lat1,lat1lat1,wlt1_ucs,wlt1_lcs,wlt1_ccl,,,)
Names of translate tables
URLENCODING=SESSION
Specifies URL percent encoding for the URLENCODE and URLDECODE functions
NODBCS Do not process double byte character sets
DBCSLANG=NONE Specifies the double-byte character set (DBCS) language to use
DBCSTYPE=NONE Specifies a double-byte character set (DBCS) encoding method
ENCODING=WLATIN1 Specifies default encoding for internal processing of data
LOCALE=EN_US Specifies the current locale for the SAS session
NONLSCOMPATMODE Uses the user specified encoding to process character data
我尝试的解决方法:
1。LOCALE=EN_US=== 修改为zh_CN;不行。
2。修改encoding, 用如下语句
filenamett 'H:\data1.txt' encoding='wlatin1' ;
encoding 的取值试过:ANYASCIIANY EBCDICANY Utf-8 ms-950 ms-936 ms-932 ms-949
还是一样的结果。
请问该怎么尝试?
谢谢。