topic Re: SAS Viya Encoding Settings in SAS Viya

SAS Viya Encoding Settings

ern_23 — Wed, 09 Jun 2021 12:00:48 GMT

Dear Community,

We have a few special letters in Turkish such as 'ü', 'ö' , 'ç' which are not exists in most of other languages. This may be problematic sometimes as I have to access data through SAS Viya from sources like Oracle or MsSQL.

So I when I try to load a table including text (words consist of special Turkish characters) on SAS Viya, such words are presented unproperly in the table (i.e günaydın. shown as g�nayd�n). This causes a serious problem cause when the loading process is done, any text unproperly represented in table is trimmed at the end. (i.e what left from g�nayd�n) is only g)

I have access to same table on SAS Enterprise Guide and I do not have such problem. Does any of you know how can I fix the problem on SAS Viya?

Thanks for your interest in advance.

Eren

Re: SAS Viya Encoding Settings

jimbarbour — Thu, 10 Jun 2021 00:51:11 GMT

Do you know what your current Viya encoding is? Can you run the following and post the results?

PROC OPTIONS OPTION=ENCODING;
RUN;

PROC OPTIONS OPTION=LOCALE;
RUN;

This should give us some idea of what's going on.

You may have to talk to your SAS Viya administrator. They may need to set up a Unicode Viya environment. If you already have a Unicode environment, then this may be a transcoding issue, and we may want to use some kind of function to handle the issue.

Jim

Re: SAS Viya Encoding Settings

SASKiwi — Thu, 10 Jun 2021 03:02:14 GMT

According to this link Turkish has a unique encoding in SAS of TURKISH or WTURKISH if your SAS sessions run on Windows.

As @jimbarbour advises, check your current ENCODING setting. That is likely to explain why you are having this problem.

Typically changing your SAS session encoding is the easiest way to resolve such problems.

Re: SAS Viya Encoding Settings

ern_23 — Mon, 14 Jun 2021 12:03:46 GMT

Thanks a lot for your contribution and solution suggestion!

Eren

Re: SAS Viya Encoding Settings

ern_23 — Mon, 14 Jun 2021 12:10:35 GMT

Thanks a lot for your contribution and solution suggestion!

Eren