SESUG 2006 – Master of Science in Analytics | Institute for Advanced Analytics

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.

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