|Papers Topic List|
|November 2011||TS-808: Defining a Teradata Library with the TERADATA Engine in SAS® Management Console (PDF)
This document describes how you can access a Teradata database from a BI client application by defining a Teradata library in SAS® 9.2 Management Console or later.
|February 2011||Tactics for Pushing SQL to the Relational Databases (PDF)
This paper is a definitive study for using SAS with third-party relational databases such as Oracle, DB2, and Teradata. This paper assumes that you have a powerful relational database and want SAS software to maximally leverage the relational database by performing data-intensive operations in the relational database. This paper also looks at the tradeoffs of performing work primarily by using SAS versus work that is performed primarily by using the relational database.
|July 2010||Troubleshooting SAS and Teradata Query Performance Problems (PDF)
This document explains how to troubleshoot database performance issues using SAS and client tools supplied by Teradata. These tools can help you to determine the root cause of many performance problems, and thereby, enable you to fix these issues yourself.
|July 2010||Effectively Moving SAS Data into Teradata (PDF)
This document discusses the best way to move SAS data into the Teradata server.
|January 2010||TS-802: Defining an ODBC Library in SAS® 9.2 Management Console Using Microsoft Windows NT Authentication (PDF)
This document explains how to define an Open Database Connectivity (ODBC) library in SAS® 9.2 Management Console using Windows authentication to access Microsoft SQL Server data.
|November 2009||Using SAS® Stored Processes inside Teradata (PDF)
This paper describes how a Teradata user can fully leverage the breadth of SAS functionality, including analytics, using only Teradata SQL.
|May 2009||SAS and Teradata: Accelerating the Power to Know (PDF)
This paper covers the model deployment process from start to finish and include performance profiles from a multi-node Teradata server. It also provides a preview of how this technology will be integrated into SAS Model Manager 2.2.
|March 2009||In-Database Procedures with Teradata: How They Work and What They Buy You (PDF)
This paper discusses when the use of SGIO and DIO is appropriate and how to specify and tune the two capabilities. In addition, the paper will present examples of potential system I/O throughput improvement, which can be very significant.
|March 2009||Publish SAS Formats in Your Teradata Server (PDF)
The SAS In-Database Processing initiative, through the SAS and Teradata partnership, has introduced the SAS Formats Library for Teradata. Now SAS formats can be published inside the database, allowing Teradata to do all the work. This paper covers the entire deployment process for SAS formats and custom formats.
|October 2008||SAS In-Database Processing with Teradata: An Overview of Foundation Technology (PDF)
In October 2007, SAS and Teradata Corporation announced a strategic partnership that will enable customers to exploit the best of both companies’ core strengths. This will be accomplished through deeper technical integration of their respective products. This paper discusses five SAS®9 architectural elements using architectural models, functional use cases, and examples based on initial implementation.
|July 2008||TS-793:Using SAS 9.1.3 (and higher) to Read and Write to Microsoft Access Database Files in a Windows Operating Environment (PDF)||83 KB|
|July 2008||TS-792:Using SAS® 9.1.3 (and higher) to Read and Write to Excel 97, 2000, 2002, and 2003 Files in a Windows Operating Environment (PDF)||84 KB|
|March 2008||New SAS Performance Optimizations to Enhance Your SAS Client and Solution Access to the Database (PDF)
This paper presents the major SQL optimizations that have been added to PROC SQL to enhance its performance for SAS 9.2. These optimizations are the result of analyzing SQL queries generated by SAS clients and solutions, and finding new and innovative ways to squeeze out more performance.
|March 2008||What’s New in SAS/ACCESS (PDF)
The group of SAS/ACCESS products contains many enhancements, features and new products. It is beyond the scope of this paper to detail all of the modifications made in the SAS/ACCESS engines for SAS 9.2; however, documentation resources and highlights should help you discover how you can take advantage of the SAS 9.2 SAS/ACCESS enhancements.
|July 2007||SAS In-Database Processing A Roadmap for Deeper Technical Integration with Database Management Systems (PDF)
This paper outlines the technology areas within the SAS Intelligence Platform that are suitable for deep DBMS integration and relates these areas to higher-level process flows like data transformations, data mining, and model scoring implementations.
|April 2007||TS-783: Defining an OLEDB Library in SAS Management Console Using Windows Authentication (PDF)||1354 KB|
|November 2006||TS-771: Define an Oracle Library in SAS Management Console (PDF)||1315 KB|
|October 2006||TS-766: Define DB2 library in the SAS Management Console (PDF)||436 KB|
|October 2006||TS-765: Accessing a SQL Server Database from SAS on Microsoft Windows (PDF)||238 KB|
|October 2006||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
|July 2005||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.
|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.
|17Nov04||TS-713: SAS/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!
|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.
|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-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|