SESUG 2002

The Proceedings of the SouthEast SAS Users Group

SouthEast SAS Users Group Annual Conference, Savannah, GA, September 2002

      Foreword and Conference Team

     Application Development                      

     Coders’ Corner     

     Data Management

     Graphics & Information Visualization                                                          

     Hands On Workshops

     Posters

     Statistics, Modeling, & Data Mining

     Training & Professional Development

     Tutorials

     Vertical SAS Solutions

     Future Conferences


Application Development


AD01

Handheld Computers for Data Entry: A Data Services Approach Using Java™ and XML

Scott E. Chapal, Ichauway, Inc., Newton, GA

3

AD02

A Programming Development Environment for SAS® Program

Tim Williams, PRA International, Charlottesville, VA; Lee Walke, PRA International, Charlottesville, VA

10

AD03

GoodsHound - Building Multi-Functional Web-Based applications with SAS/IntrNet® and JavaScript

Blake R. Sanders, U.S. Census Bureau, Foreign Trade Division; Mikhail Gruzdev, U.S. Census Bureau, Washington, DC

20

AD04

The Value of SAS® in Manufacturing

Eric C. Brinsfield, Meridian Software, Inc., Raleigh, NC

25

AD05

SAS® High-speed Automated Reporting Queue – SHARQ

Eric Puhlman, BlueCross BlueShield of Tennessee, Chattanooga, TN; Kasi Peek, BlueCross BlueShield of Tennessee, Chattanooga, TN

29

AD06

Meta Data + HTML = Automated Status Reports

Frank DiIorio, CodeCrafters, Inc., Chapel Hill, NC; George DeMuth, Stat-Tech Services, LLC, Chapel Hill, NC; Michael DeSpirito, Chapel Hill, NC

39

AD07

A Sample Delivery System for A Multi-Site Study Using SAS® On A

UNIX Platform

Gabriel Cano, MCNC Environmental Modeling Center, Research

Triangle Park, NC

46

AD08

(Web) Software Development: Best Practices for Developing Enterprise Applications

Greg Barnes Nelson, ThotWave Technologies, Cary, NC; Danny Grasse, ThotWave Technologies, Cary, NC

53

AD09

Integrating SAS® Analytics with Microsoft-Based Desktop Applications

Dr. Sam Yamamura, Nortel Networks, Research Triangle Park, NC; James Tarantino, Nortel Networks, Research Triangle Park, NC; John Payne, Nortel Networks, Research Triangle Park, NC

61

AD10

Refactoring Design Patterns into a SAS® Application

Mark Tabladillo, Ph.D., Atlanta, GA

67

AD11

Techniques for SAS® Enabling Microsoft Office in a Cross-Platform Environment

Vincent DelGobbo, SAS Institute, Inc., Cary, NC

75

AD12

Bridging the Gap: From Spreadsheets to Websites

Maryanne Hope, Destiny Corporation; Mary K. Tucker, Royal & SunAlliance Insurance Co., Charlotte, NC

83

Coders’ Corner


CC01

So Many Files, So Little Time to Type Their Names

Francis J. Kelley, Enterprise IT, University of Georgia, Athens, GA

89

CC04

Variable Cross-Referencing Macros - Tools for When Base SAS® Isn’t Enough

Frank C. DiIorio, CodeCrafters, Inc., Chapel Hill, NC

93

CC05

Adjusting Dates in a New Century

Malachy J. Foley, University of North Carolina at Chapel Hill

96

CC06

Simplifying SAS® Security

Derek Morgan, Division of Biostatistics, Washington University Medical School, St Louis, MO; Dr. Michael Province, Washington University Medical School, St Louis, MO

98

CC07

SAS® Completion Codes to Make Complex Programs Run Smoothly

Heidi Markovitz, Simply Systems, Key Biscayne, FL

100

CC08

Logicals From Libraries: Using Storage as a Bridge Between Sessions

Gary E. Schlegelmilch, U.S. Dept. of Commerce, Bureau of the Census, Suitland, MD

103

CC09

Change Shape or Lose a Few-Data Set Reduction for Analysis

Philip J. d'Almada, Consultant

105

CC10

Proc SQL and Data Cleaning

Felicita David, Centers for Disease Control and Prevention

106

CC11

JMP® Density Ellipse Script Code Made Easy

Charles E. Shipp, Shipp Consulting; Kirk Paul Lafler, Software Intelligence Corporation

107

Data Management


DM01

Database Conversion: What about our programs?

John E. Bentley, Wachovia Bank, Charlotte, NC

111

DM02

Structure Approach Using MACRO Code

Allen J. Blackburn, Bureau of Census, Foreign Trade Division

112

DM04

Streamlining Data Extraction with SAS® Made Easy with the Creation of a Centralized Code Repository

Gregory P. Fagan, Consultant

118

DM06

Managing Multiple SAS/FSEDIT® Data Entry with a SAS/AF® Application for a Cohort Study

Emily A. Mixon, University of Alabama at Birmingham; Karen B. Fowler, UAB, Birmingham, AL

119

DM07

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

William Pierce, Standard Technology, Inc., Falls Church, VA

123

DM08

Mrs. Clean Tackles Dirty Data

Janet E. Stuelpner, Citigroup, New York, NY

127

DM09

Developing a Control Methodology for Customized Data Management and Processing

Mark Tabladillo, Ph.D., Atlanta, GA

130

DM10

Using SAS® with a SQL Server Database

Rita Thissen, Yan C. Tang, Elizabeth Heath, RTI International, Research Triangle Park, NC

136

DM14

Sprinting with SAS/Access®

Howard Plemmons, SAS Institute, Inc.

141

DM15

Data Quality - The Fuel That Drives the Business Engine

Tony Fisher, DataFlux™ Corporation, Cary, NC (Presented by Ron Agresta, SAS)

142

Graphics & Information Visualization


GR01

USING SAS® PROC GREPLAY WITH ANNOTATE DATA SETS FOR

EFFECTIVE MULTI-PANEL GRAPHICS

Walter T. Morgan, RJ Reynolds Tobacco Company

149

GR02

Using JMP to Develop a Model Specification for Daily Energy Consumption

Thomas A. Fuchs, LG&E Energy Corporation, Louisville, KY

161

GR03

Focusing healthcare quality improvement dollars: Using SAS® for geographic targeting

Barbara B. Okerson, Ph.D., Virginia Health Quality Center, Glen Allen, VA Charlotte F. Carroll, M.S., Virginia Health Quality Center, Glen Allen, VA

166

GR04

Enhancements to SAS/GRAPH® in V9

Himesh Patel, SAS Institute, Inc., Cary, NC; Ravi Devarajan, SAS, Cary, NC

173

GR05

No More Downloading - Using SAS/ODS to Create SAS Graphs and HTML Documents for OS/390 Systems

Patricia Wingfield, Bank of America, Richmond, VA

183

Hands On Workshops

All Hands On Workshops are presented by Destiny Corporation, Wethersfield, CT


HW01

Beginning Macros

193

HW02

SQL Basics

199

HW03

Running SAS® Applications on the Web

204

HW04

Advanced Macros

214

HW05

ODS (Output Delivery System)

223

HW06

Version 9 Changes and Enhancements

231

Posters


PS01

JMP Density Ellipses for Pharmaceutical Analysis

Charles E. Shipp, Shipp Consulting; Kirk Paul Lafler, Software Intelligence Corporation

249

PS02

Using a RAM Disk to Speed up your Windows 2000 SAS Session

Erik H. Dilts, Rho, Inc.

254

PS03

Using ODS to Capture Statistics from PROC GLM

Frank Roediger, Meridian Software, Inc.

257

PS04

Putting It Together (The Poster): A Data Set Joining Primer

Janet E. Stuelpner, Citigroup, New York, NY; Caroline Bahler, Meridian Software, Inc.

263

PS05

Missing Secrets

Robin Jones, Westat, Inc.; Ian Whitlock, Westat, Inc.

267

PS07

A GUI System for the Generation of Clinical Trial Randomization Plans

for Collaborative Multi-institutional Clinical Trials

Sijian Zhang, Mark Carpenter and John W. Gnann, Jr., University of Alabama-Birmingham, Birmingham, AL

271

PS08

Using Decision Trees to Identify Medicare Part B Providers for Audit

Noel McKetty, First Coast Service Options, Jacksonville, FL; Donna Mohr, University of North Florida, Jacksonville, FL

274

PS11

Alternatives to SAS® IF-THEN/ELSE Processing

Imelda C. Go, Ph.D., Lexington School District One

278

PS12

Reordering Variables in a SAS® Data Set

Imelda C. Go, Ph.D., Lexington School District One

282

Statistics, Modeling & Data Mining


ST01

Analysis of Dosage-Response Data in Agricultural Research

Dr. Khorsand Bondari, University of Georgia

287

ST02

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, Department of Epidemiology and International Health, University of Alabama at Birmingham; Dr. Fabio Barbone, University of Alabama at Birmingham, Birmingham, AL

293

ST03

Variance Estimates for Census 2000 using SAS/IML® Software

Peter P. Davis, US Census Bureau, Washington, DC

299

ST04

Research Across Multiple Systems: Probabilistic Population Estimation (PPE)

Diane Haynes, Rebecca Larsen, Shabnam Mehra, University of South Florida, Tampa, FL

305

ST05

FDR_TEST: A SAS® Macro for Calculating New Methods of Error Control in Multiple Hypothesis Testing

Dr. Jeffrey D. Kromrey, University of South Florida; Kristine Y. Hogarty, University of South Florida

312

ST06

Comparison of Correlated Proportions using SAS® PROC GLM: a Simulation Study

Dr. Mark S. Litaker, Ph.D., and Dr. Daron G. Ferris, M.D., Medical College of Georgia Office of Biostatistics and Bioinformatics and Department of Family Medicine

318

ST07

Automated Summarization of Risk Assessment of Discrete and Continuous Exposures in Epidemiological Studies using SAS® ODS

Stuart Long, Westat, Inc., Durham, NC; Rebecca Darden, Westat, Inc., Durham, NC

322

ST08

Projecting South Florida County-Level Citrus Acreage Using Time-Series Analysis (SAS® Automatic Forecasting System) and Multivariate Analysis (PROC FACTOR)

Dr. Richard A. March, South Florida Water Management District, West Palm Beach, FL

328

ST09

SAS® Programs for Adding Functionality to the Occupational Mortality Analysis Program (OCMAP) Software

Robert Matthews, Department of Epidemiology and International Health University of Alabama at Birmingham; David Brown, PhD, Wyeth Research, Pittsburgh, PA

333

ST10

Using a SAS® IML Nonlinear Programming Procedure to Determine a Single Uniform Weighting Scheme for a Complex Survey Design

Richand A. Moore, Jr., U.S. Bureau of the Census, Washington, DC

338

ST11

Using SAS® to Estimate Variance by the Jackknife Method

Vincent T. Mule, U.S. Bureau of the Census, Washington, DC

344

ST12

A Macro for Computing a Goodness of Fit Statistic for Linear Mixed Models

Jean G. Orelien, Analytical Sciences, Inc., Durham, NC

350

ST13

The Lag-o-Matic: An Improved Method for Selecting Lag Structure of Multiple Predictor Variables in the Absence of Theory

David C. Sharp, Division of Business University of Southern Mississippi, Long Beach, MS; Stephen M. Finnigan, U.S. Department of State, Washington, DC

355

ST14

Managing Missing Data with Multiple Imputation using PROC MI in SAS®

Hossein N. Yarandi, Ph.D., University of Florida, Gainesville, FL

360

ST15

Basic Usage of SAS/ETS® Software to Forecast a Time Series

LTC Douglas L. McAllaster, US Army Logistics Management College, Fort Lee, VA

365

ST16

Using SAS® to Control Multistream Binomial Processes with a Chi-Squared Control Chart

Peter Wlydyka, University of North Florida, Jacksonville, FL; Dan Cavey, Bank of America, Jacksonville, FL; Brett Friedin, University of North Florida, Jacksonville, FL

375

ST18

The New SAS Power and Sample Size Web Applications

Wayne Watson, SAS Institute, Inc.

380

Training & Professional Development


TP01

Programming Standards for Base SAS® and SAS Macros

Devi Sekar, GlaxoSmithKline

383

TP02

Take a Job or Consult: In Search of Greener Grass

Chris Toppe, Ph.D., INDEPENDENT SECTOR

384

TP04

SAS® Consultants: A Sheep in Wolf's Clothing

Gary M. McQuown, Data and Analytic Solutions, Inc., Fairfax, VA

385

TP05

A Journeyman’s Reference: The Writing for Reuse SAS® Style Sheet:

Tricks, Traps, Tips, and Templates from SAS-L’s Macro Maven

Ron Fehd, Centers for Disease Control and Prevention, Atlanta GA

392

TP06

High Energy SAS® - Managing the SAS Community in a Large Corporation

Jim Alessio, Capital One Services, Inc., Glen Allen, VA; Mark Jordan, Capital One Services, Inc., Glen Allen, VA

397

Tutorials


TU02

Output Delivery System Tips

Kirk Paul Lafler, Software Intelligence Corporation

405

TU03

Web Application Architecture: Choosing the right tools for the project

Eric Brinsfield, Meridian Software, Inc.

412

TU04

Sharing your Tips and Tricks with Others: Give Your Toolbox a Web Presence

John Charles Gober, Bureau of the Census, Demographic Surveys Methodology Division

413

TU05

The Magnificent DO

Paul M. Dorfman, Independent Consultant, Jacksonville, FL

419

TU06

DATA Step Essentials

Neil Howard, Ingenix Pharmaceutical Services, Basking Ridge, NJ

429

TU07

The Ugliest Data I’ve Ever Met

Derek Morgan, Division of Biostatistics, Washington University Medical School, St Louis, MO

439

TU08

Customized Reports - Have It Your Way!

Deb Cassidy, Cardinal Distribution

445

TU09

Don't Be a Slave to Your SAS® Programs

Marje Fecht, Prowerk Consulting LLC; Larry Stewart, SAS, Cary, NC

455

TU10

Program Comprehension: A Strategy for the Bewildered

Frank C. DiIorio, CodeCrafters, Inc.

457

TU11

Putting It Together (The Tutorial): A Data Set Joining Primer

Janet E. Stuelpner, Citigroup, New York, NY; Caroline Bahler, Meridian Software

458

TU12

The SAS® Debugging Primer

Frank C. DiIorio, CodeCrafters, Inc., Chapel Hill, NC

467

TU14

Macros: Tips, Techniques, and Examples

Andrew M. Traldi, Advanced Quantitative Solutions, Inc., Alpharetta, GA

477

TU15

SAS® Software Macros - You’re Only Limited by Your Imagination,

Part II (More Advanced Techniques)

Peter Parker, Office of Textiles and Apparel, US Dept of Commerce, Washington, DC

485

TU16

SAS® Macro Design Issues

Ian Whitlock, Westat, Inc.

492

TU17

PROC FORMAT in ACTION

Jack N. Shoemaker, ThotWave Technologies, Cary, NC

501

TU18

Here's the Data, Here's the Report I Want - How Do I Get There?

Deborah Babcock Buck, D. B. & P. Associates, Houston TX

507

TU19

Proc Means and Summary: A Beginners Guide

Andrew H. Karp, Sierra Information Services, Sonoma, CA; Gary M. McQuown, Data and Analytic Solutions, Inc., Fairfax, VA

513

TU20

The Power of PROC DATASETS

Lisa Davis, Blue Cross Blue Shield of Florida, Jacksonville, FL

523

TU21

MERGING: Comparing the Data Step with SQL

Malachy J. Foley, University of North Carolina at Chapel Hill

533

TU22

Problem Solving Techniques with SQL

Kirk Paul Lafler, Software Intelligence Corporation

543

TU23

Multiple Uses for a Simple SQL Procedure

Rebecca Larsen, M.S.P.H., Louis de la Parte Florida Mental Health Institute, University of South Florida, Tampa, FL

549

TU24

Structured Query Language: Logic, Structure, and Syntax

Sigurd W. Hermansen, Westat, Inc.

553

Vertical SAS Solutions


VS01

Using Strategic Performance Management® to Create Balanced Scorecards in a Healthcare Environment

Ben Cochran, The Bedford Group, Raleigh, NC

565

VS02

Performance Management: Communicating the Results

Barrett Joyner, FullSeven Technologies; Greg Barnes Nelson, Thotwave Technologies

570

VS03

The Smart Courier® for Healthcare

Diane E. Brown, TEC Associates, Indianapolis, IN

571

VS04

Strategic procurement: The SAS® Solution for Supplier Relationship Management

Fritz Lehman, SAS Institute, Inc.

575

Author Index

583

Keyword Index

587