SESUG Proceedings 2003
These Proceedings are the official record of the 11th Annual SouthEast SAS Users Group (SESUG) Conference held in St. Pete Beach, FL on September 22-24, 2003 at the TradeWinds Island Grand Resort. 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 2003: The Proceedings of the SouthEast SAS Users Group, St Pete Beach, FL, 2003
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 © 2003 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
Building Drill-down SAS Applications
Kirk Lafler, Charles Edwin Shipp
SAS System on Network Appliance
Darrell Suggs
The Revised NTP TDMS System
Gabriel Cano, Kevin McGowan, Jean Orelien
Developing and Deploying Java Applications Around SAS: What they didn’t tell you in class
Greg Barnes Nelson, Jeff Wright
The Dataset Attribute Family of Classes
Mark Tabladillo
A Hiker’s Guide to Web Development
Steve James
Bulletproofing and Knowledge Encapsulation in Statistical Macros
John K. Troxell
A Hybrid Modeling Platform to meet Basel II Analytics in Banking
Jeffery Morrision
Information System for State Trauma Advisory Committee – An application of SAS/IntrNet
Xiao Zhuang, Sharon Schiro
A Pinch of SAS, a Fraction of HTML, and a Touch of JavaScript Serve Up a Grand Recipe
Jonah P. Turner
SAS Macros are the Cure for Quality Control Pains
Gary McQuown
A Beginners Guide to Incorporating SAS Output into MS Office
Vincent Del Gobbo
ODS for Microsoft Excel
David Shamlin
Programming for Failure: When Programs Faw Down and Go Boom
Gary E. Schlegelmilch
Coders’ Corner
Musical Macros: A Soothing Solution for a Recurrent Data Step Headache
Phil D’Almada
Libname Start Your Engines
Janet E. Stuelpner
Spreading the News: Using System Options
Deb Cassidy
The Evolution of a Macro: Converting your SAS files to a Different Version
John C. Gober, Jana L. Smith, Debi Mullen
Create a Simple, Informative Summary from Proc T-Test Output
Jennifer Warner
How to Get What You Need, Part 1
Chris Toppe
How to Get What You Need, Part 2
Chris Toppe
Processing Large Lists of Variables and Parameters Using SAS Arrays and Macro Language
Eugene Tsykalov
Using the SAS system in Very Limited Time/Resource Environment
Milorad Stojanovich
Machine Reading of Warranty Claims for Classification
Robert McCurdy
SAS Dating Tips – A Beginner’s Guide to SAS Dates
Erik S. Larsen
Advantages of PROC SCORE
Mark Tabladillo
Using SAS Macro Language to Develop User-Written Functions
Deb Pine
A “Real” Drill-Down Graph
Jenine Eason
Data Management
New Technologies for Delivering Data to Internal and External Clients
Sigurd W. Hermansen
Data-driven Validation Rules: Custom Data Validation without Custom Programming
Don Hopkins
A Technique for Storing and Manipulating Incomplete Dates in a Single SAS Date Value
John Ingersoll
Checking Datasets before Submitting Code
Mark Tabladillo
Automated Testing and Real-time Event Management: An Enterprise Notification System
Greg Barnes Nelson, Danny Grasse
Demand for Analysis-Ready Data Sets: An Introduction to Banking and Credit Card Analytics
Bikila bi Gwet
PROC SQL: Why Use It When Simple IF THEN Statements Work?
Susan Myers, Inga Allred
Using DDE and SAS/Macro for Automated Excel Report Consolidation and Generation
Sandra Archer, Mengxi Li, Russell Denslow
Data Presentation
Special Education Practice and Policy: What Principals Know and Need to Know
Wendy Dickinson, Tanice Knopp, Janice Fauske
Pivoting Data. An Alternative to ACROSS Variables of the REPORT Procedure
Mr. Bikila (Kila) bi Gwet
Credit Card Portfolio Performance Assessment. A Case of Business Intelligence
Mr. Bikila (Kila) bi Gwet
SAS/Intrnet and Census Mapping: How Low Would You Like to Get?
Lakshmi Pandey, William Joseph Smith, David Sjoquist
Using SAS and Other Tools to Move an Institutional Research (IR) Office from Hardcopy Reporting to a Web-Based Environment
Sabrina L. Andrews, Evangeline Collado, Patricia Ramsey
Bookmarks, Links, and It Looks Great Printed Too, Come In and See What ODS PDF Can Do For You!
Kevin Delaney
Tedious Template Made Easy
Cindy Stroupe
Building a Web-based EIS for Data Analysis
Ed Confer
Introduction to SAS
Do You Want to Know a Secret (or Two)?
Chris Toppe
Working with SAS Date and Time Functions
Andrew Karp
A Gentle Introduction To SAS/GRAPH
Ben Cochran
Passing Along SAS Data – SET, MERGE, and UPDATE
Andrew T. Kuligowski
Posters
SAS to EXCEL: An Integrated Reporting System
Fran Cohen
UltraEdit–THE EDITOR for SAS Programming
Eugene Tsykalov
An Overview of SAS Certification and the Test Development Process
Linda Althouse, Marc Vaglio-Laurin
Tips for Running Simulations in SAS
Dave Dickey, Sandy Donaghy, Joy Smith
Dynamically Assigning TREPLAY Statements for Producing Multiple Plots Per Page
Alice Lail, Karen Wade
What is Missing in SAS?
Imelda Go
Creating an Intranet Toolbox of Selective Oracle Metadata
John C. Gober, Jana L. Smith, Debi Mullen
Data Acquisition Portal (DAP): Web Based Data Collection Application
Christina Carty, Linda Linzy, Norman Oals, Elizabeth Spence, Reuben Richards
Serendipity
Data Step Hieroglyphics – ?*)&:@|_%(}
Harry Droogendyk
SAS in the Office – IT Works
Peter Eberhardt
A Table-Driven ODS Macro
Diane E. Brown
Dynamic SAS Programming Techniques, or How NOT to Create Job Security
Suzanne McCoy, Steven Beakley
The Sublime Secrets of the SAS SQLheads
Sigurd W. Hermansen
“LAG with a WHERE” and other DATA Step Stories
Neil Howard
A Sampler of Code Techniques
Ian Whitlock
Using an Array as an IF Switch
Ed Heaton, Nazik Elgaddal
Pruning the SASLOG – Digging into the Roots of NOTEs, WARNINGs, and ERRORs
Andrew T. Kuligowski
Keeping Up With the FUN: New Functions in SAS 9
Deb Cassidy
Version 9 Data Migration: How to do it and know you’ve done it right
Diane Olson
That’s my Style
Himesh Patel, Jeff Cartier
Charting a Course through Your Data and Procedures: Bar, Flow, Gant, Histogram, Process, Pie and so many others
Gary McQuown
Easy and Simple Job Tracking
Phil Busby
Behind the Scenes at SAS-L
Joe Kelley
Statistics and Data Analysis
An Introduction to Genomics and SAS Scientific Discovery Solutions
Russ Wolfinger, Kristen Quinlan, Susan Flood
An Algorithm for Screening of Genes and Clusters from Microarray Experiments
James Blum
Management of CABG Patient Mortality Using SAS Logistic Regression by Cohorts: Age, Sex and Cleveland Clinic Defined Risk Factors, Five Years Of Data And Analysis Compressed Onto a 3 X 5 Pocket Guide
Lucinda Jenkins, Bing Dao Li, Mike Mueller, Steve Adzima
EFFECT_CI: A SAS Macro for Constructing Confidence Intervals Around Standardized Mean Differences
Melinda Hess, Jeffrey Kromrey
Using the SAS System to Construct n-Values Plots
Peter Wludyka, Amy Cox
Comparison of PROC MIXED and PROC GLM for Analysis of Repeated Measures Data
Hossein Yarandi
Too Many Choices! The IMPORTANCE of Rank-Ordering Independent Variables Prior to Exploratory Data Analysis
Gregg Weldon
Methods of Dealing with Values Below the Limit of Detection Using SAS
Carry Croghan, Peter Egeghy
A SAS Macro to Design Phase II Clinical Trials
Alan Cantor
Identifying Person Duplicates of Short Geographic Distance by Computer Matching
Vincent T. Mule
An Interactive Approach to Multiple Comparison Procedures
Peter Davis
METAPERM: A SAS Macro for Permutation Tests of Linear Models in Meta-analysis
Jeffrey D. Kromery, Kristine Y. Hogarty
An Analysis Tool for Reviewing Farm Economic Data Using SAS /AF
Van Johnson
Statistical Analysis of Genotype X Environment Interaction in Agricultural Research
K. Bondari
Preparing Data using SAS for Paired Sample Comparison in Epidemiology Research
Wei Zhao, Hua Li
Developing a Marketing Geographic Segmentation System Using SAS Software
Kellie M Poulin, Allison N. Freeman
Training and Professional Development
SAS’s Resources for Learning
Michele Ensor
Efficient Way to Learn SAS with Virtually No Cost
Mirjana Stojanovic
SAS Consultants: Sheep in Wolf’s Clothing
Gary McQuown
SAS Tip, An Affordable Alternative to Traditional SAS Training
Erin Christen
Ten Things I Wish I Knew Before I Became a SAS Software Consultant
Andrew Karp
So You Want to Write a Paper? That Paper about Writing a Paper
Dianne Rhodes
Tutorials
Dare to Compare – Tailoring PROC COMPARE Output
Maria Reiss
SAS Formats: Uses and Abuses
Carry Croghan
Am I Evil?: Proc Template Exposed!!!
Kevin Delaney
Greetings from the Edge – Using javaobj in DATA Step
Richard A. DeVenezia
Dictionary Tables: Essential Tools for Serious Applications
Frank DiIorio, Jeff Abolafia
Table Lookup By Direct Addressing: From V8 To V9
Paul Dorfman
A Peek at PROC DOCUMENT
Andrew H. Karp
An Animated Guide: Proc Report: The File Behind the Scenes
Russell Lavery
Contrasting Programming Techniques For Summarizing Voluminous SAS Output Using the SAS Output Delivery System(ODS)
Stuart Long, Lawrence P. Park
Getting What You Want Out Of A Many-to-Many Merge
Sonal R. Pathak, Shabnam Mehra
Using SAS and Other XML Tools Effectively
Scott E. Chapal
How Regular Expressions Really Work
Jack Shoemaker
How to Implement the One-Time Methodology
Mark Tabladillo
SAS MACROS: Tips, Techniques, and Examples
Andrew M. Traldi
Excel Exposed: Using Dynamic Data Exchange to Extract Metadata from MS Excel Workbooks
Koen Vyverman
Creating a Compact Columnar Output with PROC REPORT
Walter R. Young
The Utter Simplicity and Power of the TABULATE Procedure
Dan Bruns