SAS/ACCESS software provides
an interface between SAS and several database management systems (DBMS)
that run under Windows. The interface consists of three procedures
and an interface view engine, which can perform the following tasks:
by assigning the engine
to a specific database engine, the LIBNAME statement lets you reference
a DBMS object directly in a DATA step or SAS procedure, enabling you
to read from and write to a DBMS object a though it were a SAS data
set.
SQL Procedure pass-through facility
accesses data from
several relational DBMSs, including Oracle and SQLServer.
enables you to use
descriptor files in SAS programs to access DBMS data directly and
enables you to specify descriptor files in SAS programs to update,
insert, or delete DBMS data directly.
For more information
about using
SAS/ACCESS software under Windows, consult
SAS/ACCESS Interface to PC Files: Reference and other available
SAS/ACCESS documentation.