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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.