SESUG 2003

The Proceedings of the SouthEast SAS Users Group

SouthEast SAS Users Group Annual Conference, St Pete Beach, FL, September 2003

FOREWARD

ACKNOWLEDGEMENTS

CONFERENCE TEAM

Applications Development

Coders’ Corner

Data Management

Data Presentation

Hands-On Workshops

Introduction to SAS

Posters

Serendipity

Statistics & Data Analysis

Training & Professional Development

Tutorials

Paper Number		Page Number
Applications Development
AD01	Building Drill-down SAS® Applications Kirk Lafler, Software Intelligence Corporation Charles Edwin Shipp, Shipp Consulting	3
AD02	SAS® System on Network Appliance Dr. Darrell Suggs, Network Appliance Inc. Margaret Crevar, SAS Institute Leigh Ihnen, SAS Institute	7
AD03	The Revised NTP TDMS System Gabriel Cano, Kevin McGowan, Jean Orelien Constella Group, Durham, NC	13
AD04	Developing and Deploying Java Applications Around SAS®: What they Didn't Tell You in Class Greg Barnes Nelson, Jeff Wright ThotWave Technologies, LLC.	19
AD05	The Dataset Attribute Family of Classes Mark Tabladillo, markTab Consulting	29
AD06	A Hiker's Guide to Web Development Steve James, Centers for Disease Control and Prevention	35
AD07	Bulletproofing and Knowledge Encapsulation in Statistical Macros John K. Troxell, Merck & Co., Inc.	47
AD08	A Journeyman’s Reference: The Writing for Reading SAS® Style Sheet: Tricks, Traps, Tips, and Templates, from SAS-L Macro Maven Ron Fehd, Center for Disease Control	51
AD09	A Hybrid Modeling Platform to meet Basel II Requirements in Banking Jeffery Morrision, SunTrust Bank, Inc.	57
AD10	Information System for State Trauma Advisory Committee - An application of SAS/IntrNet® Ms. Xiao Zhuang & Dr. Sharon Schiro University of North Carolina at Chapel Hill	65
AD11	Pinch of SAS®, a Fraction of HTML, and a Touch of JavaScript Serve Up a Grand Recipe Jonah P. Turner, U.S. Bureau of the Census	69
AD12	SAS^® Macros are the Cure for Quality Control Pains Gary McQuown, Data and Analytic Solutions, Inc.	75
AD13	A Beginners Guide to Incorporating SAS^® Output into Microsoft^® Office Applications Vincent Del Gobbo, SAS Institute, Inc.	81
AD14	ODS for Microsoft Excel^® David Shamlin, SAS Institute, Inc.	89
AD15	Programming for Failure: When Programs Fall Down and Go Boom Gary Schlegelmilch, U.S. Bureau of the Census	90
Coders’ Corner
CC01	Musical Macros: A Soothing Solution for a Recurrent Data Step Headache Philip J. d'Almada, Rho, Inc.	101
CC02	Libname: Start Your Engines Janet E. Stuelpner, Independent Consultant	104
CC03	Spreading the News: Using System Options Deb Cassidy, Cardinal Health	106
CC04	The Evolution of a Macro: Converting your SAS® Files to a Different Version John C. Gober, Deborah Mullen, Jana L. Smith U.S. Bureau of the Census	108
CC07	Create an Informative Summary from Proc T-Test Output Jennifer K. Warner, Marsh Affinity Group Services	110
CC08	How to Get What You Need - Part 1 Chris Toppe, Ph.D., Independent Sector	113
CC09	How to Get What You Need - Part 2 Chris Toppe, Ph.D. , Independent Sector	116
CC11	Processing Large Lists of Parameters and Variables with SAS® Arrays and Macro Language Eugene Tsykalov, Ph.D., GlaxoSmithKline	119
CC12	Using SAS® System in a Very Limited Time/Resource Environment Milorad Stojanovich, RTI International	122
CC13	Machine Reading of Warranty Claims for Classification Robert McCurdy, Mack Trucks	124
CC14	SAS Dating Tips - A Beginner's Guide to SAS® Dates Erik S. Larsen, Independent Consultant	127
CC15	Advantages of PROC SCORE Mark Tabladillo, markTab Consulting	129
CC16	Using SAS® Macro Language to Develop User-Written Functions Deb Pine, ThotWave Technologies, LLC.	131
CC17	A "Real" Drill-Down Java Graph Jenine Eason, Autotrader.com	133
Data Management
DM01	New Technologies for Delivering Data to Internal and External Clients Sigurd W. Hermansen, Westat	139
DM02	Data-driven Validation Rules: Custom Data Validation without Custom Programming Don Hopkins, Ursa Logic Corp.	144
DM03	A Technique for Storing and Manipulating Incomplete Dates in a Single SAS^® Date Value John Ingersoll, Independent Consultant	152
DM04	Checking Datasets before Submitting Code Mark Tabladillo, markTab Consulting	160
DM05	Automated Testing and Real-time Event Management: An Enterprise Notification System Greg B Nelson, Danny Grasse, and Deborah Pine ThotWave Technologies LLC	166
DM06	Demand for Analysis-Ready Data Sets: An Introduction to Banking and Credit Card Analytics Bikila bi Gwet, VisualStat® Computing, Inc.	172
DM07	PROC SQL: Why Use It When Simple IF/THEN Statements Work? Susan Myers & Inga Allred, Research Triangle Institute	182
DM08	Using DDE and SAS^®/Macro for Automated Excel Report Consolidation and Generation Sandra Archer, Mengxi Li & Russell Denslow, Sodexho USA	186
Data Presentation
DP01	Special Education Practice and Policy: What Principals Know and Need to Know. Dr. Wendy Dickinson, Dr. Tanice Knopp, Dr. Janice Fauske, University of South Florida	195
DP02	Pivoting Data. An Alternative to ACROSS Variables of the REPORT Procedure. Bikila (Kila) bi Gwet, VisualStat®? Computing, Inc./Bikila Analytics™/InfiStar Corporation	202
DP04	SAS/Intrnet® and Census Mapping: How Low Would You Like to Get? Lakshmi Pandey, William Joseph Smith, David Sjoquist, Fiscal Research Program, Andrew Young School of Policy Studies, Georgia State University	212
DP05	Using SAS® and Other Tools to Move an Institutional Research (IR) Office from Hardcopy Reporting to a Web-Based Environment Ms. Sabrina L. Andrews, Ms. Evangeline Collado, Ms. Patricia Ramsey, Office of Institutional Research, University of Central Florida	222
DP06	Bookmarks, Links, and It Looks Great Printed too. Come in and See What ODS PDF Can Do for You. Kevin Delaney, Northrop-Grumman Mission Systems	232
DP07	Tedious Template Made Easy Cindy Stroupe, Inveresk Research	241
DP08	Enterprise Reporting through the SAS^® V9.1 Business Intelligence Architecture Jeff Shaughnessy, SAS Institute, Inc.	244
DP09	Building a Web-based EIS for Data Analysis Ed Confer, KGC Programming Solutions	245
Hands-On Workshops All Hands-On Workshops are presented by Destiny Corp., Wethersfield, CT
HW01	Version 9 ODS (Output Delivery System) – Basics	255
HW02	Moving SAS® Information to Excel®/Word® using DDE	267
HW03	Macros - Basic	273
HW04	Multithreading Applications in Version 9.1	287
HW05	Version 9 ODS – Intermediate	289
HW06	Merge Processing and Alternative Table Lookup Techniques	303
HW07	Macros - Intermediate	310
Introduction to SAS
IN02	Tricks of a Truly Lazy SAS^®Programmer Chris Toppe, Independent Sector	325
IN03	Choosing and Using Base SAS® PROCs Debbie Buck, D. B. & P. Associates	334
IN04	Fun With Functions Marje Fecht, Prowerk Consulting	335
IN05	How SAS® Thinks Neil Howard, Ingenix	336
IN06	The Elements of SAS® Programming Style Frank DiIorio, CodeCrafters, Inc.	337
IN07	Working with SAS® Date and Time Functions Andrew Karp, Sierra Information Services, Inc.	338
IN08	A Gentle Introduction To SAS/GRAPH® Ben Cochran, Bedford Group	347
IN09	Passing Along SAS® Data - SET, MERGE, and UPDATE Andrew T. Kuligowski, Nielsen Media Research	352
IN10	Testing and Validating SAS^® Programs S. David Riba, JADE Tech, Inc.	361
Posters
PS01	SAS® to EXCEL™: An Integrated Reporting System Fran Cohen, Westat, Inc.	365
PS02	UltraEdit™--THE EDITOR for SAS® Programming Eugene Tsykalov, GlaxoSmithKline	370
PS03	An Overview of SAS® Certification and the Test Development Process Linda Althouse and Marc Vaglio-Laurin SAS Institute, Inc.	376
PS04	Developing a Marketing Geographic Segmentation System Using SAS® Software Allison N. Freeman and Kellie M. Poulin Marsh Affinity Group Services This poster accompanies a paper presented in Statistics & Data Analysis, SD18. See the paper for details.	597
PS06	Tips for Running Simulations in SAS® Dr. Dave Dickey, Sandy Donaghy, Joy Smith North Carolina State University	382
PS07	Dynamically Assigning TREPLAY Statements for Producing Multiple Plots Per Page Alice Lail and Karen Wade, Rho, Inc.	383
PS08	What is Missing in SAS®? Imelda Go, South Carolina Department of Education	388
PS09	Creating an Intranet Toolbox of Selective Oracle™ Metadata John C. Gober, Jana L. Smith, Debi Mullen U.S. Bureau of the Census	393
PS10	Data Acquisition Portal (DAP) Web: Web Based Data Collection Application Christina Carty, Elizabeth Spence, Norman Oals, Linda Linzy VA Cooperative Studies Program Coordinating Center, Perry Point, Maryland Reuben Richards, Public Sector Group, SAS Institute Inc., Rockville, Maryland	399
Serendipity
SE01	Data Step Hieroglyphics - ?*)&:@|_%(} Harry Droogendyk, Stratia Consulting Inc.	403
SE02	SAS® in the Office - IT Works Peter Eberhardt, Fernwood Consulting Group Inc.	415
SE03	A Table-Driven ODS Macro Diane E. Brown, eXponential Systems	422
SE04	Dynamic SAS® Programming Techniques, or How NOT to Create Job Security Suzanne McCoy, Lucid Analytics Steven Beakley, Independent Consultant	430
SE05	The Sublime Secrets of the SAS® SQLheads Sigurd W. Hermansen, Westat	437
SE06	“LAG with a WHERE” and other DATA Step Stories Neil Howard, Ingenix Pharmaceutical Services	443
SE07	A Sampler of Code Techniques Ian Whitlock, Westat	444
SE08	Using an Array as an IF Switch Ed Heaton and Nazik Elgaddal, Westat	450
SE09	Pruning the SASLOG - Digging into the Roots of NOTEs, WARNINGs, and ERRORs Andrew T. Kuligowski, Nielsen Media Research	459
SE10	Keeping Up With the FUN: New Functions in SAS 9 Deb Cassidy, Cardinal Health	469
SE11	Proc Migrate: How to Migrate Your Data and Know You’ve Done It Right! Diane Olson and David Wiehle, SAS® Institute.	476
SE12	That’s my Style Himesh Patel, SAS Institute, Inc.	487
SE14	Charting Your Course: Charts and Graphs for IT Projects Dawn Li, Ph. D. and Gary McQuown, Data and Analytic Solutions	488
SE15	Track Your SAS^® Jobs with Tracker Phil Busby, Live Data Systems, Inc.	497
SE16	Behind the Scenes at SAS-L F. Joseph Kelley, University of Georgia	500
Statistics & Data Analysis
SD01	An Introduction to Genomics and SAS® Scientific Discovery Solutions Susan Flood, Russ Wolfinger, Kristen Quinlan SAS Institute, Inc.	505
SD02	An Algorithm for Screening of Genes and Clusters from Microarray Experiments James Blum, University of North Carolina at Wilmington	512
SD03	Management of CABG Patient Mortality Using SAS® Logistic Regression by Cohorts: Age, Sex and Cleveland Clinic Defined Risk Factors Five Years of Data and Analysis Compressed onto a 3 X 5 Pocket Guide. Lucinda Jenkins, MBA; Bing Li, Ph.D.; Mike Mueller, RN and MBA; Steve Hadzima, MD and MBA Christian Hospital NE	516
SD04	EFFECT_CI: A SAS Macro for Constructing Confidence Intervals Around Standardized Mean Differences Melinda Hess, University of South Florida	523
SD05	Using the SAS® System to Construct n-Values Plots Peter Wludyka, Amy Cox, University of North Florida	529
SD06	Comparison of PROC MIXED and PROC GLM for Analysis of Repeated Measures Data Hossein Yarandi, University of Florida	538
SD07	Too Many Choices! The IMPORTANCE of Rank-Ordering Independent Variables Prior to Exploratory Data Analysis Gregg Weldon, Sigma Analytics & Consulting, Inc.	544
SD08	Methods of Dealing with Values Below the Limit of Detection Using SAS® Carry Croghan, Dr. Peter Egeghy, US-EPA	549
SD09	A SAS® Macro to Design Phase II Clinical Trials Alan Cantor, Moffitt Cancer Center	554
SD10	Identifying Person Duplicates of Short Geographic Distance by Computer Matching Vincent T. Mule, U.S. Bureau of the Census	556
SD11	An Interactive Approach to Multiple Comparison Procedures Peter Davis, U.S. Bureau of the Census	566
SD12	METAPERM: A SAS® Macro for Permutation Tests of Linear Models in Meta-analysis Jeffrey D. Kromery, Kristine Y. Hogarty University of South Florida	570
SD13	An Analysis Tool for Reviewing Farm Economic Data Using SAS /AF® Van Johnson, U.S. Bureau of the Census	576
SD15	Statistical Analysis of Genotype X Environment Interaction in Agricultural Research K. Bondari, University of Georgia, Tifton	583
SD16	Missing Data Values: Analyzing their Effects on Rainfall Forecasts Using PROC EXPAND and the SAS® Time-Series Forecasting System Richard March, South Florida Water Management District	589
SD17	Preparing Data Using PROC SQL and SAS Macro for Paired Sample Comparison on Intervention Study Wei Zhao, Hua Li, University of Miami	593
SD18	Developing a Marketing Geographic Segmentation System Using SAS® Software Kellie M Poulin, Allison N. Freeman Marsh Affinity Group Services	597
Training & Professional Development
TD01	SAS's Resources for Learning Michele Ensor, SAS Institute, Inc.	609
TD02	Efficient Way to Learn SAS® with Virtually No Cost Mirjana Stojanovic, Statistical Programmer	610
TD03	SAS® Consultants: Sheep in Wolf’s Clothing Gary McQuown, Data and Analytic Solutions	616
TD04	So You Want to Write a paper? That paper about Writing a Paper Dianne Rhodes, WESTAT	624
TD05	Ten Things I Wish I Knew Before I Became a SAS® Software Consultant Andrew Karp, Sierra Information Services, Inc.	628
Tutorials
TU01	Dare to Compare - Tailoring PROC COMPARE Output Maria Reiss, Wyeth	639
TU02	SAS® Formats: Uses and Abuses Carry Croghan, US-EPA	649
TU03	Am I Evil?: Proc Template Exposed!!! Kevin Delaney, Northrop-Grumman Mission Systems, Atlanta, GA	655
TU04	Greetings from the Edge: Using javaobj in DATA Step Richard A. DeVenezia, Remsen, NY	665
TU05	Dictionary Tables and Views: Essential Tools for Serious Applications Frank DiIorio, CodeCrafters, Inc., Chapel Hill, NC Jeff Abolafia, Rho, Inc., Chapel Hill, NC	675
TU06	Table Lookup By Direct Addressing: From V8 To V9 Paul Dorfman	685
TU07	A Peek at PROC DOCUMENT Andrew H. Karp, Sierra Information Services, Inc.	698
TU08	An Animated Guide: Proc Report: The File Behind the Scenes Russell Lavery, Independent Consultant	699
TU09	Contrasting Programming Techniques for Summarizing Voluminous SAS® Output Using the SAS Output Delivery System(ODS) Proc FREQ as an Example Stuart Long and Larry Park, Westat	709
TU10	Getting What You Want Out Of A Many-to-Many Merge Sonal R. Pathak MPH and Shabnam Mehra, University of South Florida	719
TU11	Using SAS® and Other XML Tools Effectively Scott E. Chapal, Ichauway, Inc.	724
TU12	How Regular Expressions Really Work Jack Shoemaker, ThotWave Technologies	734
TU13	How to Implement the One-Time Methodology Mark Tabladillo, markTab Consulting	738
TU14	MACROS: Tips, Techniques, and Examples Andrew Traldi, Advanced Quantitative Solutions, Inc.	743
TU15	Excel™ Exposed: Using Dynamic Data Exchange to Extract Metadata from MS Excel Workbooks. Koen Vyverman, SAS Institute - the Netherlands	753
TU16	Creating a Compact Columnar Output with PROC REPORT Walter R. Young, Principal Clinical Programmer Analyst, Wyeth	763
TU17	The Utter Simplicity and Power of the TABULATE Procedure Dan Bruns, Tennessee Valley Authority	771
Indices
	Author Index	779
	Keyword Index	785