I have been granted access to tables in a data warehouse. When I use software such as DBeaver, I can open the tables I need. I need to analyze the data using SAS and I can't access the tables.
Here's the warehouse setup:
Database ABCD
Schemas
A
B
C
Table_1
Table_2
Table_3
libname statement
libname A1 postgres server="XXXXXXXXXX" port=5432
user=usrname pwd='XXXXX' database=abcd;
SAS LOG:
NOTE: Libref abcd was successfully assigned as follows: Engine: POSTGRES Physical Name: XXXXXXXXXX
SAS Code: Proc contents data=a1._all_; run;
SAS LOG:
ERROR: File A1.Table1 does not exist.
I am not sure what other libname options I need.
Your help is greatly appreciated.
... View more
