topic Re: Connect to DB in SAS in SAS Programming

Connect to DB in SAS

Aexor — Sat, 20 Feb 2021 19:24:56 GMT

How to connect to DB is SAS?

Can we use SAS function while connecting to DB?

Re: Connect to DB in SAS

Tom — Sat, 20 Feb 2021 19:41:03 GMT

@Aexor wrote:

How to connect to DB is SAS?

Can we use SAS function while connecting to DB?

If you have one of the SAS/Access modules licensed. You can either define a libref or use the CONNECT statement in PROC SQL. SAS works fine when connected to an external database. But if you are using implicit access to query the remote database then if SAS cannot figure our how to translate your code into syntax for the remote database then SAS will pull the data over to SAS and then apply the function. If you use PROC SQL to issue commands directly in the remote database then you will need to use the syntax of that remote database in those statements.

Re: Connect to DB in SAS

Aexor — Tue, 23 Feb 2021 14:46:17 GMT

Can we use PUT, INPUT or any other SAS functions while connecting to DB ?

Re: Connect to DB in SAS

Tom — Tue, 23 Feb 2021 15:06:39 GMT

You cannot use SAS functions in the remote database. As to whether SAS can transform statements that use those two or other SAS functions into the remote database it depends on what products you have licensed from SAS and how you are using them. SAS/Access does have a way to translate many functions. I think there is actually a metadata table somewhere with which functions SAS knows how to translate. And for SAS/Access to Teradata there is (or at least used to be) a way to push the PUT() and INPUT() functions and format/informat definitions into Teradata.

Re: Connect to DB in SAS

Aexor — Thu, 25 Feb 2021 02:15:15 GMT

Thank you!!