SAS Technical Papers » Database Products and SAS/ACCESS Software
Papers Topic List |
| Date | Title | File Size |
| March 2008 | SAS In-Database Processing with Teradata: An Overview of Foundation Technology (PDF) This paper outlines how the partnership between SAS and Teradata addresses challenges in data analysis by moving analytic tasks closer to the data and improving the integration between SAS®9 and the enterprise data warehouse (EDW) from Teradata. Performing these tasks inside Teradata will significantly reduce bottlenecks that result from moving data over a network. Customers can also tap the respective strengths of SAS and Teradata technologies. |
685 KB |
| October 2007 | SAS In-Database Processing: A Roadmap for Deeper Technical Integration with
Database Management Systems (PDF) This paper describes a roadmap for enhanced partnership and deeper technical integration with database management systems (DBMS) providers that will allow SAS analytics and data transformation capabilities to be leveraged at the point of transaction rather than the typical extract, transform, and load (ETL) processes in use today. The SAS In-Database technology, which allows SAS code to reside and execute inside a DBMS, streamlines the model management and scoring process from months to hours. |
688 KB |
| 04Apr07 | TS-783: Defining an OLEDB Library in SAS Management Console Using Windows Authentication (PDF) | 1354 KB |
| 27Nov06 | TS-771: Define an Oracle Library in SAS Management Console (PDF) | 1315 KB |
| 29Oct06 | TS-766: Define DB2 library in the SAS Management Console (PDF) | 436 KB |
| 25Oct06 | TS-765: Accessing a SQL Server Database from SAS on Microsoft Windows (PDF) | 238 KB |
| 26Jan06 | Delivering Intelligence for Real-Time Decision Making (PDF) This paper discusses how SAS and SAS Data Integration can be used to integrate with real-time data sources (message queues, Web services, and service-oriented architectures) to deliver the information needed to make decisions that are based on intelligence at the right time |
348 KB |
| 26Jul05 | SAS/ACCESS 9.1.x Interface to DB2 on the Mainframe Using the LIBNAME Engine (PDF) This paper provides an overview of the most important features and capabilities of the SAS/ACCESS Interface to DB2. General and technical product information is given for SAS/ACCESS and DB2 RDBMS users who need fast, seamless access to DB2 tables from the SAS System. The methods for accessing DB2 data are presented, along with examples. |
480 KB |
| 01Jun05 | TS-757: To add an Excel library to SAS Management Console (PDF) | 415 KB |
| 01Jun05 | TS-726: How to Add a SAS/ACCESS Library to SAS Management Console (PDF) | 25 KB |
| 5May05 | IBM DB2 Cube Views and DB2 Materialized Query Tables in a SAS Environment (PDF) This guide gives readers an overview and an understanding of how Materialized Query Tables (MQTs) can benefit SAS users and SAS applications that use DB2 as the underlying database and how to gain a greater benefit by adding DB2 Cube Views to the combination of SAS, MQTs and DB2. It also explores the benefits of using MQTs and DB2 Cube Views in any SAS environment, particularly, in a SAS OLAP environment. |
913 KB |
| 17Nov04 | TS-713: AS/ACCESSInterface to Teradata (PDF) | 606 KB |
| 26May04 | TS-700: Getting Started with SAS/ACCESS Interface to OLE DB (PDF) | 66 KB |
| 26Nov03 | SAS/ACCESS Interface to Teradata (PDF) This paper offers information from general to technical. It provides method documentation, performance evaluations, and optimization tips. It even contains a section for Frequently Asked Questions. If you store data in a Teradata DBMS, this paper is a must-read! |
601 KB |
| 03Mar03 | TS-685: Setting up SAS/ACCESS to ODBC on UNIX Platforms to Interface with ODBC-Compliant Databases (PDF) | 41 KB |
| 08Oct02 | TS-679: Changes and Enhancements in the SAS/ACCESS Interface to SAP BW (PDF) | 197 KB |
| 04Oct01 | TS-661: Using the SAS/ACCESS Libname Technology to Get Improvements in Performance and Optimizations in SAS/SQL Queries (PDF) | 194 KB |
| 17Nov00 | Potential Result Set Differences in SAS vs. Relational Database Management Systems (PDF) SAS/ACCESS software continues to move more processing from SAS to your relational database management system to provide better performance. This paper discusses potential result set differences that can occur with this processing shift to the database management system. |
46 KB |
| 05Nov99 | TS-626: CONFIGURING THE SAS V8/V9 ODBC DRIVERS | 7 KB |
| 25May99 | TS-609: Minimum Requirements for using SAS/ACCESS Software for Relational Databases in the UNIX Environment (PDF) | 54 KB |
| 21Jul04 | TS-589D: IUse PC SAS Software to Read and Write to Lotus WKn Files (PDF) | 16 KB |
| 21Jul04 | TS-589C: Importing Microsoft Access tables to SAS Datasets (PDF) | 18 KB |
| 21Jul04 | TS-589B: Use PC-SAS 8.x and Higher to Read and Write Excel Files (PDF) | 40 KB |
| 21Jul04 | TS-589A: Using PC SAS/ACCESS Software to Read and Write to the DBF File Format (PDF) | 26 KB |
| 02Nov98 | TS-566e:Processing SYBASE Dates with SAS/ACCESS in the UNIX Environment (PDF) | 34 KB |
| 17Nov97 | TS-566d: Processing ORACLE Dates with SAS/ACCESS in the UNIX Environment (PDF) | 26 KB |
| 17Nov97 | TS-566a:Processing DB2/6000 Dates with SAS/ACCESS in the UNIX Environment (PDF) | 23 KB |
| 03Apr97 | TS-538: Getting a grip on a concern: managing large datasets with a mulitdimensional database (PDF) | 38 KB |
| 16Oct97 | TS-518e: SAS/ACCESS Guidelines for Connecting to SYBASE databases in the UNIX Environment(PDF) | 27 KB |
| 16Oct97 | TS-518d: SAS/ACCESS Guidelines for Connecting to ORACLE Databases in the UNIX Environment (PDF) | 34 KB |
| 16Oct97 | TS-518c: SAS/ACCESS Guidelines for Connecting to INGRES Databases in the UNIX Environment (PDF) | 23 KB |
| 16Oct97 | TS-518b: SAS/ACCESS Guidelines for Connecting to INFORMIX Databases in the UNIX Environment (PDF) | 26 KB |
| 07Oct96 | TS-518a: SAS Access issues involved with connecting to DB2/6000 databases using SAS/ACCESS (PDF) | 30 KB |
| 16Oct97 | TS-518: SAS/ACCESS Guidelines for Connecting to Relational Database Systems in the UNIX Environment (PDF) | 81 KB |
| --- | TS-405b: This file will convert dBase files into SAS Datasets for the PC 6.04 SAS System | 3 KB |
| --- | TS-405a: This file will convert dBase files into SAS Datasets for the 6.xx SAS System under Windows | 4 KB |
| 01Nov94 | TS-377: How can I change the current SQL id associated with a DB2 process using SAS/ACCESS Interface to DB2? (PDF) | 10 KB |
| 23Sep94 | TS-359: Query and Reporting from DB2: Installation and Configuration | 5 KB |