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