What is SAS ODBC?

What is SAS ODBC?

The SAS ODBC Driver is an implementation of the ODBC interface standard that enables you to access, manipulate, and update SAS data sources from applications that are ODBC compliant. As the following figure shows, the SAS ODBC Driver uses a SAS server to access data from your SAS data sources.

What does the SAS Access Libname statement reference?

The LIBNAME statement associates a libref with a SAS/ACCESS engine to access tables or views in a DBMS. The SAS/ACCESS engine enables you to connect to a particular DBMS and to specify a DBMS table or view name in a two-level SAS name.

How do I use ODBC in SAS?

Setting up a connection from SAS to an ODBC data source using Microsoft Windows NT authentication is a five-stage process.

1. Configure an ODBC data source using Microsoft Windows NT authentication.
2. Verify a library by submitting a LIBNAME statement with the ODBC engine.
3. Register a user.
4. Register the ODBC Server.

What is SAS database?

SAS (previously “Statistical Analysis System”) is a statistical software suite developed by SAS Institute for data management, advanced analytics, multivariate analysis, business intelligence, criminal investigation, and predictive analytics.