SAS/ACCESS Software for Relational Databases: Reference

Introduction

SAS/ACCESS software enables you to access data in a database management system (DBMS) or other data source in order to use that data in your SAS programs. Microsoft OLE DB is an API (application programming interface) that provides access to data, which can be in many forms, including a database table, an email file, a text file, or other kind of file. This SAS/ACCESS interface accesses data from these sources through the OLE DB data providers. You specify the data provider, data source, and other connection information in a SAS/ACCESS LIBNAME statement and the SQL Procedure Pass-Through facility. The SQL procedure is a base SAS procedure that works with SAS/ACCESS software to send and receive data directly between a data source and SAS software. You can store Pass-Through code in a PROC SQL view for later use.

For more information about the OLE DB API, see the Microsoft OLE DB reference documentation. This chapter accompanies and should be used with SAS/ACCESS Software for Relational Databases: Reference (order #57204).(footnote 1)

Chapter Contents
Previous
Next
Top of Page