SAS/ACCESS

[Analysts12]

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]

**ODBC

[KS4NCS]

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]

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.