SAS POSTGRES conncetivity issue

raxit143 — Sat, 13 Jul 2019 14:26:17 GMT

Hi All,

Greetings!

We are getting below error while assigning Postgres library in SAS EG. We have SAS ACCESS to PostGres in license.

25 GOPTIONS ACCESSIBLE;

ERROR: Could not load /sas/SASHome/SASFoundation/9.4/sasexe/sasptg (94 images loaded)

ERROR: psqlodbcw.so: cannot open shared object file: No such file or directory

26 libname postgre postgres database=sharedservice user=dbmsowner password=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX;

ERROR: The SAS/ACCESS Interface to POSTGRES cannot be loaded. The SASPTG code appendage could not be loaded.

ERROR: Error in the LIBNAME statement.

What can be the resolution?

Thanks & Regards,

Rak**bleep** Shah

Re: SAS POSTGRES conncetivity issue

Reeza — Sat, 13 Jul 2019 18:45:51 GMT

Verify your license and installation first.

*checks what is installed;
proc product_status;run;

*check what is licensed;
proc setinit;run;