Technical Papers and Presentations

• Agile Adoption: Measuring its Worth
  This paper explains how SAS R&D creates award winning software through use of an agile software development methodology known as Agile Scrum. Although used by main-stream industry, SAS’s unique culture gives it a definitive edge that yields higher results. This paper outlines how SAS is applying, measuring, and continuously learning. This paper was presented at the 2013 Stanford Strategic Executive Conference. Read the paper (PDF) | Download the zip file (ZIP)
  
  
• Google-like Maps in SAS®
  We are frequently asked if we can have maps similar to Google Maps in SAS®. Customers want the background map displayed behind their data so they can see where streets or other features are located. They may also want to pan and zoom the map. Now, you can have “Google-like” maps inside of SAS. This paper discusses this new type of mapping in being added in products like SAS® Visual Analytics Explorer and focuses on using this new capability in SAS/GRAPH®. Example code is included. Read the paper (PDF) | Download the zip file (ZIP)
  
  
• PROC GEOCODE: Finding Locations Outside the U.S.
  This paper examines using PROC GEOCODE to convert your address information into map locations. It reviews all of the capability of PROC GEOCODE and also covers the newest capability for handling addresses outside of the United States. This includes world-wide cities, Non-US Postal Codes and Street Level for Canada. Read the paper (PDF) | Download the zip file (ZIP)
  
  
• Tips and Tricks: Using the new SAS Map data sets
  There are issues with the existing MAPS data sets. In order to overcome these issues, we have licensed new Map data sets from GfK GeoMarketing that will eventually replace the MAPS data. This paper examines the new Map data and the changes. Migration examples are discussed. Read the paper (PDF)
  
  
• What's New in SAS® Enterprise Business Intelligence for SAS® 9.3
  SAS® Enterprise BI Server provides a comprehensive suite of BI tools that enables a broad set of business and IT users to produce and consume consistent, fact-based information. The latest revision contains enhancements to both SAS Web Report Studio and SAS BI Dashboard. Key capabilities are discussed and demonstrated by members of the product team. Designing reports and dashboards is now more flexible, and downstream consumers benefit from better performance, improved navigation and interactions, and better integration with Excel and your e-mail client. Plans for future releases are previewed, such as mobile delivery of SAS Web Report Studio reports, and how SAS Enterprise BI Server fits within the overall BI portfolio. Read the paper (PDF)
  
  
• Free Expressions and Other GTL Tips
  This presentation covers some new ways of using DATA step functions for creating grouped plots based on conditions and to select a subset of the observations. It also illustrates usage of PROC FCMP functions in GTL expressions. Novel uses of non-breaking space for creating chunked graphs and graphs with indented text, as well as workarounds for passing Unicode characters in data columns are discussed. Learn how to express yourself with ease, graphically! Read the paper (PDF) | Download the zip file (ZIP)
  
  
• The Ins and Outs of Web-Based Data with SAS®
  Do you have data on the web that you want to integrate with SAS® This paper explains how you can obtain web data, process it, and export it back to the web. Examples use existing features, such as the SOAP and XSL procedures, the SAS® XML Mapper application, and the XMLV2 LIBNAME engine, along with two new features: the XMLV2 LIBNAME engine AUTOMAP= option and the JSON procedure. The AUTOMAP=option allows for creation of default XMLMap files within SAS. The JSON procedure exports SAS data sets in JSON format to an external file. And if you need to write free-form JSON output, forget the SAS PUT statements, the JSON procedure supports free-form JSON output as well. Read the paper (PDF) | Download the zip file (ZIP)
  
  

• An Introduction to Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS®
  This paper explains how to use Base SAS® 9 software to create multi-sheet Excel workbooks (for Excel versions 2002 and later). You learn step-by-step techniques for quickly and easily creating attractive multi-sheet Excel workbooks that contain your SAS output using the ExcelXP ODS tagset and ODS styles. The techniques that are presented in this paper can be used regardless of the platform on which SAS software is installed. You can even use them on a mainframe! Creating and delivering your workbooks on-demand and in real time using SAS server technology is discussed. Although the title is similar to previous papers by this author, this paper contains new and revised material not previously presented. Read the paper (PDF) | Download the zip file (ZIP)
  
  
• Community Discovery: Best Tips and Features from Communities on SAS
  This paper represents a collaborative effort between two different SAS employees with different viewpoints and experiences with the SAS Communities Forum. Reading this paper will make it easier for you to use communities.sas.com to stay informed, share knowledge, grow your professional network, and get help. The paper also answers the question "How do you go about posting a question online?" Read the paper (PDF) | View the presentation (PDF)
  
  
• Off the Beaten Path: Create Unusual Graphs with GTL
  This presentation covers many tricks and tips to create unique graphs that grab the reader?s attention, and also deliver the information effectively. Learn how to stretch the boundaries of what is possible with ODS Graphics. Read the paper (PDF) | Download the zip file (ZIP)
  
  
• Together at Last: Spatial Analysis and SAS® Mapping
  This paper discusses adding mapping to your spatial analytics. Spatial analysis adds intelligence to your maps; maps provide context for your spatial analysis. Examples demonstrate how you can use the SAS/GRAPH Annotate facility with the transparency specification (new in SAS 9.3) to combine a predicted spatial surface with traditional SAS/GRAPH maps. Read the paper (PDF) | Download the zip file (ZIP)
  
  
• Using the SAS® Clinical Standards Toolkit 1.4 for define.xml creation
  When submitting data in the CDISC SDTM format it is required to submit the data definition file in the Case Report Tabulation Data Definition Specification (CRT-DDS, also known as define.xml) format as prepared by the CDISC define.xml team. This workshop will provide an introduction to the structure and content of the define.xml file. The SAS® Clinical Standards Toolkit 1.4 will then be used to create the define.xml file, including Value Level metadata. Read the paper (PDF) | Download the zip file (ZIP)
  
  
• Visualizing Data Techniques, Including Auto-Charting and Big Data for SAS Global Forum 2012
  Visualizing data of varying sizes can be challenging. This paper discusses the issues concerning visualizing data and provides suggestions on how to address these issues. The paper assists users who don't know which visualization to use for their data. Read the paper (PDF)
  
  

• The Greatest Hits: ODS Essentials Every User Should Know
  Just when you think you know every song (feature) in the ODS hit parade, you discover that there’s an option or destination or feature that has you singing its praises because the feature boosted your reports to the next level. This paper covers some of the essential features and options of ODS that every user needs to know to be productive. This paper shows concrete code examples of the ODS "Greatest Hits". Come to this session and learn some of the essential reasons why ODS and Base SAS^® rock! Read the paper (PDF) | Download the zip file (ZIP)
• Introduction to ODS Graphics for the Non-Statistician
  Are you a History, English, or or other Humanities major who’s stumbled into SAS programming? Are you a business analyst or report analyst whose statistical knowledge ends with mean, median, percentiles and standard deviation? Don't know a fitted loess curve from a survival estimate? Need to produce some series plots and bar charts and maybe the occasional box plot? Don't Panic! This presentation is for you! Read the paper (PDF) | Download the zip file (ZIP)
• Don't Gamble with Your Output: How to Use Microsoft Formats with ODS
  Are you frustrated when Excel does not use your SAS® formats for number cells? Do you lose leading zeros on ZIP codes or ID numbers? Does your character variable turn into a number in Excel? Don’t gamble with your output! Learn how to use the HTMLSTYLE and TAGATTR style attributes to send Microsoft formats from SAS to Excel. This paper provides an overview of how you can use the HTMLSTYLE attribute with HTML-based destinations and the TAGATTR attribute with the TAGSETS.EXCELXP destination to send Microsoft formats from SAS to Excel using the Output Delivery System (ODS) STYLE= overrides. Learn how to figure out what Microsoft format to use and how to apply the format appropriately with ODS. A job aid is included in the paper; it lists some of the most common Microsoft formats used for numeric data. The examples in this paper demonstrate PROC PRINT, PROC REPORT, and PROC TABULATE coding techniques. Other job aids are provided that list some of the most common style attributes used in STYLE= overrides and show how to investigate Microsoft formats. Read the paper (PDF) | Download the zip file (ZIP)
• Creating Stylish Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS
  This paper explains how to use Base SAS®9 software to create multi-sheet Excel workbooks (for Excel versions 2002 and later). You learn step-by-step techniques for quickly and easily creating attractive multi-sheet Excel workbooks that contain your SAS output using the ExcelXP ODS tagset and ODS styles. The techniques that are presented in this paper can be used regardless of the platform on which SAS software is installed. You can even use them on a mainframe! Creating and delivering your workbooks on-demand and in real time using SAS server technology is discussed. Although the title is similar to previous papers by this author, this paper contains new and revised material not previously presented. Read the paper (PDF) | Download the Example Program (ZIP)
• Outbreak Maps: Visually Discovering Your Data
  This demonstration shows how to add a spatial component to your data to discover information previously unknown. A number of tips and tricks are presented including dot-density maps, travel routing, non-geographic maps, and supply-chain tracking. Download the presentation (PDF) | Download the examples (ZIP)

• Getting Started with ODS
  Are you new to SAS®9 or just new to ODS? This presentation, given at the Red River Valley User Group meeting, provides an overview of ODS basic processing. It covers the basic "sandwich" technique for invoking ODS and creating an report from procedure results. In addition, it shows the basic types of report output that can be created with ODS and opened with popular applications, such as a web browser (for ODS HTML files), Adobe Acrobat Reader (for ODS PDF files), a word processor, such as Microsoft Word (for ODS RTF files) or Microsoft Excel (for ODS CSV, ODS HTML and ODS TAGSETS.EXCELXP files). As a bonus, the presentation also shows the use of STYLE= override syntax for PROC REPORT, PROC PRINT and PROC TABULATE to customize cells in ODS report output created by these procedures. Download the presentation (ZIP)
  
  
• Under the Hood: How to Use the ExcelXP Tagset
  EXCELXP is an ODS destination that creates Microsoft's spreadsheetML XML files (using TAGSET templates). This destination is specifically used to create an XML file that can be opened in Excel 2002 or later. This presentation provides an overview of the TAGSETS.EXCELXP destination. Then, concrete examples of using the destination will be demonstrated. There is no accompanying paper for this presentation. Download the presentation (ZIP)
  
  
• Do it yourself: Installing and Troubleshooting Your Own SAS 9.2 System
  This presentation provides keys to a successful SAS 9.2 installation. It includes troubleshooting tips and practical advice for avoiding pitfalls during the installation and configuration processes. It also covers an introduction to SAS Enterprise Miner and SAS Management Console. View the presentation (PDF)

• A Practical Approach to Securing a SAS 9.2 Intelligence Platform Deployment
  This document is a practical example of a secure SAS Intelligence Platform deployment, based on actual customer requirements, providing different user groups access to various secured data assets, compute server capabilities, desktop client and Web-based application functionality. This document is intended as a guide for SAS administrators and assumes that you are familiar with the concepts and terminology introduced in SAS 9.2 Intelligence Platform: Security Administration Guide. Read the paper (PDF) | Download the Example Program (ZIP)



• Achieving High-Performance Results on z/OS with SAS 9.2 Business Intelligence
  This paper discusses the black-box testing of a real customer SAS BI application, the methods used to test and measure the applications performance, improvements observed when compared to an earlier version of SAS, methods used to extend the performance, the results we have obtained so far, and directions we are and will be taking to investigate and improve performance in the future. Read the paper (PDF)



• Adding Statistical Functionality to the DATA Step with PROC FCMP
  This paper demonstrates how to add statistical functionality to the DATA step through the definition of FCMP functions. It provides specific examples of how to encapsulate SAS Analytics within FCMP functions and thus make them callable from virtually anywhere in SAS. Read the paper (PDF) | Download the Samples (ZIP)
  
  
• Better Decision Making with SAS Enterprise Business Intelligence and Microsoft
  The SAS Add-In for Microsoft Office has new Microsoft Outlook integration capabilities that enable better decision-making, increase productivity and decrease cost by taking full advantage of SAS Enterprise BI through the Microsoft Outlook environment. Read the paper (PDF)



• Discovering the Road Less Traveled to SAS Information: A Guide for Your Journey
  The goal of this paper and accompanying presentation is to arm you with the tools necessary to locate information when you need it, regardless of where it resides. We intend to open the window into online resources, but also hope that you bring your own suggestions for the question and answer session. Read the paper (PDF) | View the presentation (PDF)



• Fraud Detection with SAS Data Mining
  This paper provides an overview of different data mining techniques that have proven successful in detecting different types of fraud. Using case studies, successful implementations in different industries will be described. Read the paper (PDF)



• Frequently Asked Questions Regarding Storage Configurations
  This paper addresses questions that have been asked of the authors since they presented a similar paper at SAS Global Forum 2007. That paper was titled Best Practices for Configuring your IO Subsystem for SAS®9 Applications. Read the paper (PDF)



• Google Maps and SAS/GRAPH
  This paper introduces a tool for creating Google Maps from within SAS and SAS/GRAPH. The tool and examples are included. Read the paper (PDF) | Download the example SAS programs (ZIP)
  
  
• PROC GEOCODE: Now with Street-Level Geocoding
  This paper examines using PROC GEOCODE to convert your address information into map locations. This now includes Street-Level or Roof Top geocoding. Read the paper (PDF) | Download the example SAS programs (ZIP)
  
  
• Traffic Lighting Your Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS
  This paper provides you with step-by-step instructions for using Base SAS 9.1 or later to create an Excel workbook that contains two worksheets. The worksheets contain fictional lab result data for clinical trials, and data about the ranges used in the traffic lighting. Read the paper (PDF) | Download the example programs (ZIP)
  
  

• Branding SAS Web Applications for Your Enterprise
  This paper discusses the new tools and processes added in SAS 9.2 for creating and maintaining custom themes. Examples from the SAS Enterprise BI Web applications (SAS Web Report Studio and the SAS Information Delivery Portal) will be shown to illustrate some of the possibilities available with the release of SAS 9.2. Read the paper (PDF)

• CSSSTYLE: Stylish Output with ODS and SAS 9.2
  This paper provides an introduction into the use of the new CSSSTYLE option in SAS 9.2. This option allows you to use cascading style sheet (CSS) style specifications for RTF and PDF files, in addition to HTML files. This paper includes a brief introduction to CSS syntax and some of the features, such as @media CSS sections, that are particularly useful when creating ODS output. Read the paper (PDF) | Download the example SAS programs (ZIP)

• Change Data Capture and the Benefits to the Modern Enterprise Data Warehouse
  This paper investigates how the data warehouse has evolved from being a departmental reporting solution to a central repository of information that is key to active decision making for front-line users. Read the paper (PDF)

• Dear Miss SAS Answers: A Guide to Efficient PROC SQL Coding
  This paper answers commonly asked questions and helps you harness the potential of Structured Query Language. Read the paper (PDF)

• Dynamic Prompts Make Data Cascading Easy: Introducing New Features in SAS 9.2 Prompt Framework
  The prompt framework is available across all desktop and Web clients in the platform for SAS Business Analytics. A new feature in SAS 9.2, dynamic cascading prompts, enables users to create custom prompts that easily extract necessary information based on previously entered prompted values. This paper will highlight dynamic prompts and give an overview of new or enhanced features such as cascading prompts, relative date and time prompts, and range prompts. Read the paper (PDF)

• Experimenting Outside the Box: Using SAS/QC for Modern Applications of Experimental Design
  This paper demonstrates specialized features of SAS/QC software that enable you to apply the principles of experimental design beyond traditional applications. Read the paper (PDF)

• Have It Your Way: Rearrange and Replay Your Output with ODS DOCUMENT
  This paper illustrates how to capture your output and save it in an Output Delivery System (ODS) Document store. Then you can create custom folders and a custom folder hierarchy using ODS DOCUMENT and PROC DOCUMENT in order to rearrange and replay your output. Read the paper (PDF) | Download the example SAS programs(ZIP)

• Improving SAS I/O Throughput by Avoiding the Operating System File Cache
  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. Read the paper (PDF)

• In-Database Procedures with Teradata: How They Work and What They Buy You
  In this paper, we review selected enhancements that are being made to SAS procedure statements in Base SAS, SAS/STAT, and SAS Enterprise Miner, and how these procedures affect the distribution of work between SAS and Teradata. A summary of the performance characteristics of these enhanced procedures is also discussed. Read the paper (PDF)

• Mainstreaming Web Data with SAS Web Analytics 5.3
  Valuable customer insight is gained and marketing abilities are enhanced when Web site data is combined with data from other customer contact points, such as call centers, stores, and offline marketing campaigns. Learn how new SAS Web Analytics software leverages SAS 9.2 to maximize Web data. Read the paper (PDF)

• Maximizing the Performance of Your SAS Solution: Case Studies in Web Application Server Tuning for n-tier SAS Applications
  This paper follows a basic flow, which starts with an examination of the methods that are required to make the current single Java Web Application Server more responsive and more robust. It focuses on topics that are relevant for administrators, architects, and implementers of SAS solutions. Read the paper (PDF)

• More Tips and Tricks for Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS
  Transferring SAS data and analytical results between SAS and Microsoft Excel can be difficult, especially when SAS is not installed on a Windows platform. This paper explains how to use the XML support in Base SAS®9 software to create multi-sheet Microsoft Excel workbooks (for Excel versions 2002 and later).Read the paper (PDF) | Download the example SAS programs (ZIP)

• PROC GEOCODE: Creating Map Locations from Your Data
  This paper examines using PROC GEOCODE to convert your address information into map locations. Read the paper (PDF) | Download the example SAS programs (ZIP)

• Publish SAS Formats in Your Teradata Server
  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. Read the paper (PDF)

• SAS and Teradata: Accelerating the Power to Know
  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. Read the paper (PDF)

• SAS IT Intelligence for VMware Infrastructure: Resource Optimization and Cost Recovery
  This paper provides key insights that will allow IT organizations to effectively manage and optimize valuable virtual resources and to track and recover cost across both physical and virtual environments. Read the paper (PDF)

• SAS Stored Processes: Going Beyond the Current Capabilities of the Stored Process Wizard
  This paper discusses the current capabilities and limitations of using the Stored Process Wizard for user input, as well as the improvements and enhancements introduced with SAS Enterprise Guide 4.2. A practical example is included which addresses the topics of cascading menu prompts and dynamically populated menus. Read the paper (PDF) | Download the example SAS programs (ZIP)

• SAS Tile Charts: Thousands of Business Tips with One Click
  This paper outlines the capabilities and business uses of the SAS tile chart. The SAS tile chart looks like the landscape of Kansas when viewed from a window seat on your favorite airline, but its effective use of the color, size, and data tips in a hierarchical grid communicates important business intelligence information. Read the paper (PDF)

• The Platform for SAS Business Analytics as a Centrally Managed Service
  This paper examines some of the advantages and benefits of deploying the platform for SAS Business Analytics in a centrally managed environment. Read the paper (PDF)

• The Power to Show: Ad Hoc Reporting, Custom Invoices, and Form Letters
  This paper demonstrates new features that allow you to build custom data-centric reports in an easy-to-use object-oriented manner that is fully integrated with the ODS System. This technology is perfectly suited for creating custom invoices, inserting narrative descriptions in a table or document, creating form letters and non-rectangular reports, inserting custom subtotals, and it will address a variety of custom reporting needs. Read the paper (PDF)

• The SAS Scalable Performance Data Server - Controlling the Beast!
  This paper discusses how to effectively tune your SAS Scalable Performance Data Server parameters and to configure your I/O subsystem for optimum performance. Read the paper (PDF)

• Test-Driving the Improvements to the INFOMAPS Procedure and LIBNAME Engine
  This paper is written for the customers with the role of utilizing the power of information maps in Base SAS. It will test drive the new features of the procedure and the engine. Common changes to both INFOMAPS products include support on all SAS BI platforms and the use of trusted peer connections. Read the paper (PDF) | Download the example SAS programs (ZIP)

• Tips and Tricks IV: More SAS/GRAPH Map Secrets
  This paper examines secrets that allow you to exploit the power of SAS/GRAPH maps to get the maps you really want. Read the paper (PDF) | Download the example SAS programs (ZIP)

• Tiptoe through the Templates
  This paper provides an overview of all the different template types and how they're used with the Output Delivery System. From style and table templates, that first appeared with SAS 7 to the newest graph templates that appeared with SAS 9.2, this paper provides an overview and several concrete examples for each template type. Read the paper (PDF) | Download the example SAS programs (ZIP)

• Top Ten SAS DBMS Performance Boosters for 2009
  Gleaned from internal development efforts and SAS technical support, this paper tracks the top ten performance options, code snips, and processes to increase your access speed to your data. Focus will be around both DATA step and solution performance enhancements against a variety of database management systems (DBMSs). Read the paper (PDF)

• Using SAS 9.2 Metadata Security Reporting and Auditing Features
  This paper explains the new SAS 9.2 security auditing capabilities built into the SAS Metadata Server and examines how this information might be used. In addition to auditing, security reporting macros are provided. We examine how to use these macros to extract the security settings for metadata objects into data sets that can be used to produce reports. Read the paper (PDF)

• Virtualization: What does it mean for SAS?
  This paper discusses how hardware, presentation, and application virtualization impact running SAS software. It gives some examples of software products used to implement the virtualization solutions, but covers the virtualization topics in a general, product-neutral manner. The focus of the paper is primarily from a Microsoft Windows operating-systems perspective, but the concepts can be applied to other operating systems. Read the paper (PDF)

• z/OS SAS Deployment: This Isn't Your Father's Install Anymore!
  Starting with SAS 9.2, the overall deployment process is now uniform across all host architectures. The purpose of this document is to give you a basic understanding of the new deployment process with an emphasis on deployment to z/OS. Read the paper (PDF)

• Adapting Your Programs to the SAS®9 Paradigm
  Topics in this paper include: basic program conversion to a SAS stored process, conversion of SAS/GRAPH programs, use of macro variables in program conversion, streaming versus transient output from stored processes, and permanent result packages. (Note, a slightly different version of this presentation was given at SAS Global Forum and that version's slides may be in your user group proceedings.) Download the presentation (ZIP) | Download the handout (PDF)
  
  

• Avoid Growing Pains: New Cube Update Features You Should Know About
  You may have heard about the new cube update feature coming in SAS 9.2 but may not be sure of just what it entails. Learn exactly what cube update is and how to get started with it. Read the paper (PDF)

• Backup and Disaster Recovery: When Disaster Strikes, What Will You Do? What Will You Do?
  The purpose of this paper is to assure you that your existing SAS 8 applications will work well in SAS 9 (either SAS 9.1.3 or SAS 9.2) with minimal changes to the application. This paper is a collection of information from the SAS Migration Community Web pages, support documents from the SAS Technical Support Division, and previously published SUGI/SAS Global Forum papers. Read the paper (PDF)

• Best Practices in SAS®9 Security Configurations
  This paper presents several bestpractice configurations for systems that are based on Windows and systems that are based on other operating systems. These configurations maximize the use of single sign-on technology and minimize the necessity to store and pass system credentials. Read the paper (PDF)

• Better Hashing in SAS 9.2
  The DATA step hash object is one of the most versatile new features of Base SAS programming. For SAS 9.2, we introduce the ability to store duplicate keys in a hash object and have added a find frequency counter. In this paper, we leverage the duplicate key capability to implement true SQL-like joins as well as partial-key look-ups. Read the paper (PDF)

• Best Practices for SAS Business Intelligence Administrators: Using the Configuration Troubleshooter to Keep SAS Solutions and SAS BI Applications
  This paper discusses how to use the Configuration Troubleshooter for maintenance and troubleshooting. Using case studies collected from SAS Technical Support, we will step through the process of problem discovery, investigation, and resolution using this tool. Read the paper (PDF)

• Butterflies, Heat Maps, and More: Explore the New Power of SAS/GRAPH
  In SAS 9.2, SAS/GRAPH introduces the statistical graphics (SG) procedures. The SG procedures provide an easy way to produce commonly used analytical graphs. This presentation will demonstrate how to use these new tools to create butterfly plots, heat maps, risk maps, stacked plots, and other unique charts. View presentation handout (PDF)

• Controlling OLAP Applications End to End
  In SAS 9.2, there are several new features that help administrators to secure and control the use of OLAP Cubes in a reporting environment. This paper highlights the new and existing features. Read the paper (PDF)

• Creating Complex Reports
  Are you confused about whether you need a detail report or a summary report? Do you wonder whether you're using the right reporting procedure for your report? Have you ever spent a lot of time going down the road with one procedure only to discover that you need to switch to a different procedure to get what you want or closer to what you want? Read the paper (PDF) | Dowload programs (ZIP)

• Deployment for SAS 9.2 and Beyond
  The paper will summarize advancements such as electronic software download, customized orders, silent installations, streamlined dialog boxes, deployment capture/replay, and SAS Software Depot management. Read the paper (PDF)

• Enhancements to SAS/GRAPH Software in SAS 9.2
  This paper covers the key functionalities that have been added to SAS/GRAPH 9.2. Read the paper (PDF)

• Find Out What You're Missing: Programming with SAS Enterprise Guide
  In this paper, you can read about the productivity gains that you can enjoy when you add SAS Enterprise Guide to your SAS programming toolbox. You will see how to perform old tasks in a new way as well as how to accomplish some tasks that would have been very difficult?if not impossible?without the benefit of an integrated tool like SAS Enterprise Guide. Read the paper (PDF)

• How to Add a Little Spice to Your PDF Output
  Topics in this paper include how to apply new styles, the new SAS/GRAPH interaction, how to scale background images, how to use new fonts and Unicode characters, and much more, including a brief discussion of ODS layout. Read the paper (PDF)

• How SAS®9 Allows the Delivery of the Power of Predictive Analytics and Forecasting to the Masses
  The integrated analytics that SAS offers is the engine that provides the extra power that competitors cannot match in other market spaces such as data integration and business intelligence. Read the paper (PDF) | View the presentation (PDF)

• Improving Your SAS Investment from the Ground Up: SAS 9.2 Enhancements That Help You Leverage Your Operating Environment
  SAS 9.2 has introduced many enhancements that allow you to better leverage your specific operating environment, whether it be Windows, UNIX, OpenVMS, or z/OS. This presentation will focus on these new features, including the areas of I/O optimization, CPU exploitation, memory usage, output display, and new operating environments. Read the paper (PDF)

• Introduction to the Graph Template Language
  In SAS 9.2, the SAS/GRAPH Graph Template Language (GTL) goes production. This system is used by many SAS analytical procedures to create the automatic graphical output within the Output Delivery System (ODS). This presentation helps you understand the basics of GTL, and how you can leverage its features to customize your graphs. Read the paper (PDF)

• Issues with Supply Chain and RFID in the Retail Industry
  Radio Frequency Identification (RFID) provides a major advantage to supply chain management. Implementing supply chain collaboration along with RFID can enable retailers to achieve the best level of business performance. Read the paper (PDF)

• Managing large Data with SAS SPD Server
  This paper provides the concepts behind demonstrations of how you can enhance query performance when you use the SAS SPD Server to manage large data tables. Read the paper (PDF)

• Metadata Promotion in SAS 9.2
  Promotion of metadata content is typically used to support movement across Development, Test, and Production environments. In SAS 9.2, we have implemented a batch interface for the partial promotion framework that will allow you to create a schedulable and repeatable process for moving a set of metadata content across your environments. Read the paper (PDF)

• Migrating Your SAS Applications to SAS 9.1.3 and Beyond
  Migrate your mission-critial SAS 8 applications to SAS®9 so that they can work with the full-featured Business Intelligence, Data Integration, and a multitude of analytical solutions that are part of the SAS 9.1.3 Intelligence Platform. Read the paper (PDF)

• Modernize Your Business Reports Using ODS and SAS/GRAPH: A Case Study from SAS 8.2 to SAS 9.2
  This paper provides an example of business reports using Base SAS and SAS/GRAPH procedures and ODS in the three releases, highlighting improved quality of the reports and increasing ease of use. Read the paper (PDF)

• New SAS Performance Optimizations to Enhance Your SAS Client and Solution Access to the Database
  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. Read the paper (PDF)

• Retention Analytics for Human Capital Management
  Employee retention is an increasingly serious issue in many business sectors. Understanding which factors cause employees to leave and which actions retain them is an important Business Intelligence application. This paper demonstrates analytic methods to address this problem. Read the paper (PDF)

• SAS 9.2 Enhanced Logging Facilities
  SAS administrators and Enterprise IT administrators now have the power and flexibility to classify messages according to a well-defined namespace and dynamically enable diagnostic logging levels. SAS programmers can also exploit the enhanced logging features through the use of SAS 4GL language statements. Read the paper (PDF) | Download the presentation (ZIP)

• Small Improvements Causing Substantial Savings - Forecasting Intermittent Demand Data Using SAS Forecast Server
  This paper exposes the inadequacy of continuous time series methods when compared to IDM for forecasting future average demand per period for intermittent time series. This paper demonstrates a technique and system of large-scale automatic forecasting of intermittent demand series. This paper explains how SAS Forecast Server is used as this system. Read the paper (PDF)

• Tips and Tricks for Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS
  This paper discusses using the XML support in Base SAS 9.1 software to create multi-sheet Microsoft Excel workbooks (versions 2002 and later). You will learn step-by-step techniques for quickly and easily creating attractive multi-sheet Excel workbooks that contain your SAS output. The information presented is new for 2008. Read the paper (PDF) | Download the example SAS programs (ZIP)

• Tune into the Voice of Your Customer with Voice Mining
  Understanding customer needs, is a critical step in developing a successful product. But how do you give your customers a seat at the development table? By actually hearing and understanding what they're already telling you, and by letting your customers' voices reverberate through your strategies for channels, sales, service, pricing, and product! Start now by mining your customer feedback in a consistent, repeatable, automated way. Take action: increase satisfaction, build loyalty, reduce churn, and make your products safer. Read the paper (PDF)

• Two-Stage Variable Clustering for Large Data Sets
  In data mining, principal component analysis is a popular dimension reduction technique. It also provides a good remedy for the multicollinearity problem, but its interpretation of input space is not as good. To overcome the interpretation problem, principal components (cluster components) are obtained through variable clustering, which was implemented with PROC VARCLUS. Read the paper (PDF)

• Using Copulas to Model Dependency Structures in Econometrics
  This paper introduces advanced copula modeling capabilities in the MODEL procedure. We also show how insight into the correlation structure of the copulas can be obtained by using animations produced by SAS. Read the paper (PDF)

• Using SAS BI Web Services and PROC SOAP in a Service-Oriented Architecture
  The primary objective of a service-oriented architecture is to increase the agility of a business. Some features of a service-oriented architecture can be supported through technology; other features are supported through policies. SAS 9.2 introduces the second generation of Web services software from SAS, and it represents a major step forward in the enterprise service-oriented maturity model where many categories of the ESOMM have been improved. Read the paper (PDF)

• What?s New in SAS/ACCESS
  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. Read the paper (PDF)

• What?s New in SAS OLAP Cube Studio 4.2
  This paper will highlight and demonstrate the new functionality and the benefits that the user will have with SAS OLAP Cube Studio 4.2. Read the paper (PDF)

• What?s New in SAS Web Report Studio 4.2
  The latest revision of SAS Web Report Studio, the zero download query, analysis and reporting tool included with the SAS Enterprise BI Server, is full of enhancements based on feedback from customers like you. You will love the new desktop like experience on the Web. Read the paper (PDF)

• What?s New in the 4.2 releases of SAS Enterprise Guide and the SAS Add-In for Microsoft Office
  This paper introduces some of the highlights, including a revamped user interface (UI) in SAS Enterprise Guide, the ability to open SAS Reports from the SAS Add-In, a new PROC REPORT-based wizard, and much more. Read the paper (PDF)

• Zero-Inflated Poisson and Zero-Inflated Negative Binomial Models Using the COUNTREG Procedure
  This paper studies the performance of different count models on a simulated example. The results demonstrate that among the count models we consider, in many cases a Poisson model tends to be overly restrictive. Read the paper (PDF)

• Adapting Your Programs to the SAS®9 Paradigm
  Topics in this paper include: basic program conversion to a SAS stored process, conversion of SAS/GRAPH programs, use of macro variables in program conversion, streaming versus transient output from stored processes, and permanent result packages. (Note, a slightly different version of this presentation was given at SAS Global Forum and that version's slides may be in your user group proceedings.) Download the presentation and the example SAS programs (ZIP)
  
  
• Understanding Why Your Macros Don't Work
  This brain-teasing seminar discusses the behind the scenes workings of the macro facility and explain why macro variables you thought would resolve don't, why you need an extra period or four after a macro variable reference, why you care about the difference between %LET and CALL SYMPUT, and what all those extra ampersands are for. Read the Slides (PDF) | Download the presentation and the example SAS programs (ZIP)

• Adventures in Arrays: A Beginning Tutorial
  This paper presents examples to explain what arrays are and how to use them. In addition to simple examples demonstrating arrays used to perform calculations, restructure data and look up values, the paper includes examples using multidimensional arrays for efficient table lookups. Read the paper (PDF)
  
  
• Best Practices for Configuring your IO Subsystem for SAS^®9 Applications
  This paper presents best practices for configuring the IO subsystem for your SAS 9 applications, ensuring adequate capacity, bandwidth, and performance to keep your SAS 9 users moving. Read the paper (PDF)
  
  
• Beyond the Basics: Advanced PROC REPORT Tips and Tricks
  This paper is a compilation of tips and tricks for producing PROC REPORT output. The three sections cover topics that: can be used with listing output and with the Output Delivery System (ODS), can only be used with an ODS destination; highlight new features and changes for PROC REPORT in SAS 9.2. Read the paper (PDF)
  
  
• Case Study in Synchronizing Identities in the SAS^®9 Metadata Server with an Enterprise Security Provider
  This case study highlights the advantage of importing user and group information from an enterprise security provider, such as the Microsoft Active Directory. SAS provides macros that can be integrated with scheduling and other tools to synchronize SAS metadata repository identities with the enterprise Lightweight Directory Access Protocol (LDAP) environment. Read the paper (PDF)
  
  
• Creating Multi-Sheet Excel Workbooks the Easy Way with SAS
  This paper discusses using the new XML support in Base SAS 9.1 software to create multi-sheet Microsoft Excel workbooks (versions 2002 and later). You will learn step-by-step techniques for quickly and easily creating attractive multi-sheet Excel workbooks that contain your SAS output. Read the paper (PDF) | Download the example SAS programs (ZIP)
  
  
• Exporting SAS/GRAPH Output for Inclusion in Web Pages and Other Software Applications
  This paper covers the basic process for creating image files directly through a SAS/GRAPH program in SAS 9.1.3. Image types addressed in this paper include EMF, CGM, EPS, GIF, PNG, ActiveX, and PostScript. This paper also illustrates how those image files can be inserted into other software applications and Web pages. Read the paper (PDF)
  
  
• Making Business Decisions Using SAS Mapping Technologies
  This paper gives an overview of SAS Mapping Technologies and SAS 9.2 enhancements and then presents two examples that use SAS Mapping Technologies to make business decisions. Read the paper (PDF)
  
  
• SAS/AF: Running SCL Outside the Frame
  SCL is a powerful programming language that has been part of SAS for many years. This paper serves as an introduction and covers stored processes and the steps necessary to run your SCL programs as a stored process. Read the paper (PDF)
  
  
• ODS and Office Integration
  With so many ODS destinations available, it is increasingly important to know how the different file-formats integrate with external applications. Find out how easily you can create output in a multitude of file types, from the infinitely customizable XML to SpreasheetML, RTF, PDF, and LaTeX; even comma-separated values (CSV) get some attention in this paper. Read the paper (PDF) | Download the example code (TGZ)
  
  
• ODS Markup, Tagsets, and Styles! Taming ODS Styles and Tagsets
  Find out how ODS styles can be used in new ways when they are combined with tagsets. Watch as a simple example grows into new ideas on how to use styles and tagsets. See how easy it is to create a new destination and style that do just what you need. Read the paper (PDF) | Download the example code (TGZ)
  
  
• ODS from Scratch
  Using ODS, you can generate reports in formats such as HTML, XML, PDF, PostScript, RTF, and Microsoft Excel. This paper shows you how to generate reports with ODS, from scratch. You'll learn how to generate multiple output formats, simultaneously; how to change the look of your report using styles; how to add text passages; and other helpful information. Read the paper (PDF) | Get the tip sheet (PDF)
  
  
• PROC TEMPLATE Tables from Scratch
  In this paper, you learn how to create and modify table templates, including how to add, remove, and move columns as well as headers and footers. You also learn how to apply styles, formats, and other visual effects, all from scratch. Read the paper (PDF) | Get the tip sheet (PDF)
  
  

For older papers, see the following

• Papers from SUGI 31
• Papers from SUGI 30
• Papers from SUGI 29
• Papers from SUGI 28
• Papers from SUGI 27