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

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

VVDR — Thu, 13 May 2021 06:18:41 GMT

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

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

Kurt_Bremser — Thu, 13 May 2021 06:22:20 GMT

Assign a LIBNAME to the schema and use PROC COPY?

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

VVDR — Thu, 13 May 2021 06:26:59 GMT

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

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

Kurt_Bremser — Thu, 13 May 2021 06:36:42 GMT

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

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

VVDR — Thu, 13 May 2021 06:47:43 GMT

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

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

VVDR — Thu, 13 May 2021 06:49:39 GMT

Hi,

I have opened another query belwo for that Libname error.

Amazon Redshift to SAS CLI error - SAS Support Communities

Thanks