topic Re: How to deal with "ERROR: The POSTGRES engine cannot be found."? in SAS Enterprise Guide

How to deal with "ERROR: The POSTGRES engine cannot be found."?

sasemi — Fri, 14 Sep 2018 17:47:36 GMT

Hi,

I am using SAS EG 7.1 and the following code trying to connect to PostgreSQL:

libname A1 postgres
server=XXX
port=5432
database=XXX
user=XXX
password='XXX';

But I get an error like:

ERROR: The POSTGRES engine cannot be found.
ERROR: Error in the LIBNAME statement.

When run {proc setinit; run;}, find [SAS/ACCESS to Postgres] installed.

How to deal with it?

Re: How to deal with "ERROR: The POSTGRES engine cannot be found."?

ballardw — Fri, 14 Sep 2018 17:55:45 GMT

@sasemi wrote:

Hi,

I am using SAS EG 7.1 and the following code trying to connect to PostgreSQL:

libname A1 postgres
server=XXX
port=5432
database=XXX
user=XXX
password='XXX';

But I get an error like:

ERROR: The POSTGRES engine cannot be found.
ERROR: Error in the LIBNAME statement.

When run {proc setinit; run;}, find [SAS/ACCESS to Postgres] installed.

How to deal with it?

Proc Setinit shows that a product is licensed.

Try

proc product_status;

run;

to show what is actually installed, or at least it does for SAS Display manager.

Re: How to deal with "ERROR: The POSTGRES engine cannot be found."?

jebjur — Fri, 14 Sep 2018 17:58:07 GMT

It's possible that you have SAS/Access to Postgres licensed but it is not installed on the server. Run the following code and see if SAS/Access to Postgres is listed in the product_status:

proc setinit noalias; run; %put _all_; proc product_status; run;

Re: How to deal with "ERROR: The POSTGRES engine cannot be found."?

sasemi — Fri, 14 Sep 2018 19:07:49 GMT

proc setinit noalias; run;

Find:

SAS/ACCESS to Postgres

But,

proc product_status; run;

Can't find:

For SAS/ACCESS Interface to Postgres

How to install the component?

Re: How to deal with "ERROR: The POSTGRES engine cannot be found."?

SASKiwi — Sat, 15 Sep 2018 22:29:58 GMT

You use the SAS Deployment Wizard on the server where you want to add it and select the install additional software option. Note it would be safest to use the SAS install account to do this unless your user account has full admin access.

See here for more details: https://documentation.sas.com/?docsetId=whatsdiff&docsetTarget=installsteps.htm&docsetVersion=9.4&locale=en

This type of task is best done by your SAS Administrator. Since you didn't know how to install additional software I'm assuming that you are not a SAS administrator - sorry if I got this wrong