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:
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.
Did you try the Schema option?
LIBNAME Statement for the PostgreSQL Engine
SCHEMA= LIBNAME Statement Option
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.