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

[sasemi]

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?

[ballardw]

---

@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.

[jebjur]

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;

[sasemi]

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?

[SASKiwi · Accepted solution]

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&lo...

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