Import data with special character from Oracle to SAS EG

[Hhh111]

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;

[smantha]

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.

[Hhh111]

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?

[smantha]

https://communities.sas.com/t5/Administration-and-Deployment/How-to-Change-Encoding-from-WLATIN1-to-...

https://communities.sas.com/t5/SAS-Communities-Library/Change-Encoding-using-SAS-Enterprise-Guide-Wi...