Many customers working with SAS on a Microsoft Windows desktop or server also have data stored in a Microsoft SQL Server database, and want to work with this data within SAS. SAS for Windows has two products, SAS/ACCESS® Interface to ODBC and SAS/ACCESS® Interface to OLEDB, that can connect to Microsoft SQL Server. With either product, you need to complete some configuration outside of SAS before SAS can connect to the database and access the tables. This article describes how to configure both the SQL Server OLEDB data provider and/or the SQL Server ODBC driver on a Windows machine, as well as the different ways to connect to a database in SAS.
The rapid growth of AI technologies is driving an AI skills gap and demand for AI talent. Ready to grow your AI literacy? SAS offers free ways to get started for beginners, business leaders, and analytics professionals of all skill levels. Your future self will thank you.