Chapter Contents

SAS/ACCESS Software for Relational Databases: Reference

Introduction

SAS/ACCESS software enables you to access data in a database management system (DBMS) and use that data in your SAS programs. The SAS/ACCESS interface to ODBC connects you to DBMS data by using the SAS LIBNAME statement, the SQL Procedure Pass-Through facility, and the DBLOAD procedure. The SQL procedure is a base SAS procedure that works with SAS/ACCESS software to send and receive data directly between a DBMS and SAS software. You can store Pass-Through code in a PROC SQL view for later use.

The CV2ODBC procedure converts Version 6 view descriptors for AS/400 or Microsoft SQL Server to Version 8 ODBC view descriptors for the SAS/ACCESS interface to ODBC, which runs under the Microsoft Windows and OS/2 platforms. The CV2ODBC procedure is described in detail in CV2ODBC Procedure.

This chapter accompanies and should be used with SAS/ACCESS Software for Relational Databases: Reference (order #57204).(footnote 1)

FOOTNOTE 1: Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.

Chapter Contents
Previous
Next
Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.