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