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.
... View more