topic Re: Connecting to and accessing table in SQL database where there are multiple schemas in SAS Programming

Connecting to and accessing table in SQL database where there are multiple schemas

Kim_SOM — Thu, 10 Feb 2022 18:17:58 GMT

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
1. Schemas
  1. A
  2. B
  3. C
    1. Table_1
    2. Table_2
    3. 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.

Re: Connecting to and accessing table in SQL database where there are multiple schemas

AMSAS — Thu, 10 Feb 2022 18:47:54 GMT

Did you try the Schema option?

LIBNAME Statement for the PostgreSQL Engine

SCHEMA= LIBNAME Statement Option

Re: Connecting to and accessing table in SQL database where there are multiple schemas

Kim_SOM — Thu, 10 Feb 2022 19:20:12 GMT

Thank you -- that seems to work. I will have to test it.
I appreciate the quick response