Table of Contents All documents are in PDF format.


Copyright Page

SASware Ballot Results

SAS Global Users Group Executive Board

Conference Leaders

SUGI 31 Paper Winners

Future Conferences

 

Paper Sections

Applications Development

Education Focus Session

Posters

BI Forum

Energy and Utilities Focus Session

Retail Focus Sessions

BI Workshop: SAS Business Intelligence Applications

Financial Services/Insurance Focus Session

SAS Presents...

Coders' Corner

Government Focus Session

SAS Presents...BI Architecture Tips and Techniques

Communications Focus Session

Hands-on Workshops

SAS Presents...Solutions

Data Mining and Predictive Modeling

Life Sciences Focus Session

Statistics and Data Analysis

Data Presentation

Manufacturing Focus Session

Systems Architecture

Data Warehousing, Management and Quality

Media, Entertainment and Travel Focus Session

Tutorials

DI Workshop: dfPower Studio and SAS Data Integration Studio

Planning, Development and Support

 

 

Applications Development


Paper 001-2007:

 Churchill, Alan K.

 

How to Generate 10,000 Excel Spreadsheets in 10 Minutes (Or Less)

 

Paper 002-2007:

 Conway, Ted

 

Good Info Comes in Small Multiples – Creating Small Multiple Presentations of Data with SAS® and Excel

 

Paper 003-2007:

 Shvorob, Dimitri

 

I Want It All – Recovering Variable Labels When Importing Data from Microsoft Access

 

Paper 004-2007:

 Compson, Michael L. Hennessey, John C.

 

How Suite It Is – Taking Full Advantage of SAS® Seamless Integration with Microsoft's Office Suite

 

Paper 005-2007:

 Hunt, Stephen Fairfield-Carter, Brian

 

Zipping Right Along: Push-Button SAS® Transfers via Command-Line Invocation of the WinZip32 Executable

 

Paper 006-2007:

 Williams, Tim

 

Better SAS® Programming through Version Control

 

Paper 007-2007:

 DeGuire, Yves

 

The FILENAME Statement Revisited

 

Paper 008-2007:

 Secosky, Jason

 

User-Written DATA Step Functions

 

Paper 009-2007:

 Turner, Jonah P.

 

Spicing Up SAS/IntrNet® Applications (with Additives)

 

Paper 010-2007:

 Li, Houliang

 

Building Your Own Real-Time SAS® Server Monitor under UNIX

 

Paper 011-2007:

 DeVenezia, Richard A. Gerlach, John R. Hoyle, Larry Katz, Talbot M. Langston, Rick

 

SAS® and Sudoku

 

Paper 012-2007:

 Davidson, Gail S. Mills, Guinevere Z.

 

The Enterprise Melting Pot: Everyone’s a SAS User – They Just Don’t Know It

 

Paper 013-2007:

 Collado, Evangeline Borden, M. Paige

 

To Cube or Not to Cube? Is OLAP the Better Choice?

 

Paper 014-2007:

 Yiu-Morrison, Shelly

 

Integration of webAF™ and Table-Driven Methodology

 

Paper 015-2007:

 Treglio, Christopher

 

Extending SAS® Data Integration Studio with Java: Custom GUIs and SAS Server Interactions

 

Paper 016-2007:

 Kramer, Kevin M.

 

SAS® Enterprise Guide® OLE Automation Using C#

 

Paper 017-2007:

 Kobylinski, Richard W.

 

A Dynamic Example of Delivering Patient Management Identification Opportunities Using SAS/IntrNet®

 

Paper 018-2007:

 Sanders, Blake

 

JobTrack: Transaction Computing 101

 

Paper 019-2007:

 Morgan, Derek

 

Managing Stored SCL Lists, and Creating Text Files from SCL Catalog Entries: Two SAS/AF® Utilities

 

Paper 020-2007:

 Thomas, Michael Sherwood, Rick D.

 

Reusable SAS/GRAPH® Stored Processes for Dashboarding

 

Paper 021-2007:

 Zender, Cynthia L.

 

ODS Options and SAS® Stored Processes

 

Paper 022-2007:

 Dhillon, Rupinder Eberhardt, Peter W.

 

%STPBEGIN: How SAS Enterprise Guide® Almost Removed the "L" Word from My Relationship with SAS®

 

Paper 023-2007:

 Weinstein, Heather

 

Converting SAS/IntrNet® Programs to SAS® Stored Processes

 

Top   

BI Forum


Paper 244-2007:

 Smale, John

 

Infrastructure Matters! How the Right IT Infrastructure Adds Value to a SAS® BI/DW Deployment

 

Paper 245-2007:

 Vanderlinden, Mike Varney, Brian

 

Best Practices for Implementing a BI Strategy with SAS®

 

Paper 246-2007:

 Battas, Greg

 

A Single Version of the Truth—How HP Is Advancing Business Intelligence

 

Paper 247-2007:

 Trammell, Steve

 

Leveraging Location for Better Analytics and Reporting

 

Paper 248-2007:

 Black, Alexander J.

 

Business Intelligence—Going Beyond the Numbers

 

Paper 249-2007:

 Zender, Cynthia L.

 

SAS® Stored Process Case Study

 

Paper 250-2007:

 Bills, Cliff Lewis, Warren Lutz, Dharmita Roth, John R.

 

Good Habits for Better Living: What to Expect with Java Application Servers for the SAS® 9.2 Business Intelligence Middle-Tier

 

Paper 251-2007:

 Hatcher, Diane Leslie , Scott

 

Ask Me Anything: New SAS® Prompting Architecture

 

Paper 252-2007:

 Grant, Paul Blomberg, Jodi Mudd, Jeff

 

Using the SAS® Enterprise Intelligence Platform for Logistics Optimization: Linking Data Integration, Analytics, and Business Intelligence

 

Paper 253-2007:

 Thomas, Michael Styll, Rick

 

Building Intelligent Dashboards with SAS® BI

 

Paper 254-2007:

 Styll, Rick

 

Integrated Reporting Using SAS®9 BI Clients

 

Paper 255-2007:

 Hill, Eric Schroedl, John P. Weisz, Jon T.

 

JMP® 7: Statistical Discovery Meets SAS® Business Intelligence

 

Paper 256-2007:

 Zeid, Aiman

 

Business Intelligence Competency Center: What Is It, and How Do You Deploy It?

 

Paper 257-2007:

 Driscoll, Mary

 

Best Practices—Top 5 CFO Challenges

 

Paper 258-2007:

 Spears, Joe

 

SAS® Business and Financial Intelligence, a Powerful Combination

 

Paper 259-2007:

 Choy, Justin Wilkie, Michelle

 

Exploring OLAP Cubes

 

Paper 321-2007:

 Hudson, Florence

 

IBM Mainframe—The Workhorse for Enterprise Business Intelligence

 

Paper 322-2007:

 Wilkie, Michelle Tierney, Janet

 

ROLAP, MOLAP, HOLAP - SAS Can Do It All

 

Top   

BI Workshop: SAS Business Intelligence Applications


Paper 260-2007:

 Rossland, Eric Richardson, Kari

 

Hands-On Workshop: SAS® Business Intelligence Applications

 

Paper 261-2007:

 Rossland, Eric Richardson, Kari

 

Hands-On Workshop: SAS® Business Intelligence Applications

 

Paper 262-2007:

 Rossland, Eric Richardson, Kari

 

Hands-On Workshop: SAS® Business Intelligence Applications

 

Paper 263-2007:

 Rossland, Eric Richardson, Kari

 

Hands-On Workshop: SAS® Business Intelligence Applications

 

Top   

Coders' Corner


Paper 024-2007:

 Gamishev, Teo

 

How to Optimize Existing SAS® Programs Generating Standard Reports

 

Paper 025-2007:

 Carpenter, Art

 

In the Compute Block: Issues Associated with Using and Naming Variables

 

Paper 026-2007:

 Gamishev, Teo

 

Affordable SAS® Tips

 

Paper 027-2007:

 Langston, Rick

 

Handling Large Stream Files with the @'string' Feature

 

Paper 028-2007:

 Fehd, Ronald J.

 

Journeyman's Tools: Data Review Macro FREQALL – Using PROC SQL List Processing with Dictionary.Columns to Eliminate Macro DO Loops

 

Paper 029-2007:

 Su, Pon

 

Calculating Duration via the Lagged Values of Variables

 

Paper 030-2007:

 Pickering, Roger P.

 

Using SAS® Macros to Produce Tables for Publication from SAS-Callable SUDAAN

 

Paper 031-2007:

 Choate, Paul A.

 

Quick Record Lookup without an Index

 

Paper 032-2007:

 Atashili, Julius Ta, Myduc L.

 

A SAS® Macro for Automating the Change-In-Estimate Strategy for Assessing Confounding

 

Paper 033-2007:

 Villacorte, Renato G.

 

Parameter-Gathering Techniques for Data-Driven Programming

 

Paper 034-2007:

 Benjamin Jr, William E.

 

Hurry! Hurry! Step Right Up! The Magical Compound WHERE Clause Can Eliminate DATA Steps, Reduce Processing Steps, Speed Up Turnaround, and Mystify Your Friends

 

Paper 035-2007:

 Worden, Jeanina

 

Hanging On by a STRING? Using Functions to Untie Text Strings

 

Paper 036-2007:

 Kosian, Sassoon

 

A Generic Method of Parallel Processing in Base SAS® 8 and 9

 

Paper 037-2007:

 Humphreys, Suzanne M.

 

Back Up with Each Submit and Save Your Sanity!

 

Paper 038-2007:

 Pope, David

 

Empowering Your SAS® Business Intelligence End Users via a SAS® Stored Process

 

Paper 039-2007:

 Muriel, Elena

 

Hashing Performance Time with Hash Tables

 

Paper 040-2007:

 Bhat, Srinivas G. Fang, Jim Venugopal, Vijay

 

An Approach for a Scalable, Platform-Independent, Automated Solution Using SAS® IOM

 

Paper 041-2007:

 Cheng, Wei

 

Graphical Representation of the Mean Measurement over Time

 

Paper 042-2007:

 Jolley, Linda T. Stroupe, Jane S.

 

Dear Miss SASAnswers: A Guide to SAS® Efficiency

 

Paper 043-2007:

 Leslie, R. Scott

 

Using Arrays to Calculate Medication Utilization

 

Paper 044-2007:

 Liang, Xiaoming

 

Using Dynamic Data Exchange and Table-Driven Programming to Manage Microsoft Excel Files

 

Paper 045-2007:

 Yu, Hsiwei Shen, Dong-Min

 

Group Headers by Template with Optional Columns

 

Paper 046-2007:

 Tilanus, Erik W.

 

Turning the Data Around: PROC TRANSPOSE and Alternative Approaches

 

Paper 047-2007:

 Heaton, Edward

 

Creating a Local Library

 

Paper 048-2007:

 Xia, Henry H.

 

Categorizing Drug Data in a Complex Survey with SAS® PROC FORMAT, INPUT, and PUT Functions

 

Paper 049-2007:

 Pless, Richard F.

 

SAS® Tools for Program Automation

 

Paper 050-2007:

 Murphy, William C.

 

Changing Data Set Variables into Macro Variables

 

Paper 051-2007:

 Crawford, Peter

 

Easy SAS® Session Customization

 

Paper 052-2007:

 Whitlock, Ian

 

Names, Names, Names  Make Me a List

 

Paper 053-2007:

 Hennessey, John C.

 

SAS/CONNECT® to Mainframes and Servers in SAS® Enterprise Guide® 4 Using SAS Code

 

Paper 054-2007:

 Libeg, Linda L.

 

FUNCTIONSIZE: Process Your External Files

 

Paper 055-2007:

 DeMeo, John

 

Creating Microsoft Excel Pivot Tables from SAS® – (Part 2)

 

Paper 056-2007:

 Gianneschi, Dennis

 

Seven Steps to Regulatory Publication Style with PROC REPORT

 

Paper 057-2007:

 Tan, Angelina D. Diehl, Nancy Mandrekar, Jayawant N.

 

Saving Trees with Output Delivery System (ODS)

 

Paper 058-2007:

 Pless, Richard F.

 

Data on Demand with SAS® Enterprise Guide®: A Cheap and Easy Approach to Real-Time Database Access

 

Paper 059-2007:

 Rodriguez Montaño, Flora Zamudio Montaño, Miguel

 

Useful SAS® Macros and Routines

 

Paper 060-2007:

 Kincheloe, Faron

 

Excelling with SAS®

 

Paper 061-2007:

 Barfield, James David Moore, John G. Rayamajhi, Jyoti N.

 

Automatically Incorporating Repeated Changes in SAS® Programming Codes in Clinical Trial Reporting

 

Paper 062-2007:

 Lafler, Kirk P.

 

Simple Rules to Remember When Working with Indexes

 

Paper 063-2007:

 Hurley, George J.

 

Customizing Your SAS® Initialization

 

Paper 064-2007:

 Yeh, Shi-Tao

 

Using Invisible Characters in SAS® Programming – Hidden Dragons, Episode II

 

Paper 065-2007:

 Walkup, Michael P. Craven, Timothy E. Russell, Gregory B.

 

March Sanity – A SAS® Application for Administering an NCAA Tournament Pool

 

Paper 066-2007:

 Groeneveld, Jim

 

SAS® Macro Version Control

 

Paper 067-2007:

 Fehd, Ronald J.

 

DO Which? Loop, UNTIL, or WHILE? A Review of DATA Step and Macro Algorithms

 

Paper 068-2007:

 Wright, Wendi L.

 

Creating a Format from Raw Data or a SAS® Data Set

 

Paper 069-2007:

 Wright, Wendi L.

 

Checking for Duplicates

 

Paper 070-2007:

 Fickbohm, David

 

Using the DATASETS Procedure – Part II

 

Paper 071-2007:

 Lauderdale, Kirsty R.

 

PROC SQL – The Dark Side of SAS®?

 

Paper 072-2007:

 Yellanki, Jyotheeswara N.

 

Calculating Statistics Using PROC MEANS versus PROC SQL

 

Top   

Communications Focus Session


Paper 323-2007:

 Mattison, Rob

 

Keynote Presentation: Breakthrough Business Intelligence: Case Studies in Taking Business Intelligence to Next Level in the Telecommunications Industry

 

Paper 324-2007:

 King, Ken

 

SAS Response: Impacts of New Services on Communication Services Providers

 

Paper 325-2007:

 Christian, Andrew

 

Customer Case Study: A Case Study in Clustering and Behavioral Modeling

 

Paper 326-2007:

 Pinheiro, Carlos A.

 

Customer Case Study: Competitive Intelligence through Business Analytic and Data Mining Environments

 

Top   

Data Mining and Predictive Modeling


Paper 073-2007:

 Wielenga, Doug

 

Identifying and Overcoming Common Data Mining Mistakes

 

Paper 074-2007:

 Bohannon, Tom

 

Predictive Modeling in Higher Education

 

Paper 075-2007:

 Hardin, J. Michael

 

Teaching Business Applications of Data Mining

 

Paper 076-2007:

 Chu, Robert Duling, David Thompson, Wayne

 

Best Practices for Managing Predictive Models in a Production Environment

 

Paper 077-2007:

 Raja, Uzma

 

Predicting Software Maintenance Outcomes Using Data Mining and Text Mining

 

Paper 078-2007:

 Liu, Wensui Cela, Jimmy

 

Improving Credit Scoring by Generalized Additive Model

 

Paper 079-2007:

 Zahedi, Hamed

 

Data Mining Physician Decisions for MRSA

 

Paper 080-2007:

 Zhang, Rodger

 

OLS Regression? Auto-Regression? Dynamic Regression?

 

Paper 081-2007:

 Cherrie, John A.

 

Variable Screening for Multinomial Logistic Regression on Very Large Data Sets as Applied to Direct Response Modeling

 

Paper 082-2007:

 Millette, Ting

 

Find the Best Prospects for a New Product by Using a Data Mining Model

 

Paper 083-2007:

 Tesfamicael, Mussie A.

 

Data Mining to Investigate the Prescribing of Medications Longitudinally

 

Paper 084-2007:

 deVille, Barry

 

Ubiquitous Scoring of 1000+ Warranty Categories Using Predictive Rules Derived from Text

 

Paper 085-2007:

 Cerrito, Patricia B.

 

Text Mining and PROC KDE to Rank Nominal Data

 

Paper 086-2007:

 Albright, Russell D. Bartlett, Jake Bultman, David

 

Making Web Results Relevant with SAS®

 

Paper 087-2007:

 Khopkar, Hrushikesh A. King, Jay

 

Critical Success Factors for Rate Making Using SAS® Enterprise Miner™

 

Top   

Data Presentation


Paper 088-2007:

 Cartier, Jeff Heath, Dan

 

Using ODS Styles with SAS/GRAPH®

 

Paper 089-2007:

 Peterson, Terek J. Gordon, Robert

 

Creating ActiveX Graphs for Presentations Using SAS® Enterprise Guide® and Drill-Down Graphs Too

 

Paper 090-2007:

 Croker, Samuel T.

 

Presentation Quality Forecast Visualization with SAS/GRAPH®

 

Paper 091-2007:

 Martino, Paul Dirmyer, Richard Schley, Sara

 

Graphing Longitudinal Data: Deaf Children in the "Children of the National Longitudinal Survey of Youth"

 

Paper 092-2007:

 Liu, Lea Guo, Nan McCarthy, William F.

 

<