How to get all the tables from Redshift to SAS by using Sql pass through

[VVDR]

Hi All,

I am trying to get all the tables from one schema in redshift to SAS.

how to use pass through for this. How can we store those refreshed Views/tables in SAS Library.

Please suggest.

Regards

VVDR

[Kurt_Bremser]

Assign a LIBNAME to the schema and use PROC COPY?

[VVDR]

Hi, 

I am facing some issues with Libaname. hence, I am trying to use pass through and store all the tables in SAS library. 

Thanks 

[Kurt_Bremser]

If you get a CONNECT TO working, a LIBNAME should also be possible. What are your LIBNAME issues? Please post your log(s).

[VVDR]

Hi,

Can you please suggest me the possible method on pass through in terms of getting all the tables from one particular schema of Redshift to SAS library.

That would be a great help.

Thanks 

[VVDR]

Hi,

I have opened another query belwo for that Libname error. 

Amazon Redshift to SAS CLI error - SAS Support Communities

Thanks