FOCUS AREAS

Technical Papers and Presentations

Our technical papers and presentations provide you with the inside track about our technologies, products, and solutions. In addition to the papers that are provided here, other papers are available from within each community and from the technical papers list.


SAS Presentations at Conferences in 2014
SAS Presentations at Conferences in 2013
SAS Presentations at SAS Global Forum 2012
SAS Presentations at SAS Global Forum 2011
SAS Presentations at Users Group Meetings 2010
SAS Presentations at SAS Global Forum 2010
SAS Presentations at SAS Global Forum 2009
SAS Presentations at Regional Users Groups 2008
SAS Presentations at SAS Global Forum 2008
SAS Presentations at Regional Users Groups 2007
SAS Presentations at SAS Global Forum 2007
Papers from SUGI 31
Papers from SUGI 30
Papers from SUGI 29
Papers from SUGI 28
Papers from SUGI 27

Papers and Presentations Given in 2014

The following papers were presented by a SAS employee at SAS Global Forum or other User Group or conference.

Papers and Presentations Given in 2013

The following papers were presented by a SAS employee at SAS Global Forum or other User Group or conference.

Papers and Presentations Given in 2012

The following papers were presented by a SAS employee at SAS Global Forum or other User Group or conference.

Papers and Presentations Given in 2011

SAS Presentations at SAS Global Forum 2011
The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers were presented at SAS Global Forum as a scheduled paper, during SAS Presents, or on the Demo Floor. View the SAS Global Forum 2011 Proceedings.
  • 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)

Papers and Presentations Given in 2010

SAS Presentations at Users Group Meetings
The following papers and presentations were presented at SAS Users Group Meetings and other conferences throughout the year.
  • 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)
SAS Presentations at SAS Global Forum 2010
The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers were presented at SAS Global Forum as a scheduled paper, during SAS Presents, or on the Demo Floor. View the SAS Global Forum 2010 Proceedings.
  • 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)

  • 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)

  • 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)

  • 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)

Papers and Presentations Given in 2009

SAS Presentations at SAS Global Forum 2009
The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers were presented at SAS Global Forum as a scheduled paper, during SAS Presents, or on the Demo Floor. View the SAS Global Forum 2009 Proceedings.
  • 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)

  • 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)

  • 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 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 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)

Papers and Presentations Given in 2008

SAS Presentations at Regional Users Groups
The following papers and presentations were presented at regional SAS Users Groups and other conferences throughout the year.
  • 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)

SAS Presentations at SAS Global Forum 2008
The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers were presented at SAS Global Forum as a scheduled paper, during SAS Presents, or on the Demo Floor. View the SAS Global Forum 2008 Proceedings.
  • 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)

  • 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)

  • Better Hashing in SAS 9.2
    This paper explores using the duplicate key capability to implement true SQL-like joins as well as partial-key look-ups. In addition, it explores uses for the find frequency counter. Go beyond SAS 9.1 and see why hashing in SAS 9.2 improves how you process data. 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)

  • 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)

  • 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)

  • 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)

  • 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 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)

  • 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)

Papers and Presentations Given in 2007

SAS Presentations at Regional Users Groups
The following papers and presentations were presented at regional SAS Users Groups and other conferences throughout the year.
  • 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)
SAS Presentations at SAS Global Forum
The following papers highlight features and applications of newly developed or enhanced SAS tools and solutions. These papers were presented at SAS Global Forum as a scheduled paper, during SAS Presents, or on the Demo Floor. View the SAS Global Forum 2007 Proceedings online here.
  • 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) Updated May 2014

  • 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)

  • 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 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