Ebook: SAS-ACCESS 9.1.3 for Relational Databases: Reference, 3rd Edition

SAS/ACCESS software interacts with your relational database, giving you the power and flexibility to analyze and present data from other software vendors' database management systems (DBMS). This detailed reference guide explains all the major features of the SAS/ACCESS interface to relational databases, including LIBNAME options, data set options, macro variables and system options, threaded reads, and PROC SQL interactions. Threaded reads, which enable SAS to open multiple connections to the DBMS, are new for SAS 9. The result set is partitioned across the multiple threads, which greatly reduces table read time. This title also contains a large collection of examples, with output, that clearly illustrate how to use various features. This title is also available online. Supplements for various DBMSs are also available and include DB2 under z/OS; DB2 under UNIX and PC Hosts; Informix; Microsoft SQL Server; ODBC; OLE DB; Oracle; SYBASE; and Teradata. This title is intended for applications programmers and users who know how to use their host operating system, but who might not be familiar with SAS, their relational DBMS, or the specific SQL (Structured Query Language) that their DBMS supports.