I've SAS 9.4 in my personal windows PC and trying to connect to Postgres database (aws storage) to access tables/datasets in the database. I would like to perform some analysis in SAS with that data. I tried creating library with libname and have below message.
ERROR: The POSTGRES engine cannot be found.
ERROR: Error in the LIBNAME statement.
Also, I checked whether I have access to Postgres in SAS (PROC SETINIT; RUN;) and I see that I've access to Postgres, ODBC etc. And then I tried PROC PRODUCT_STATUS; RUN; Here I don't see Postgres though.
I found this in one of the community posts " It's possible that you have SAS/Access to Postgres licensed but it is not installed on the server". I think, I'm in same situation. Could someone suggest me how to install it?
I don't have any server though. Just trying to connect to database from simple PC SAS on a personal laptop.
From your question what I understand is that you have SAS installed on your Windows PC and PostgreSQL installed on a remote machine (AWS).
Under this scenario, you need to establish an odbc connection. One option is to use the Microsoft ODBC Data Source Administrator . You will need a PostgreSQL odbc driver installed.
On PC SAS this would be my preferred method.
If you want to use SAS Access Interface to PostgreSQL please see here https://documentation.sas.com/doc/en/calcdc/3.4/dplyml0phy0dkr/n0zpnn9s53x8m9n1m22gfkf8f6eu.htm.
This later approach would be good for Server.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.