09-17-2012 05:23 AM
I'm new to SAS Analytics Pro.
Got the following error when reading data from Oracle database.
It seems like the character set between SAS and Oracle DB does not match.
2 Data test;
3 set orapmkt.v_dw_hk_misc_clickthrough;
ERROR: Error fetching from cursor. ORACLE error is ORA-29275: partial multibyte character and no result.
NOTE: The DATA step has been abnormally terminated.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 500 observations read from the data set ORAPMKT.V_DW_HK_MISC_CLICKTHROUGH.
WARNING: The data set WORK.TEST may be incomplete. When this step was stopped there were 500
observations and 15 variables.
I have searched related documents on web and cannot find some sample script on how to set the character set to UTF-8 in the SAS section when retrieving the data.
Can someone help to answer where to put ENCODING=UTF-8?
Thanks a lot.
09-17-2012 07:55 PM
You will find the doc for this area of questions under NLS (national language support).
Not sure if below link is the answer:
Try to get support from your SAS Admin at your site for this. It's not really something a SAS "business" user should have to solve on it's own.