SESUG Proceedings 2002

These Proceedings are the official record of the 10th Annual SouthEast SAS Users Group (SESUG) Conference held in Savannah, GA on September 22 – 24, 2002 at the Savannah Grand Hyatt. 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 2002: The Proceedings of the SouthEast SAS Users Group, Savannah, GA, 2002

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 © 2002 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.

Application Development

Handheld Computers for Data Entry: A Data Services Approach using Java and XML, Scott Chapal

A Programming Development Environment for SAS Programs, Tim Williams and Lee Walke

GoodsHound – Building Multi-Functional Web-Based Applications with SAS/IntrNet and JavaScript, Blake Sanders and Mikhail Gruzdev

The Value of SAS in Manufacturing, Eric Brinsfield

SAS High-speed Automated Reporting Queue – SHARQ, Eric Puhlman and Kasi Peek

Meta Data + HTML = Automated Status Reports, George DeMuth, Mike DeSpirito and Frank C. DiIorio

A Sample Delivery System for A Multi-Site Study Using SAS On A UNIX Platform, Gabriel Cano

(Web) Software Development: Best Practices for Developing Enterprise Applications, Greg Barnes Nelson and Danny Grasse

Integrating SAS Analytics with Microsoft-Based Desktop Applications, Jim Tarantino, Dr. Sam Yamamura and John Payne

Refactoring Design Patterns into a SAS Application, Mark Tabladillo, Ph.D.

Techniques for SAS Enabling Microsoft Office in a Cross-Platform Environment, Vincent DelGobbo

Bridging the Gap: From Spreadsheets to Websites, Mary K. Tucker and Maryanne Hope

Coders Corner

So Many Files, So Little Time to Type in all Their Names, Francis J. Kelley

Variable Cross-Referencing Macros – Tools for When Base SAS Isn’t Enough, Frank C. DiIorio 10

Adjusting Dates in a New Century, Malachy J. Foley

Simplifying SAS Security, Derek Morgan and Dr. Michael Province

SAS Completion Codes to Make Complex Programs Run Smoothly, Heidi Markovitz

Logicals From Libraries: Using Storage as a Bridge Between Sessions, Gary Schlegelmilch

Change Shape or Lose a Few: Data Set Reduction for Analysis, Philip J. d’Almada

Proc SQL and Data Cleaning, Felicita David

JMP Density Ellipse Script Code Made Easy, Charles E. Shipp and Kirk Paul Lafler

Data Management

Database Conversion: What about our programs?, John E. Bentley

Structure Approach Using MACRO Code, Allen J. Blackburn

Streamlining Data Extraction with SAS Made Easy with the Creation of a Centralized Code Repository, Gregory P. Fagan

Managing Multiple SAS/FSEDIT Data Entry with a SAS/AF Application for a Cohort Study, Emily A. Mixon and Karen B. Fowler

Data Verification and Consolidation of Files with Dynamic Code Generation using SAS Macro, Data Step Programming, and System Utilities, William Pierce

Mrs. Clean Tackles Dirty Data, Janet E. Stuelpner

Developing a Control Methodology for Customized Data Management and Processing, Mark Tabladillo, Ph.D.

Using SAS with a SQL Server Database, Rita Thissen, Yan C. Tang and Elizabeth Heath

Sprinting with SAS/Access, Howard Plemmons

Data Quality – The Fuel That Drives the Business Engine, Ron Agresta and Tony Fisher

Panel Discussion: Data Management – the Good, the Bad, and the Ugly, Fran Akridge and Bill Calvert

Graphics and Information Visualization

Using PROC GREPLAY With ANNOTATE Data Sets for Effective Multi-Panel Graphics, Walter T. Morgan

Using JMP to Develop a Model Specification for Daily Energy Consumption, Tom Fuchs

Focusing Healthcare Quality Improvement Dollars: Using SAS for Geographic Targeting, Barbara B. Okerson, Ph.D., Charlotte F. Carroll, M.S.

Enhancements to SAS/GRAPH in V9, Himesh Patel and Ravi Devarajan

No More Downloading – Using SAS/ODS to Create SAS Graphs and HTML Documents for OS/390 Systems, Patricia Wingfield


JMP Density Ellipses for Pharmaceutical Analysis, Charles E. Shipp and Kirk Paul Lafler

Contributed Using a RAM Disk to Speed up your Windows 2000, Erik H. Dilts

Using ODS to Capture Statistics from PROC GLM, Frank Roediger

Putting it Together (The Poster): A Data Set Joining Primer, Janet E. Stuelpner and Caroline Bahler

Missing Secrets, Robin Jones and Ian Whitlock

Generate Clinical Trial Randomization Plan in Graphic User Interface, Dr. Mark Carpenter and Sijian Zhang

Using Decision Trees to Identify Medicare Part B Providers for Audit, Noel N. McKetty and Dr. Donna Mohr

Alternatives to SAS IF-THEN/ELSE Processing, Imelda C. Go, Ph.D.

Reordering Variables in a SAS Data Set, Imelda C. Go, Ph.D.

Statistics, Modelling, & Data Mining

Analysis of Dosage-Response Data in Agricultural Research, Dr. Khorsand Bondari

A SAS Program for the Computation of the Crude, Stratified and Mantel-Haenszel Odds Ratio in Case-Control Study Data Analysis of Nx2xK tables, Ilene Brill and Dr. Fabio Barbone

Variance Estimates for Census 2000 using SAS/IML Software, Peter Davis

Research Across Multiple Systems: Probabilistic population Estimation (PPE), Diane Haynes, Shabnam Mehra and Rebecca Larsen, M.S.P.H.

FDR_TEST: A SAS Macro for Calculating New Methods of Error Control in Multiple Hypothesis Testing, Dr. Jeffrey D. Kromrey and Kristine Y. Hogarty

Comparison of Correlated Proportions using SAS PROC GLM: a Simulation Study, Dr. Mark S. Litaker and Dr. Daron G. Ferris

Automated Summarization of Risk Assessment of Discrete and Continuous Exposures in Epidemiological Studies using SAS ODS, Stuart Long and Rebecca Darden

Projecting South Florida County-Level Citrus Acreage Using Time-Series Analysis (SAS Automatic Forecasting System) and Multivariate Analysis (PROC FACTOR), Dr. Richard A. March

SAS Programs for Adding Functionality to the Occupational Mortality Analysis Program (OCMAP) Software, Robert Matthews and Dr. David Brown

Using a SAS IML Nonlinear Programming Procedure to Determine a Single Uniform Weighting Scheme for a Complex Survey Design, Richard A. Moore, Jr.

Using SAS to Estimate Variance by the Jackknife Method, Thomas Mule

A Macro for Computing a Goodness of Fit Statistic for Linear Mixed Models, Jean G. Orelien

The Lag-o-Matic: An Improved Method for Selecting Lag Structure of Multiple Predictor Variables in the Absence of Theory, Dr. David Sharp and Stephen Finnigan

Managing Missing Data with Multiple Imputation using PROC MI in SAS, Dr. Hossein N. Yarandi

Basic Usage of SAS/ETS Software to Forecast a Time Series, LTC Douglas McAllaster

Using SAS to Control Multistream Binomial Processes with a Chi-Squared Control Chart, Peter Wlydyka, Dan Cavey and Brett Friedlin

The New SAS Power and Sample Size Web Applications, Wayne Watson

Training and Professional Development

Programming Standards for Base SAS and SAS Macros, Devi Sekar

Take a Job or Consult: In Search of Greener Grass, Chris Toppe, Ph.D.

SAS Consultants: Sheep in Wolf’s Clothing, Gary M. McQuown

A Journeymans Reference: The Writing for Reuse SAS Style Sheet: Tricks, Traps, Tips, and Templates from SAS-Ls Macro Maven, Ron Ronald. Fehd

High Energy SAS – Managing the SAS Community in a Large Corporation, Jim Alessio and Mark Jordan


Output Delivery System Tips, Kirk Paul Lafler

Web Application Architecture: Choosing the right tools for the project, Eric Brinsfield

Sharing your Tips and Tricks with Others: Give Your Toolbox a Web Presence, John C. Gober

The Magnificent DO, Paul Dorfman

DATA Step Essentials, Neil Howard

The Ugliest Data I’ve Ever Met, Derek Morgan

Customized Reports – Have It Your Way!, Deb Cassidy

Don’t Be a Slave to Your SAS Programs, Marje Fecht and Larry Stewart

Program Comprehension: A Strategy for the Bewildered, Frank C. DiIorio

Putting it Together (The Tutorial): A Data Set Joining Primer, Janet E. Stuelpner and Caroline Bahler

The SAS Debugging Primer, Frank C. DiIorio

Bulletproofing and Knowledge Encapsulation in Statistical Macros, John K. Troxell

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

SAS Software Macros–You’re Only Limited by Your Imagination, Part II; More Advanced Techniques, Peter Parker

SAS Macro Design Issues, Ian Whitlock

PROC FORMAT in ACTION, Jack N. Shoemaker

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

Proc Means and Summary: A Beginners Guide, Gary M. McQuown and Andrew H. Karp

The Power of PROC DATASETS, Lisa Davis

MERGING: Comparing the Data Step with SQL, Malachy J. Foley

Problem Solving Techniques with SQL, Kirk Paul Lafler

Multiple Uses for a Simple SQL Procedure, Rebecca Larsen, M.S.P.H.

Structured Query Language: Logic, Structure, and Syntax, Sigurd W. Hermansen

Vertical Solutions

Using Strategic Performance Management to Create Balanced Scorecards in a Healthcare Environment, Ben Cochran

Performance Management: Communicating the Results, Barrett Joyner and Greg Barnes Nelson

The Smart Courier for Healthcare, Diane E. Brown

Strategic Procurement: The SAS Solution for Supplier Relationship Management, Fritz Lehman