Hi,
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;
4 run;
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.
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.