topic Re: Oracle Libname: special chars in SAS Programming

Oracle Libname: special chars

MariaD — Tue, 23 Oct 2018 11:25:57 GMT

Hi Folks,

I use some Oracle tables that I access from a libname (Access to Oracle). Some of my Oracle's tables has special characters inside (not in column or table name but in the data values). Por example, I have a column call City and inside has values like "São Paulo". When I access the table from Oracle client, I saw the value "São Paulo" correctly. But when access from SAS EG, the value appear something like "S?o Paulo".

There is any option I can use on libname statement to see the correct characters in SAS EG?

I undestand that the option PRESERVE_COLUMN_NAME is only when the problem is on columns name, not on the values. And the option PRESERVE_TAB_NAMES is only for problems with the name of the table.

Regards,

Re: Oracle Libname: special chars

VDD — Tue, 23 Oct 2018 11:34:51 GMT

do you have your oracle schema = statement?

Re: Oracle Libname: special chars

s_lassen — Tue, 23 Oct 2018 11:57:23 GMT

I thinl your problem is this: Problem Note 51411: Oracle special characters might be displayed as question marks (?) in SAS®.

And the solution (other than changing the codepage for your SAS session) is here: Usage Note 18688: Data in a local language other than English might not be displayed correctly when you import the data from an Oracle database into SAS® software

Re: Oracle Libname: special chars

MariaD — Tue, 23 Oct 2018 12:14:00 GMT

So to solves the problem I need to set the NLS_LANG environment variable in my SAS server, That is correct?

Re: Oracle Libname: special chars

s_lassen — Wed, 24 Oct 2018 10:09:15 GMT

No, I think this refers to the Windows control panel. I cannot find the "advanced" tab in my own Windows control panel, but that may be because I am not administrator on my computer.