Archive of Technical Papers and Presentations

Our technical papers and presentations provide you with the inside track about our technologies, products, and solutions. The papers on this page are two years old or older, but you may find them helpful, so we continue to make them available. Be sure to check the current papers list for additional papers.

Papers and Presentations Given in 2006

SAS Presentations at SUGI 31
The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers were given at SUGI 31 as a scheduled paper, during SAS Presents, or on the Demo Floor. View the online SUGI 31 Proceedings. *Creating AND* Importing Multi-Sheet Excel Workbooks the Easy Way with SAS This paper discusses using new XML support in Base SAS 9.1 software to move data between SAS and Microsoft Excel (version 2002 or later). You will learn techniques for creating multi-sheet Excel workbooks containing your SAS output. Read the paper (PDF) \| Download the example SAS programs (ZIP) Delivering Intelligence for Real-Time Decision Making 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. Read the paper (PDF) SAS^®9 OLAP Cube Update — New Functionality in SAS 9.2 Provides an overview of new features for updating cubes. These new features will be available in our OLAP Server software in 9.2. View the presentation (PDF) SAS/AF: Building a Tree View Hierarchy with Drag and Drop Drag-and-drop is a powerful tool in SAS/AF software. In combination with the Tree View Control, these tools enable you to build exciting SAS/AF applications such as the one presented in this paper. Read the paper (PDF) \| Download the example SAS programs (ZIP) SAS Scalable Performance Data Server 4.3 TSM1: Parallel Join with Enhanced GROUP BY Processing This paper discusses the coverage, restrictions, tuning, and performance benefits of the Parallel Join Facility and the enhanced GROUP BY method in the SAS SPD Server 4.3 TSM1 release. Read the paper (PDF) SAS Scalable Performance Data Server 4.3: Scalability Solution for SAS Dynamic Cluster Tables This paper provides an overview of the dynamic cluster tables feature of SAS Scalable Performance Data Server 4.3. Dynamic cluster tables enable both the partitioning of data based on criteria in the data and parallel loading of the cluster tables. Read the paper (PDF) Securing Your SAS^®9 Deployment The goal of this presentation is to explain some of the ways you can reduce security exposures in SAS^®9. It includes a list of general guidelines and improvements that cover many areas of SAS deployment. View the presentation (PDF) The Practical Union of OLAP Analysis and Geographic Mapping This paper introduces some well-documented benefits of OLAP exploitation and suggests how these benefits can be extended to include geographic display and navigation. Also provided is an overview of methodology and implementation details for linking levels of an OLAP hierarchy with layers in a geographic map. Read the paper (PDF) \| Download the presentations (ZIP) Teaching Your RTF Tagset to Do Clever Tricks** This paper presents a simple comparison between the default RTF Tagset and an additional experimental sample RTF Tagset. The sample, which is provided by SAS, shows how to customize a tagset. Read the paper (PDF) \| Download the examples (ZIP)

SAS Presentations at SUGI 31

The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers were given at SUGI 31 as a scheduled paper, during SAS Presents, or on the Demo Floor. View the online SUGI 31 Proceedings.

Creating AND Importing Multi-Sheet Excel Workbooks the Easy Way with SAS
This paper discusses using new XML support in Base SAS 9.1 software to move data between SAS and Microsoft Excel (version 2002 or later). You will learn techniques for creating multi-sheet Excel workbooks containing your SAS output. Read the paper (PDF) | Download the example SAS programs (ZIP)
Delivering Intelligence for Real-Time Decision Making
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. Read the paper (PDF)
SAS^®9 OLAP Cube Update — New Functionality in SAS 9.2
Provides an overview of new features for updating cubes. These new features will be available in our OLAP Server software in 9.2. View the presentation (PDF)
SAS/AF: Building a Tree View Hierarchy with Drag and Drop
Drag-and-drop is a powerful tool in SAS/AF software. In combination with the Tree View Control, these tools enable you to build exciting SAS/AF applications such as the one presented in this paper. Read the paper (PDF) | Download the example SAS programs (ZIP)
SAS Scalable Performance Data Server 4.3 TSM1: Parallel Join with Enhanced GROUP BY Processing
This paper discusses the coverage, restrictions, tuning, and performance benefits of the Parallel Join Facility and the enhanced GROUP BY method in the SAS SPD Server 4.3 TSM1 release. Read the paper (PDF)
SAS Scalable Performance Data Server 4.3: Scalability Solution for SAS Dynamic Cluster Tables
This paper provides an overview of the dynamic cluster tables feature of SAS Scalable Performance Data Server 4.3. Dynamic cluster tables enable both the partitioning of data based on criteria in the data and parallel loading of the cluster tables. Read the paper (PDF)
Securing Your SAS^®9 Deployment
The goal of this presentation is to explain some of the ways you can reduce security exposures in SAS^®9. It includes a list of general guidelines and improvements that cover many areas of SAS deployment. View the presentation (PDF)
The Practical Union of OLAP Analysis and Geographic Mapping
This paper introduces some well-documented benefits of OLAP exploitation and suggests how these benefits can be extended to include geographic display and navigation. Also provided is an overview of methodology and implementation details for linking levels of an OLAP hierarchy with layers in a geographic map. Read the paper (PDF) | Download the presentations (ZIP)
Teaching Your RTF Tagset to Do Clever Tricks
This paper presents a simple comparison between the default RTF Tagset and an additional experimental sample RTF Tagset. The sample, which is provided by SAS, shows how to customize a tagset. Read the paper (PDF) | Download the examples (ZIP)

Papers and Presentations Given in 2005

SAS Presentations at SUGI 30
The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers were given at SUGI 30 as a scheduled paper, during SAS Presents, or on the Demo Floor. View the online SUGI 30 Proceedings. Loading Cube Data at Non-Leaf Levels This paper discusses advanced cube-loading techniques. It is assumed that the reader is familiar with creating SAS^®9 OLAP Cubes and preparing data for loading into SAS^®9 OLAP Cubes. Knowledge of the MDX query language is helpful for understanding the notation of dimension, hierarchy, level, and member names. Read the paper (PDF) Moving Data and Analytical Results between SAS and Microsoft Office This paper discusses using the HTML and XML support in Base SAS software to move data between SAS and Microsoft Office (versions 2002 and later). You can use the techniques described here regardless of the platform on which SAS software is installed (including a mainframe). Read the paper (PDF) \| Download the source code (ZIP) Performance Test Suite Results for SAS 9.1 Foundation on the IBM zSeries Mainframe This paper presents the performance results that were obtained from two, complementary, batch test suites that were run using SAS 8.2 and SAS 9.1. SAS uses batch test suites to monitor the performance of commonly used features of SAS Foundation software during the development cycle and between releases. Read the paper (PDF) Pipeline Parallelism Performance Practicalities The purpose of pipeline parallelism is to increase your speed of your program and decrease your I/O operations. This paper will take you behind the scenes to show you what's going on and focus on what NOT to do that could actually cause your program to behave improperly. Read the paper (PDF) The Power of the Graphics Template Language This paper explains how to create graphs with the Graphics Template Language and the DATA step. Read the paper (PDF) Tips and Tricks III: More Unique SAS/GRAPH Maps This presentation examines additional techniques for creating effective and unique SAS/GRAPH maps. Read the paper (PDF) \| Download the example SAS programs (ZIP) Tips and Tricks: Using SAS/GRAPH Effectively This paper examines the powerful components of SAS/GRAPH and highlights techniques for harnessing that power to create effective and attention-grabbing graphs. Read the paper (PDF) \| Download the example SAS programs (ZIP) Use of Styles in Graphics This paper explains how ODS styles affect SAS/Graph and ODS Statistical Graphics output. Read the paper (PDF)

SAS Presentations at SUGI 30

The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers were given at SUGI 30 as a scheduled paper, during SAS Presents, or on the Demo Floor. View the online SUGI 30 Proceedings.

Loading Cube Data at Non-Leaf Levels
This paper discusses advanced cube-loading techniques. It is assumed that the reader is familiar with creating SAS^®9 OLAP Cubes and preparing data for loading into SAS^®9 OLAP Cubes. Knowledge of the MDX query language is helpful for understanding the notation of dimension, hierarchy, level, and member names. Read the paper (PDF)
Moving Data and Analytical Results between SAS and Microsoft Office
This paper discusses using the HTML and XML support in Base SAS software to move data between SAS and Microsoft Office (versions 2002 and later). You can use the techniques described here regardless of the platform on which SAS software is installed (including a mainframe). Read the paper (PDF) | Download the source code (ZIP)
Performance Test Suite Results for SAS 9.1 Foundation on the IBM zSeries Mainframe
This paper presents the performance results that were obtained from two, complementary, batch test suites that were run using SAS 8.2 and SAS 9.1. SAS uses batch test suites to monitor the performance of commonly used features of SAS Foundation software during the development cycle and between releases. Read the paper (PDF)
Pipeline Parallelism Performance Practicalities
The purpose of pipeline parallelism is to increase your speed of your program and decrease your I/O operations. This paper will take you behind the scenes to show you what's going on and focus on what NOT to do that could actually cause your program to behave improperly. Read the paper (PDF)
The Power of the Graphics Template Language
This paper explains how to create graphs with the Graphics Template Language and the DATA step. Read the paper (PDF)
Tips and Tricks III: More Unique SAS/GRAPH Maps
This presentation examines additional techniques for creating effective and unique SAS/GRAPH maps. Read the paper (PDF) | Download the example SAS programs (ZIP)
Tips and Tricks: Using SAS/GRAPH Effectively
This paper examines the powerful components of SAS/GRAPH and highlights techniques for harnessing that power to create effective and attention-grabbing graphs. Read the paper (PDF) | Download the example SAS programs (ZIP)
Use of Styles in Graphics
This paper explains how ODS styles affect SAS/Graph and ODS Statistical Graphics output. Read the paper (PDF)

Papers and Presentations Given in 2004

SAS Presents... at SUGI 29
The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers supplement the SAS Presents... presentations given at SUGI 29. View the online SUGI 29 Proceedings for more papers from SUGI 29. From SAS to Excel via XML Transferring data between SAS and Microsoft Excel can be difficult, especially when SAS is not installed on a Windows platform. This paper discusses using new XML support in BASE SAS 9.1 software to move data between SAS and Microsoft Excel (versions 2002 and later). You can use the techniques described here regardless of the platform on which SAS software is installed, such as Windows, OpenVMS, UNIX or z/OS. Read the paper (PDF) \| Download the source code (ZIP) \| (updated: May 2005) ODS Graphics Template Language This presentation shows how the experimental ODS Graphics Template Language (GTL) can be used on the TEMPLATE procedure to define custom graphs. Also, it shows how ODS GTL syntax can be used to create custom layouts and overlays. View the presentation. Skinning the Cat This Way and That: Using ODS to Create Word Documents that Work for You In the course of creating a customized RTF file from SAS procedural output, the authors of a SUGI 29 paper discovered a number of useful ODS tricks. These tricks are now available to you in this SUGI presentation. Get the details. Tips and Tricks II: Getting the most from your SAS/GRAPH maps This presentation highlights some techniques for creating effective and unique SAS/GRAPH maps. Read the paper (PDF) \| Download the example SAS programs (ZIP)

SAS Presents... at SUGI 29

The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers supplement the SAS Presents... presentations given at SUGI 29. View the online SUGI 29 Proceedings for more papers from SUGI 29.

From SAS to Excel via XML
Transferring data between SAS and Microsoft Excel can be difficult, especially when SAS is not installed on a Windows platform. This paper discusses using new XML support in BASE SAS 9.1 software to move data between SAS and Microsoft Excel (versions 2002 and later). You can use the techniques described here regardless of the platform on which SAS software is installed, such as Windows, OpenVMS, UNIX or z/OS. Read the paper (PDF) | Download the source code (ZIP) | (updated: May 2005)
ODS Graphics Template Language
This presentation shows how the experimental ODS Graphics Template Language (GTL) can be used on the TEMPLATE procedure to define custom graphs. Also, it shows how ODS GTL syntax can be used to create custom layouts and overlays. View the presentation.
Skinning the Cat This Way and That: Using ODS to Create Word Documents that Work for You
In the course of creating a customized RTF file from SAS procedural output, the authors of a SUGI 29 paper discovered a number of useful ODS tricks. These tricks are now available to you in this SUGI presentation. Get the details.
Tips and Tricks II: Getting the most from your SAS/GRAPH maps
This presentation highlights some techniques for creating effective and unique SAS/GRAPH maps. Read the paper (PDF) | Download the example SAS programs (ZIP)

Papers and Presentations Given in 2003

SAS Presents... at SUGI 28
The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers supplement the SAS Presents... presentations given at SUGI 28. View the online SUGI 28 Proceedings for more papers from SUGI. Developing Data-Driven Applications Using JDBC and Java Servlet/JSP Technologies Read about the enhancements that have been made to the SAS Java component library available with Version 3 of AppDev Studio. Read the paper (PDF) SAS Mapping: Technologies, Techniques, Tips and Tricks updated January 2005 This paper provides you with the resources to help you choose the right technology and tool to effectively transform data into useful information. Read the paper (PDF) \| Download the source code (ZIP)

SAS Presents... at SUGI 28

The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers supplement the SAS Presents... presentations given at SUGI 28. View the online SUGI 28 Proceedings for more papers from SUGI.

Developing Data-Driven Applications Using JDBC and Java Servlet/JSP Technologies
Read about the enhancements that have been made to the SAS Java component library available with Version 3 of AppDev Studio. Read the paper (PDF)
SAS Mapping: Technologies, Techniques, Tips and Tricks updated January 2005
This paper provides you with the resources to help you choose the right technology and tool to effectively transform data into useful information. Read the paper (PDF) | Download the source code (ZIP)

Papers and Presentations Given in 2002

SAS Presents... at SUGI 27
The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers supplement the SAS Presents... presentations given at SUGI 27. View the online SUGI 27 Proceedings for more papers from SUGI. Large-Scale Automatic Forecasting: Millions of Forecasts SAS High-Performance Forecasting performs large-scale automatic forecasting without the need for human intervention. Built for speed and efficiency, High-Performance Forecasting can produce millions of forecasts very quickly using either time series or transactional data. Read the paper (PDF) A Practical Approach to Solving Performance Problems with the SAS System This paper will suggest a stepwise method to diagnose, correct, and prevent performance problems involving the SAS system. Read the paper (PDF) SAS/OR Network Visualization Workshop The SAS/OR Network Visualization Workshop is an interactive, graphics-oriented tool for investigating network or graph data. Read the paper (PDF) Scalable Access to SAS Data Symmetric multiprocessor (SMP) computers can increase performance by reducing the time required to analyze large volumes of data. Using a new engine in Version 9, large SAS data sets can be partitioned and an I/O stream can be initiated for each processor. Read the paper (PDF)

SAS Presents... at SUGI 27

The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers supplement the SAS Presents... presentations given at SUGI 27. View the online SUGI 27 Proceedings for more papers from SUGI.

Large-Scale Automatic Forecasting: Millions of Forecasts
SAS High-Performance Forecasting performs large-scale automatic forecasting without the need for human intervention. Built for speed and efficiency, High-Performance Forecasting can produce millions of forecasts very quickly using either time series or transactional data. Read the paper (PDF)
A Practical Approach to Solving Performance Problems with the SAS System
This paper will suggest a stepwise method to diagnose, correct, and prevent performance problems involving the SAS system. Read the paper (PDF)
SAS/OR Network Visualization Workshop
The SAS/OR Network Visualization Workshop is an interactive, graphics-oriented tool for investigating network or graph data. Read the paper (PDF)
Scalable Access to SAS Data
Symmetric multiprocessor (SMP) computers can increase performance by reducing the time required to analyze large volumes of data. Using a new engine in Version 9, large SAS data sets can be partitioned and an I/O stream can be initiated for each processor. Read the paper (PDF)

FOCUS AREAS