topic Re: SAS/ACCESS in Administration and Deployment

SAS/ACCESS

Analysts12 — Fri, 09 Jul 2021 12:37:55 GMT

I have few question on ODBS and SAS/ACCESS Interface, since I am new to SAS .

how we will know which one we are using in our architecture: ODBC or SAS/Access interface for Teradata database?

If we are using ODBC, how can we move from ODBC to SAS/ACCESS interface to Teradata?

Analysts12 — Fri, 09 Jul 2021 12:38:18 GMT

**ODBC

KS4NCS — Sat, 10 Jul 2021 02:50:18 GMT

You can refer to below documentation for the different between SAS Access to ODBC other SAS Access Engine
https://documentation.sas.com/doc/en/bicdc/9.4/bidsag/p0r68n8gtyzjqen1ddl4r2q3eh4v.htm

By checking the libname statement, you will know you are using SAS Access to ODBC or Teradata.
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/titlepage.htm

To change from one access engine to another, refer the administration guide.
https://go.documentation.sas.com/doc/en/bicdc/9.4/bidsag/p0i782osdgo43tn1ehq1t7xgtw1i.htm

Hope this help.

SSmanjunath — Tue, 13 Jul 2021 07:43:21 GMT

make sure the tera data interface

run this.

proc setinit; and make sure should have teradata interface.

--SAS/ACCESS Interface to Teradata

if it is windows environment: make sure teradata ODBC drivers installed(recent updated)

And need to setup Environment variable for Taradata.