topic Re: Import data with special character from Oracle to SAS EG in SAS Programming

Import data with special character from Oracle to SAS EG

Hhh111 — Fri, 24 Jul 2020 01:14:58 GMT

Hi,

I need help how to include special character that extracted from Oracle database. I've used Encoding as per below script, however symbol like "1/2" interpreted as "?" in SAS.

PROC SQL NOPRINT;
                CONNECT TO ODBC (DSN=OracleODBC UID='XXX' PWD='12345');

                CREATE TABLE TEST (COMPRESS=YES ENCODING='UTF-8') AS 
                
                SELECT     *
                FROM CONNECTION TO ODBC 
                (
                SELECT     *
                FROM &TABLE 
	
                )

                ;
                DISCONNECT FROM ODBC;
QUIT;
RUN;

Re: Import data with special character from Oracle to SAS EG

smantha — Fri, 24 Jul 2020 03:18:51 GMT

Is your SAS session UTF-8 /unicode if not eevnthough the data read is utf-8 it may not display correctly in your session. you can change this by changing the encoding option.

Re: Import data with special character from Oracle to SAS EG

Hhh111 — Fri, 24 Jul 2020 03:26:12 GMT

Hi Smantha,
TQ for your reply.
when I run below script, it shows that my SAS session is = LATIN1

proc options option=encoding; run;

may I know what encoding option do I have to change to ensure SAS captured the special character from Oracle?

Re: Import data with special character from Oracle to SAS EG

smantha — Fri, 24 Jul 2020 03:37:18 GMT

https://communities.sas.com/t5/Administration-and-Deployment/How-to-Change-Encoding-from-WLATIN1-to-UTF-8-in-SAS-Enterprise/td-p/597234

https://communities.sas.com/t5/SAS-Communities-Library/Change-Encoding-using-SAS-Enterprise-Guide-Windowing-Environment/ta-p/597621