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

CC11: Journeymen’s Tools: Data Review Macro FreqAll: Using Proc SQL List Processing with Dictionary.Columns to Eliminate Macro DO loops
Ronald J Fehd

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