topic Re: SAS/ACCESS to connect to postgresql problem in New SAS User

SAS/ACCESS to connect to postgresql problem

shursulei — Thu, 17 Oct 2019 08:13:20 GMT

libname x2 postgres server="xxx" port=xx database="xxxx" schema="xxx"
user=xx password="xxx";
The log is as below:

DIAG: ERROR :invalid value for parameter "client_encoding":"lantin1".

I have sas/access to postgresql connect to postresql.I have two ways.I have sas base don't occur the error.

But i have eg ,The log is

invalid value for parameter "client_encoding":"lantin1".

Re: SAS/ACCESS to connect to postgresql problem

Amir — Thu, 17 Oct 2019 08:26:02 GMT

It looks like your client_encoding parameter has been incorrectly set to "lantin1" (an extra "n"), instead of "latin1".

Amir.

Re: SAS/ACCESS to connect to postgresql problem

shursulei — Thu, 17 Oct 2019 10:06:07 GMT

I have set system variable in the sasenv_local.
export PGCLIENTENCODING=latin1.
But the result is also as before.

Re: SAS/ACCESS to connect to postgresql problem

mrityunjaya — Tue, 22 Oct 2019 05:55:14 GMT

To Change the Encoding, you can refer my article:

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

Try the below libname after change the Encoding

libname test postgres server="xxx.xx.xxx.xx" port=xxxx user=xxxxxxx password='xxxxxx' database=xxxx schema=xxxxx;

Re: SAS/ACCESS to connect to postgresql problem

Amir — Thu, 17 Oct 2019 11:46:50 GMT

If you are getting the same result as before, as you said (invalid value for parameter "client_encoding":"lantin1" with the extra "n") then that indicates another setting has to be changed.

Can you add the client_encoding= option to the libname statement as shown in the following link?

https://documentation.sas.com/?docsetId=acreldb&docsetTarget=n1q0m2sl5jsi7mn125qfkflg9hfl.htm&docsetVersion=9.4&locale=en

Amir.

Re: SAS/ACCESS to connect to postgresql problem

Ksharp — Thu, 17 Oct 2019 12:12:50 GMT

Can you change your SAS encoding into 'utf-8' ?