SESUG Proceedings 2006
These Proceedings are the official record of the 14th annual Southeast SAS Users Group (SESUG) Conference held in Atlanta, GA on October 8–10, 2006 at the Sheraton Atlanta. 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 2006: The Proceedings of the Southeast SAS Users Group, Atlanta, GA, 2006
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 © 2006 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
AP01: %STPBEGIN: How EG Almost Removed the L-word from My Relationship With SAS
Rupinder Dhillon, Peter Eberhardt
AP02: Using Proc Pmenu to Develop a User Friendly Utility Rate Design System
William T Bland, Allen B Dunn, James P Hilton
AP03: Designing an Application with Business Intelligence
Brian W Deitch
AP04: Top-Down Programming with SAS Macros
Edward Heaton
AP05: Be Your Own Task Master – Adding Custom Tasks to EG
Peter Eberhardt
AP06: Using a Control Dataset to Manage Production Compiled Macro Library
Curtis E Reid
AP08: SAS Match Merges: The Driving Force behind a Web-Based Data Coding System
Barbara Felts, Wafa Handley, Chuchun Chien, Inga Allred
AP09: Perl Regular Expressions in SAS
Kevin McGowan
AP10: A Practical Approach to the Stored Compiled Macro Facility in a Clinical Trial Environment
Mirjana Stojanovic, Dorothy Watson, Donna Hollis
AP11: Return of the Codes: SAS’, Windows’, and Yours
Mark Tabladillo
AP12: Data Warehouse Implementation: Where We Are 1 Year Later
Evangeline Collado, Linda S Sullivan
AP13: Why Write a Macro? Then Again, Why Not?
John W Davison, Jr.
AP14: Modifying the LogParse PassInfo Macro to Provide a Link between Product Usage in Rtrace Log and Time Used in Job Log
Ronald J Fehd
AP15: Service-Oriented Architectures: Going from Buzz to Business
Dan Jahn
AP16: DIFFTREE: A Macro to Compare Corresponding Files under Two Directory Trees
Andy E Barnett
Coders’ Corner
CC01: Putting SAS Dataset Variable Names into a Macro Variable
Stephanie R Thompson
CC03: Proc Format, a Speedy Alternative to Sort/Merge
Jenine Milum
CC04: While You Were Sleeping – Scheduling SAS Jobs to Run Automatically
Faron Kincheloe
CC05: SYMPLIFY your Data Set Transposition with SYMPUT, and Make it Data-Driven Too!
Christianna S Williams
CC06: A Better Means: The ODS Data Trap
Myra A Oltsik, Peter Crawford
CC07: The BEST. Message in the SASLOG
Andrew T Kuligowski
CC09: SAS Abbreviations are Your Friends, Use a Template Method to Code!
Elizabeth B Ceranowski
CC10: What’s Really in Your Data? A Quick and Easy Utility to Analyze any SAS Dataset
Thom Clay, Jamila Ervin, Michele Laughlin, Toni Wiliamson
CC12: PC Tips for Mainframers
Claudine E Lougee
CC13: Transferring vs. Transporting Between SAS Operating Environments
Mimi Lou
CC14: Dup, Dedup, DUPOUT – New in PROC SORT
Heidi Markovitz
CC15: Generating Multivariate Normal Data by Using PROC IML
Lingling Han
CC16: Dare to COMPARE – Three Methods of Preparing Your Data to Compare Values
David Maddox
Data Presentation
DP01: Effective Forecast Visualization With SAS/GRAPH
Samuel T Croker
DP02: Graphics for Statistical Concepts and Data Display
David A Dickey
DP03: Sorting ODS HTML Tables by Column Headers Using Javascript
Laura W Covington, Neal Oden
DP04: Analyzing Large Social Networks with MP Connect, SAS/IntrNet, and %DS2CONST
Shane L Hornibrook
DP05: Generating Participant Specific Figures Using SAS Graphic Procedures
Carry W Croghan, Marsha K Morgan
DP06: SAS/GRAPH: Introduction to the World of Boxplots
Brian M Spruell
DP07: Using Advanced Features of DDE to Customize Formatted Tables in Excel
Dennis J Beal
DP08: Water Usage Distribution and Its Relation with Income Using SAS and ArcGIS
Fariba Nowrouzi Kashan
DP09: ColdFusion and SAS: No Pain Meds Required
Carol A Martell
DP10: Now – That’s Your Style!!!!!
Chevell T Parker
DP11: Release 2.1 of SAS Add-In for Microsoft Office–Bringing Microsoft Powerpoint to the Mix
Chris J Hemedinger, Jennifer Clegg, Eric Hill
DP12: Overview: SAS Web Report Studio 3.1 and SAS Add-In for Microsoft Office 2.1
Eric Rossland, Tom Carter, Kari Richardson
ETL: Extract, Transform and Load
ET01: Demystifying the SAS Excel Libname Engine – A Practical Guide
Carol A Martell, Paul A Choate
ET02: The Ins and Outs of SAS Data Integration Studio
Chris Olinger, Tim Weeks
ET03: Detection and Quantification of Asymmetric Peaks
Carry W Croghan, Ronald W Williams
ET04: Collect, Clean, Conquer – A Field Guide to Surviving Master Data Clean-up
Jessica Baldwin-Finke
ET05: Many to One Using a SAS DATA Step and PROC MEANS
Jennifer L Waller
ET06: DATALINES, Sequential Files, CSV, HTML and More: Using INFILE and INPUT to Introduce External Data into the SAS System
Andrew T Kuligowski
ET07: When PROC SQL Is Overwhelmed: How to Use the SyncJoin Algorithm to Match Millions of Records Fast
Houliang Li
ET08: Master Data Management–What It Is and Why You Should Care
John E Bentley
ET09: Data Step Interfaces with the Macro Facility
Toby A Dunn
ET11: What’s New In Data Quality?
Phillip G Smith
Hands On Workshops
HW01: Answering the Right Question with the Right PROC
Carrie L Mariner
HW02: The How and Why of SAS Macro Language
Carrie L Mariner
HW03: PROC SQL for DATA Step Die-hards
Christianna S Williams
HW04: Generating Fantastic Graphs the Quick and Easy Way with Enterprise Guide
Ben T Cochran
HW05: Creating AND Importing Multi-Sheet Excel Workbooks the Easy Way with SAS
Vince DelGobbo
HW06: SAS to Publishable Excel… Seamlessly: Using ODS, XML, and Other Tricks
Marje Fecht, Harry Droogendyk
HW07: FORMAT FESTIVAL – An Introduction to SAS FORMATS and INFORMATS
David Maddox
HW08: An Animated Guide : The SAS DATA Step Debugger
Russell M Lavery
Posters
PO01: Using Contour Plots to Promote EHR Use in Physician Offices
Barbara B Okerson
PO02: The Absolute Nitty-Griddy of ODS Layout: Part I
Annette I Ladan
PO03: Selecting Variable Names into a Macro Variable Facilitates Data Analysis
Fenggang Peng
PO04: PUB_BIAS: A SAS Macro for Detecting Publication Bias in Meta-Analysis
Gianna M Rendina-Gobioff, Jeffrey D Kromrey
PO05: Hexadecimals in SAS: Have You Been Hexed?
Imelda C Go
PO06: MLM_SIM: A SAS Macro for the Statistical Investigation of Mixed Models
Jeffrey D Kromrey, James T Coraggio, Ha Phan, Jeanine Romano, Melinda Hess, Reginald Lee, Constance Hines, Stephen Luther
PO07: Creating Unique Digital Signatures Using CRC32 Standard
John C Fulda
PO08: A Relational Understanding of SDTM Tables
John R Gerlach, Glenn O’Brien
PO09: How to Implement the One-Time Methodology
Mark Tabladillo
PO10: SAS Programs to Select Controls for Matched Case-Control Studies
Robert Matthews, Ilene K Brill
PO11: SAS Programs for Extracting Data from LexisNexis Documents
Robert Matthews, Thomas Bender
PO12: A Case Study In Deploying SAS Programs on Unix Using Windows Based Tools
Samuel T Croker
PO13: Proc SQL, To Collapse Many-to-One Relationship
Tadesse Haileyesus
PO15: Tired of Typing? Got a Layout Definition with No Column Headers? Have WE Got a Fix For YOU!
Thom Clay, Jamila Ervin, Michele Laughlin, Toni Wiliamson
PO16: Creating RTF Tables with Univariate Analyses of Multiply Imputed Data
Marie G Gantz
PO17: Oracle’s RANK() Smells Good: Using RANK() in Pass-through Queries
Richard A DeVenezia
PO18: Potential Duplicate HIV/AIDS Patient Names Across States. A CDC Puzzle
Bikila bi Gwet
PO19: One Method for Improving Quality of Data in Longitudinal Study
Milorad Stojanovic, Ruth E Heuer
Simple But Clever
SC01: The TEMPLATE Procedure Styles: Evolution and Revolution
Kevin D Smith
SC02: Sudoku Puzzles – Using a Cube to Solve the Square
John R Gerlach
SC04: Six Cool Things You Can Do in Display Manager
Jenine Milum
SC05: The Pegboard Game: A Recursive SAS Macro Solution
Houliang Li
SC06: Sleepless in Wherever: Resolving Issues in Scheduled Jobs
Faron Kincheloe
SC07: Taking the Proc Summary a Step Beyond
Priya Suresh
SC08: See What You Are Missing: Finding Missing Data Records
Kim R Truett
SC09: %IFN – A Macro Function
Ian Whitlock, Chang Y Chung
SC10: Already Sorted? Make Good Use of It!
Paul M Dorfman, Lessia S Shajenko
SC11: Handling Dates in the Macro Facility
Toby A Dunn
SC13: Solving Jumble Puzzles: Dictionaries, Hashes and Permutations
Richard A DeVenezia
SC14: Controlling Macro Output or, “What Happens in the Macro, Stays in the Macro”
Frank DiIorio
SC15: An Annotated Guide: Using Proc Tabulate and Proc Summary to Validate SAS Code
Russell M Lavery
SC16: From Synapse to Syntax: a Panel Discussion on Problem Solving
Peter Eberhardt, Richard DeVenezia, Paul Dorfman, Ian Whitlock
SC18: Exploring SAS Generation Data Sets
Kirk P Lafler
SC19: How to Implement the SAS Data Step Hash Object
Bill Parman
SC20: Postcards From Camp ETL: A Manual For Surviving SAS ETL Studio
Alan R Mann
SC21: An Easy, Concise Way to Summarize Multiple PROC COMPAREs Using the SYSINFO Macro Variable
Lex S Fennell
Statistics, Data Mining and Data Analysis
ST01: The Design and Use of Metadata: Part Fine Art, Part Black Art
Frank DiIorio, Jeff Abolafia
ST02: Using SAS Enterprise Miner to Examine General Education Issues
Patricia B Cerrito
ST03: A Simulation Study of Sequential Testing Approaches in Genetics
Andres Azuero, David T Redden
ST04: Segmentation of Data Prior to Modeling
Gregg Weldon, Zidun He
ST05: They Asked for a Segmentation Scheme, Not Clusters
Jeff G Zeanah, Gary Huff
ST06: Gene Expression Profiling of DNA Microarray Data using Association rule and Structural Equation Modeling
Mussie Tesfamicael
ST07: Predictive Modeling To Analyze Hospital Charges Versus Reimbursements
Chakib Battioui
ST08: Individual Growth Analysis Using PROC MIXED
Maribeth Johnson
ST09: Application of the Generalized Linear Model to the Prediction of Lung Survival
Andrew D Karem
ST12: Combining PROC GENMOD Models with Multinomial Outcomes Using PROC MIANALYZE
Marie G Gantz
ST13: Modern Regression Analysis
Robert Cohen
ST14: Comparing Time series, Generalized Linear Models and Artificial Neural Network Models for Transactional Data Analysis
Joseph Twagilimana
ST15: Designing Information-Service Products: A Hierarchical Bayesian Approach
Nanting Chou, David D Steenhard
ST16: Data Mining of Dental Information
Christiana Petrou
ST17: Effect Modification Investigation Using SAS – A Model Building Exercise
Vanessa Bundy, Paule Barbeau, Maribeth H Johnson
ST18: Using Nominal Variables to Classifying College Enrollments
Arnold L Hook
Tutorials
TU01: %WINDOW: Get the Parameters the User Wants and You Need
Michael A Mace
TU02: ODS: Odious or Not
Janet E Stuelpner
TU03: How Do I Look it Up If I Cannot Spell It: An Introduction to SAS Dictionary Tables
Ilene Brill, Peter W Eberhardt
TU05: Demystifying the SAS Macro Facility – by Example
Harry J Droogendyk, Marje Fecht
TU06: SAS MACROS: Tips, Techniques, and Examples
Andrew M Traldi
TU07: Stars and Models: How to Build and Maintain Star Schemas Using SAS Data Integration Server in SAS 9
Johnny R Starling, Nancy Rausch
TU08: Exploring DICTIONARY Tables and SASHELP Views
Kirk P Lafler
TU09: My ODS – Real-World Uses of Modifying Table Templates
Steve James
TU10: Using SAS ODS to Extract and Merge Statistics from Multiple SAS Procedures
Stuart D Long, Jeff Abolafia, Lawrence Park
TU12: The New World of SAS: Programming with SAS Enterprise Guide
Chris J Hemedinger
TU13: How to Think Through the SAS DATA Step
Ian Whitlock