SESUG Proceedings 2005

These Proceedings are the official record of the 13th Annual SouthEast SAS Users Group (SESUG) Conference held in Portsmouth, VA on October 23–25, 2005 at the Renaissance Hotel. 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 2005: The Proceedings of the SouthEast SAS Users Group, Portsmouth, VA, 2005

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 © 2005 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

AD01-05: Everyone Trying to Update at the Same Time? Let’s Try the Source Control Manager! (SAS/AF Development Tool)
Larry Altmayer, U.S. Census Bureau, Washington, DC

AD02-05: So, Your Data are in Excel!
Ed Heaton, Westat

AD03-05: The Birth of an Information Delivery Portal at Briggs & Stratton
Sheryl Weise, WICS, Gastonia, NC

AD04-05: Systematic SAS Development, A Disciplined Approach
John W. Davison, Jr., Factotum, Inc., Leesburg, VA

AD05-05: Once Again on Efficiency and Base SAS
Milorad Stojanovic, RTI International

AD07-05: Ways to Store Macro Source Codes and How to Retrieve Them
Mirjana Stojanovic, Donna Hollis, Duke University Cancer Center Biostatistics

AD08-05: Using MS-ACCESS Metadata to Drive Automated SAS Data Processing
Gary N. Weeks, Centers for Disease Control, Atlanta, Georgia

AD09-05: Managing a Many to Many Merge using Formats, Direct Access, and Implied Hashing on Datasets Exceeding One Million Observations
Mark E. Asiala, Bureau of the Census, Washington, D.C.
John C. Gober Bureau of the Census, Washington, D.C.

AD10-05: SAS Macro Design Patterns
Mark Tabladillo Ph.D., MarkTab Consulting, Atlanta, GA
Associate Faculty, University of Phoenix

Coders’ Corner

CC01-05: Adding Web-Enabled Buttons to the SAS Tool Bar
John E. Bentley, Wachovia Bank, Charlotte NC

CC02-05: Question: How do I find out what that _TYPE_ value is from my PROC MEANS? Answer: the FINDTYPE Macro!
Dan Bruns, Chattanooga, TN

CC03-05: Tabulating Fractional Observations
Phil Busby, Live Data Systems, Inc. Apex, NC

CC04-05: The Functionality of Arithmetic SAS Functions for the CRO User
Phil d’Almada and Karen Graham, Rho, Inc.

CC05-05: Creating Zillions of Labels (and Other Documents) the Easy Way with ODS and Microsoft Word
Vincent Del Gobbo, SAS Institute Inc., Cary, NC

CC06-05: Building Reusable Programs as Includes or Macros
Ronald J. Fehd, SAS-L’s macro maven
Centers for Disease Control, and Prevention, Atlanta GA USA

CC07-05: What Do You Mean You Don’t Have SAS!!!?? Using the Power of the SAS Data Step to Create Cluster Scoring Code That Is Not Platform Dependent
Bill Hartley, M.S., Euro RSCG 4D Discovery, Glen Allen, VA

CC08-05: SAS Dating Tips – A Beginner’s Guide to SAS Dates
Erik S. Larsen, Independent Consultant

CC09-05: %CHECKDATA: An Enhanced Data Diagnostic Macro
John Stanmeyer, Trade Resources Company, Washington, D.C.

CC10-05: The Invisible Character Alt255 – Hidden Dragon Removing and Aligning Text in SAS Output
Eugene Tsykalov and Shi-Tao Yeh, GlaxoSmithKline, King of Prussia, PA

Data Presentation

DP01-05: Tips and Tricks: Using SAS/GRAPH Effectively
M. Darrell Massengill, SAS Institute, Cary, NC

DP02-05: Creating a Map within a Map with SAS/GRAPH
Barbara B. Okerson, Virginia Health Quality Center, Glen Allen, VA

DP03-05: ODS LAYOUT is Like an Onion
Rich Mays, University of Rochester Medical Center, Rochester, NY

DP04-05: A Gentle Introduction to the Powerful REPORT Procedure
Ben Cochran, The Bedford Group, Raleigh, NC

DP05-05: Is There an Art Historian in the County?
Keith J. Brown, UNC-Office of the President, Chapel Hill, NC

ETL

ETL01-05: Simplifying Existing Projects with Ideas from Data Warehousing
Rick Aster, Breakfast Communications Corporation, Paoli, PA

ETL02-05: The SQL Optimizer Project: _Method and _Tree in SAS 9.1
Russ Lavery, Numeric LLC, Chadds Ford, Pa

ETL03-05: Using SAS Enterprise ETL Server to Build a Data Warehouse: Focus on Student Enrollment Data
Evangeline Collado, University of Central Florida, Orlando, FL
M. Paige Borden, University of Central Florida, Orlando, FL

ETL04-05: RDBMS Sampling with SAS: Slow, Faster, Fastest
John E. Bentley, Wachovia Bank, Charlotte, NC

ETL05-05: Getting Started with SAS/Access for Oracle
F. Joseph Kelley, University of Georgia

ETL06-05: A Quick Tour of SAS ETL Studio to Build a Data Mart
Eric Rossland and Kari Richardson, SAS Institute, Cary, NC

Hands On Workshops

HOW01-05: How SAS Thinks
Neil Howard, Basking Ridge, NJ

HOW02-05: SAS 9 Programming Enhancements
Marje Fecht, Prowerk Consulting Ltd, Cape Coral, FL

HOW03-05: Five Ways to Create Macro Variables: A Short Introduction to the Macro Language
Arthur L. Carpenter, California Occidental Consultants, Oceanside, California

HOW04-05: SAS with Style: Creating your own ODS Style Template for RTF Output
Lauren Haworth, Genentech, Inc., South San Francisco, CA

HOW05-05: Moving Data and Analytical Results between SAS and Microsoft Office
Vincent Del Gobbo, SAS Institute Inc., Cary, NC

HOW06-05: A Gentle Introduction to Enterprise Guide 3.0
Ben Cochran, The Bedford Group, Raleigh, NC

HOW07-05: Using Dictionary Tables: An Introduction to SAS Metadata
Frank DiIorio, CodeCrafters Inc., Chapel Hill NC

Introduction to SAS

IN01-05: The SAS Data Step: Where Your Input Matters
Peter Eberhardt, Fernwood Consulting Group Inc., Toronto, ON, Canada

IN02-05: Formats, Informats and How to Program with Them
Ian Whitlock, Kennett Square, PA

IN03-05: A Tour of the SAS Reporting Toolbox
Frank DiIorio, CodeCrafters Inc., Chapel Hill NC

IN05-05: Preemptive DATA CLEANING: Techniques
Malachy J. Foley, Chapel Hill, NC

IN06-05: Summarizing Data with Base SAS PROCs
Deborah Babcock Buck, D. B. & P. Associates, Houston, TX

IN07-05: Manipulating Data: Elements of the DATA Step Language
Paul M. Dorfman, Independent SAS Consultant, Jacksonville, FL
Vyacheslav V. Tsiolko, Senior Reseracher, Institute of Physics, Kiev, Ukraine

IN08-05: Fun With Functions
Marje Fecht, Prowerk Consulting Ltd, Cape Coral, FL

IN09-05: The Program Data Vector As an Aid to DATA step Reasoning
Marianne Whitlock, Kennett Square, PA

Posters

PS01-05: A Snazzy Graph Featuring Five Variables, Axis Breaks, and Good Resolution
Rachel A. Baker, Savannah River National Laboratory, Aiken, SC
Anthony T. Baker, Westinghouse Savannah River Company, Aiken, SC

PS04-05: Emailing a SAS Report to Excel
Royce Claytor, Dominion Resources Services Inc.

PS05-05: Using SAS to Process Repeated Measures Data
Cyndie Gareleck, RAND Corporation
Terry Fain, RAND Corporation

PS06-05: Renaming SAS Variables
Imelda C. Go, South Carolina Department of Education, Columbia, SC

PS07-05: Robustness in Meta-analysis: A Macro for Computing Point Estimates and Confidence Intervals for Standardized Mean Differences and Cliff’s Delta
Kristine Y. Hogarty, Jeffrey D. Kromrey, John M. Ferron, Melinda R. Hess, and Constance V. Hines, University of South Florida, Tampa, FL

PS08-05: MXG DB2 – A Cookbook Approach
Juliana Hughes, Federated Systems Group, Inc. Mainframe Capacity Planning

PS09-05: The BEST. Message in the SASLOG
Andrew T. Kuligowski, Nielsen Media Research

PS10-05: “An Animated Guide: The Data Step Debugger”
Russell Lavery, Contractor for Numeric, LLC. Chadds Ford, PA

PS13-05: Using SAS/GRAPH GMAP to Enhance a Diabetes Wellness Campaign
Barbara B. Okerson, Virginia Health Quality Center, Glen Allen, VA

PS14-05: SAS Certification: Is it for You?
Sarbjit Rai, Genentech Inc., South San Francisco, CA

PS16-05: Macro Architecture in Pictures
Mark Tabladillo PhD, markTab Consulting, Atlanta, GA
Associate Faculty, University of Phoenix

PS17-05: Mapping an Exclusive Regular Expression Strategy
Mark Tabladillo PhD, markTab Consulting, Atlanta, GA
Associate Faculty, University of Phoenix

PS18-05: Funky Formats
Zeke Torres, 1016inc.com, Chicago, IL

Serendipity

SER01-05: Getting from What, to How, and Back to What —Recognizing and Measuring Professional Diversity. Or: The Other Side Of The SAS / IT Shop
Alan Mann, Principal Consultant, Skyline Solutions, Martinsburg, WV

SER02-05: Automated Excel-lent Validation
Janet Stuelpner, Left Hand Computing, Inc.

SER04-05: From Obscurity to Utility: APP Functions as Programming Tools
Paul Dorfman, Independent SAS Consultant, Jacksonville, FL, USA
Alexander A. Martchenko, STOPS Corp., Riga, Latvia

SER05-05: COPYGRID: Tracking Multi-Developer (and –Machine) Programs from Development to Production
Larry Altmayer, U.S. Census Bureau, Washington, DC

SER06-05: Laziness, Impatience, Hubris: Personality Traits of a Great Programmer
John E. Bentley, Wachovia Bank, Charlotte NC

SER07-05: Producing a Nonrefereed Professional Publication for SESUG or SUGI
Phil d’Almada, Rho, Inc., Chapel Hill, North Carolina

SER09-05: Using WEB Tools to Enhance Population Identification
Carol Martell, UNC Highway Safety Research Center, Chapel Hill, NC

SER10-05: Extracting Data from PDF Files
Nat Wooding, Dominion Virginia Power, Richmond, Virginia

SER11-05: Use a SAS Database Search Engine Instead of Writing a Program
Eugene Yeh, PharmaNet Inc., Cary, NC
Donovan Verrill, PharmaNet, Inc., Cary, NC

SER12-05: So You Want to Be a Manager? A Discussion On Issues to Consider Before Making a Career Move
Lauren Haworth, Genentech, Inc., South San Francisco, CA
Stephen M. Noga, Rho, Inc., Chapel Hill, NC
Andrew T. Kuligowski, Nielsen Media Research, Dunedin, FL

SER13-05: Hire Power
Neil Howard, Basking Ridge, NJ

SER14-05: Pruning the SASLOG – Digging into the Roots of NOTEs, WARNINGs, and ERRORs
Andrew T. Kuligowski, Nielsen Media Research

SER15-05: Tuning SAS 9 for Multiuser ETL Environments
Frank Bartucca, IBM Corporation, Austin, TX

Statistics and Analysis

SA01-05: SAS Code to Select the Best Multiple Linear Regression Model for Multivariate Data Using Information Criteria
Dennis J. Beal, Science Applications International Corporation, Oak Ridge, TN

SA02-05: Data Mining Methods to Examine Thousands of Possibilities in Categorical Data
Patricia B. Cerrito, University of Louisville, Louisville, KY

SA03-05: The Missing Link: Data Analysis with Missing Information
Venita DePuy, Duke Clinical Research Institute, Durham, NC

SA04-05: Statistical Shape Analysis with SAS
Katherine Gerber, University of Virginia, Charlottesville, VA

SA05-05: Using ODS to Perform Simulations on Statistics from SAS Procedures
Andrew A. Kramer, Ph.D., Cerner Corporation, Vienna, VA

SA06-05: Using PROC GENMOD for Loglinear Smoothing
Tim Moses and Alina A. von Davier, Educational Testing Service, Princeton, NJ

SA07-05: Clustering Analysis of Micro Array Data
John Schwarz, University of North Carolina, Chapel Hill, North Carolina

SA09-05: An Introduction to ODS for Statistical Graphics in SAS 9.1
Robert N. Rodriguez, SAS Institute Inc., Cary, North Carolina, USA

Tutorials

TU01-05: The Power of PROC FORMAT
Jonas V. Bilenas, JP Morgan Chase, Wilmington, DE

TU02-05: How Do I Look it Up If I Cannot Spell It: An Introduction to SAS Dictionary Tables
Peter Eberhardt, Fernwood Consulting Group Inc, Toronto, ON
Ilene Brill, University of Alabama at Birmingham, Birmingham, AL

TU03-05: An Introduction to the Simplicity and Power of SAS/Graph
Dan Bruns, Chattanooga, TN

TU04-05: Looking for a Date? A Tutorial on Using SAS Dates and Times
Arthur L. Carpenter, California Occidental Consultants

TU05-05: A SASautos Companion: Reusing Macros
Ronald Fehd, SAS-L’s macro maven,
Centers for Disease Control, and Prevention, Atlanta GA USA

TU06-05: MISSING VALUES: Everything You Ever Wanted to Know
Malachy J. Foley, Chapel Hill, NC

TU07-05: DATALINES and Sequential Files and CSV and HTML and More – Using INFILE and INPUT to Introduce External Data into the SAS System
Andrew T. Kuligowski, Nielsen Media Research

TU09-05: Proc SQL Tips and Techniques – How to get the most out of your queries
Kevin McGowan, Constella Group , Durham, NC
Brian Spruell, Constella Group, Durham, NC

TU10-05: Building Web Applications with SAS AppDev StudioTM 3.0
Frederick Pratter, Eastern Oregon University, La Grande, OR

TU11-05: Speaking Klingon: A translator’s guide to PROC TABULATE
Dianne Louise Rhodes, Westat, Rockville, Maryland

TU12-05: Proc Transpose or How to Turn It Around
Janet Stuelpner, Left Hand Computing, Inc.

TU13-05: Macro Bugs – How to Create, Avoid and Destroy Them
Ian Whitlock, Kennett Square, PA