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
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
Posters
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
Serendipity
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
Tutorials
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