BookmarkSubscribeRSS Feed
terry711
Calcite | Level 5

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.

1 REPLY 1
Patrick
Opal | Level 21

You will find the doc for this area of questions under NLS (national language support).

Not sure if below link is the answer:

http://support.sas.com/documentation/cdl/en/nlsref/63072/HTML/default/viewer.htm#n08gwe43ne71imn1oz7...

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.

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 3830 views
  • 0 likes
  • 2 in conversation