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.
A Programming Development Environment for SAS Programs, Tim Williams and Lee Walke
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
(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.
Bridging the Gap: From Spreadsheets to Websites, Mary K. Tucker and Maryanne Hope
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
Database Conversion: What about our programs?, John E. Bentley
Structure Approach Using MACRO Code, Allen J. Blackburn
Managing Multiple SAS/FSEDIT Data Entry with a SAS/AF Application for a Cohort Study, Emily A. Mixon and Karen B. Fowler
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
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
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
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
SAS Programs for Adding Functionality to the Occupational Mortality Analysis Program (OCMAP) Software, Robert Matthews and Dr. David Brown
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
Take a Job or Consult: In Search of Greener Grass, Chris Toppe, Ph.D.
SAS Consultants: Sheep in Wolf’s Clothing, Gary M. McQuown
High Energy SAS – Managing the SAS Community in a Large Corporation, Jim Alessio and Mark Jordan
Output Delivery System Tips, Kirk Paul Lafler
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 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
Performance Management: Communicating the Results, Barrett Joyner and Greg Barnes Nelson
The Smart Courier for Healthcare, Diane E. Brown