SESUG Proceedings 2004

These Proceedings are the official record of the 12th Annual Southeast SAS Users Group (SESUG) Conference held in Nashville, TN on October 31 – November 2, 2004 at the Loews Vanderbilt. Neither SAS Institute Inc. nor SESUG is responsible for the accuracy or originality of this material.

The correct bibliographic citation for this publication is as follows:

SESUG 2004: The Proceedings of the Southeast SAS Users Group, Nashville,TN, 2004

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand and product names are trademarks of their respective companies.

Copyright © 2004 by the Southeast SAS Users Group.

Published in the USA

Papers are made available by the Institute for Advanced Analytics as a courtesy to the SESUG community.

Applications Development

An Introduction to SAS/SHARE, By Example
Larry Altmayer

Software Testing Fundamentals—Concepts, Roles, and Terminology
John E. Bentley

Using SAS at SAS: The Mining of SAS Technical Support
Annette Sanders, Craig DeVault

Creating Meaningful Data from Web Logs Using Base SAS
Jenine Eason, Jerry Johannesen

Journeymen’s Tools: Two Macros — ProgList and PutMvars — to Show Calling Sequence and Parameters of Routines
Ronald Fehd

A Hiker’s Guide to Web Development
Steve James

A Quick and Dirty Query System using HTML, Proc SQL, and SAS IntrNet
Kevin McGowan

Building A SAS Application to Manage SAS Code
Phillip Michaels

Generate a Metadata for Analysis
Maria-Alexandra Paladines

SAS Macros: Tips, Techniques, and Examples
Andrew M. Traldi

Exceptional Exception Reports
Gary McQuown

Coders’ Corner

Tips of Installing SAS/IntrNet on Linux
Xiao (Michelle) Zhuang, Sharon Schiro

Journeymen’s Tools: The Writing for Reading and Reuse Program Header or Everything You Ever Wanted to Know About a Program but Were Afraid to Ask
Ronald Fehd

Merging: Avoid the Cones
Jessica Bonow

Transferring Your Mainframe SAS Programs to Your PC in Three Easy Steps
Michael A. Raithel

Tools to Transfer Data between SAS and Stata
Dan Blanchette

Quick and Easy Visualization of Longitudinal data with the WEBFRAME Graphics device
Kevin P. Delaney

Double Your Pleasure, Double Your Words…
David L. Cassell

Programmatic Handling of Varying Report Requirements
Jim Snider

Data Set Options – What Comes First
Jim Snider

Tip: How to Use a ‘quoted’ SAS Macro Variable to Select Observations
Gary Moore

Faster Flat File Testing
John E. Bentley

Using Acting Techniques to Create a Successful Presentation
Lois Levin

SAS Dating Tips – A Beginner’s Guide to SAS Dates
Erik S. Larsen

%WINDOW: SAS’ Diamond In the Rough
Alan Mann

Data Management

Using Different Methods for Accessing Non-SAS Data to Build and Incrementally Update That Data Warehouse
Ben Cochran

Methods of Storing SAS Data into Oracle Tables
Lois Levin

Using PROC COMPARE in a SAS/AF Application for Tracking Corrections made to SAS Datasets for a Clinical Trial
Emily A. Mixon, Karen B. Fowler

Building Efficient State Transition Diagrams from Charges, Collection and Call Detail Transactional Feeds
Brett C Peppe

Finding Needles in the Documentation Haystack
Susan Myers and David Smarrella

Sounding the Trumpet: Effective Failure Notification
Don Hopkins

Using SAS to Facilitate Data Comparisons
M. Rita Thissen, Elizabeth Heath

A Text Miner Analysis to Compare Internet and Medline Information about Allergy Medications
Chakib Battioui

To MDDB or not to MDDB – That is the question
Jeff Lessenberry

Data Presentation

Quality of Life Analysis for Patients Receiving Heart Implants
David Nfodjo , Christiana Petrou

A SAS Macro for Construction of Symbol Statements
James E. Blum

Using Dynamic Data Exchange to Customize Formatted Reports in Microsoft Excel
Dennis J. Beal

Statistical Analysis of Gene Expression Micro Arrays
John Schwarz

Automated Data Collection Using SAS and FTP
Phil Busby

Building a Web Based EIS for Data Analysis
Ed Confer

ODS, Proc GMAP and SAS/Intrnet: MAP Your Own Response Data
Lakshmi Pandey

Hands-On Workshops

Version 9 Programming Enhancements
Marje Fecht

Introduction to Proc SQL
Steven First

An Introduction to Macros
Deb Cassidy

Creating and Exploiting SAS Indexes
Michael A. Raithel

Version 9 ODS – Basics
Dana Rafiee

Moving Data and Analytical Results between SAS and Microsoft Office
Vincent DelGobbo

Introduction to SAS

The SAS Data Step: Where Your Input Matters
Peter Eberhardt

Why the DATA Step Does What It Does
Neil Howard

A Roadmap to SAS Documentation
Pat Moell, Sean Gargan

What’s That Note/Warning/Error Mean and How Do I Fix It?
Deb Cassidy

How to Incorporate Old SAS Data into a New DATA Step, or “What is S-M-U?”
Andrew T. Kuligowski

(In)Formats (In)Decently Exposed
Harry Droogendyk

When Bad Programs Happen to Good People: Shuffling, Shifting, and Structuring an Inherited SAS Program
Gary E. Schlegelmilch

Here’s the Data, Here’s the Report I Want – How Do I Get There?
Deborah Babcock Buck

The Utter Simplicity and Power of the TABULATE Procedure
Dan Bruns


P01: Doing More with SAS/GRAPH GMAP: A New Look at an Old Procedure
Barbara B. Okerson

P02: Matching SAS Data Sets: If at First You Don’t Succeed, Match, Match Again
Imelda C. Go

P03: Installing SAS/IntrNet on Windows and Linux
Xiao Zhuang, Sharon Schiro

P04: SAS-L: The Basics
F. Joseph Kelley

P05: The Evolution of a SAS/GRAPH Application
Jenine Eason

P06: SAS Programs to Select Controls for Matched Case-Control Studies
Robert Matthews, Ilene Brill


Methods for Minimizing Errors in Address Data
Milorad Stojanovic

Where’s The Match?
Jennifer L. Waller, Verna C. Brantley, Robert H. Podolsky

Array: Construction and Usage of Arrays of Macro Variables
Ronald Fehd

Avoiding Mouse Elbow
Malachy J. Foley

Cutting the SAS LOG Down to Size
Malachy J. Foley

Panel: Launching a Web Application
Mark Tabladillo PhD, Harry Droogendyk, Jenine Eason, Steve James, Crystal Vierhout

Fresh SAS Programming Tunes from Hashville
Paul Dorfman, Alexander A. Martchenko

Stata for the Struggling SAS Mind
Dan Blanchette

Tricks with the 4mat Procedure
Ben Cochran

SAS Add-In for Microsoft Office – Leveraging SAS Throughout the Organization from Microsoft Office
Jennifer Clegg, Stephen McDaniel

The Perks of PRX…
David L. Cassell

SAS Application for Human Health Risk Assessment for Hazardous Waste Combustion Facilities
Samuel E. Stinnette, Dennis J. Beal, Sharon K. Robers, Charles T. Hadden, Barney W. Cornaby

Bring the Data Warehouse to the Office with SAS Integration Technologies
Peter Eberhardt

A Different Approach to Learning SAS Software
Mirjana Stojanovic

Rules for Tools – The SAS Utility Primer
Frank DiIorio

Spatial Statistics Using the SAS Bridge for ESRI
Patricia B. Cerrito, Carol Hanchette, William Dakan, George Barnes, Robert Forbes

Statistics and Data Analysis

Binary Logistic Regression Model Optimization
Jerry Musial

A System to Calculate Market Value-at-Risk using SAS/IML and Oracle
George Rezek

Crossover Designs and Proc Mixed In SAS
Hossein N. Yarandi

Case Studies in Time Series
David A. Dickey

A Simulation Study to Evaluate ANOVA and GEE for Comparing Correlated Proportions with Missing Values
Mark S. Litaker, Daron G. Ferris

Using SAS to Make an Independent Assessment of Electronic Medical Records
Patricia B. Cerrito

Mixed Models Analysis of Microarray Experiments Using Pooled Error Estimates
Yuan Liu, James Blum

Structural Equation Modeling Assessing Micro Array Data
Mussie Tesfamicael

Taking it Home and Putting it into Practice
Diane Cunningham

Mixed Model Influence Diagnostics
Oliver Schabenberger


Eight Characteristics of a Successful Data Warehouse
Marty Brown

A Gentle Introduction to SAS/Graph Software
Ben Cochran

PICTURE Perfect: In depth look at the PICTURE format
Carry W. Croghan

An Overview of Non-parametric Tests in SAS: When, Why, and How
Paul A. Pappas, Venita DePuy

Case Studies in Time Series: Periodic Behavior and Related Issues
David A. Dickey

Dictionary Tables and Views: Essential Tools for Serious Applications
Frank DiIorio, Jeff Abolafia

SAS System Options are Your Friends
Edward Heaton

Losing the Fat: One Application’s Journey to the Internet
Jeff Lessenberry

Speaking Klingon: The Power of PROC TABULATE
Dianne Louise Rhodes

Pretty Dates All in a Row
Dianne Louise Rhodes

Toward Object-Oriented Macros in SAS
Mark Tabladillo

SAS Macro Design Issues
Ian Whitlock

A Second Look at SAS Macro Design Issues
Ian Whitlock