SESUG Proceedings 2007

These Proceedings are the official record of the 15th annual SouthEast SAS Users Group (SESUG) Conference held in Hilton Head, SC on November 4–6, 2007 at the Hilton Head Marriott Resort & Spa. 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 2007: The Proceedings of the SouthEast SAS Users Group, Hilton Head, SC, 2007

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 © 2007 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.

Application Development

AD01 : Simplifying the Sample Design Process With PROC PMENU
Liza M Thompson

AD03 : %XMLPORT: An XML Substitute for SAS PROC CPORT/CIMPORT (almost)
Andy E Barnett

AD05 : PROC INFOMAPS – Let Your Design Document Build Your SAS V9 Information Map
Chuck Bininger

AD07 : Treemap Presentation as a Corporate Dashboard
Larry J Day, Richard W Dickinson

AD08 : Building Your Own Real-Time SAS Server Monitor under UNIX
Houliang Li

AD09 : Multiple File Processing with SAS
Kevin McGowan

AD10 : SAS DI: Introduction to User Written Transforms and Status Handling
Mike Miller

AD11 : Integrating SAS and Microsoft .NET for Data Analysis
Mai Nguyen, Shane R Trahan, Jonathan M Cirella, Patricia Nguyen

AD13 : Developing Flexible Reports to Respond to Routine External Data Requests
Patricia J Ramsey, Esther Johns

AD14 : Improving Efficiency Using the “Virtual Merge”
Steve G Sanders

AD15 : Intelligent SAS Log Manager
Paul D Sherman

AD16 : PROC TIMEPLOT – An Old Way to PLOT New Data
James W Terry Jr.

AD17 : Two Portals, One Sign-On: Gateway to University Reporting
Ali Y Yorkos, Maureen H Murray

Coders’ Corner

CC01 : Generating Random Numbers from a Discrete User-Defined Distribution
Amy L Boulris

CC03 : Making Presentations More Fun with DATA Step Graphics Interface (DSGI)
Hui-Ping Chen

CC04 : A SAS Macro to Automate the Process of Pooling Sites
Lili Chen, Changhong Shi

CC05 : The SQL Procedure: When and How to Use It?
Ying Feng

CC06 : Using PRX to Search and Replace Patterns in Text Files
Wenyu Hu, Liping Zhang

CC08 : Creating a Stored Macro Facility in 10 Minutes
Erik S Larsen

CC09 : ABC Macro and Performance Chart with Benchmarks Annotation
Jing Li

CC11 : PC Tips for Mainframers
Claudine Lougee

CC12 : SAS XML Mapper to the Rescue
Carol A Martell

CC13 : You’ve Sent Mail: Sending Reports Automatically Through SAS
Theresa McVie

CC14 : Sorting Out the Possibilities Using RETAIN
Tommy L Retzlaff, Cara D Woodruff

CC15 : Increasing Student Progress Monitoring via PROC REPORT and ExcelXP Tagset
Elayne Reiss

CC16 : The Lazy RSUBMIT
Stephanie R Thompson

CC17 : Let’s Play a Game: A SAS Program for Creating a Word Search Matrix
Robert Matthews

Data Mining

DM01 : Making Web Results Relevant with SAS
Russell Albright, Jake Bartlett, David Bultman

DM02 : Example of Longitudinal Cluster Analysis with Dietary Data over Time
Robert L Bauserman, Ann Albertson, Nort Holschuh, William McCarth

DM03 : Analyzing Large Social Networks with MP Connect, SAS/IntrNet and %DS2CONST
Shane L Hornibrook

DM04 : Mining Medicaid Encounter Data: What, Why, and How?
Wei Jiang

DM05 : A Methodological Approach to Performing Cluster Analysis With SAS
William F McCarthy

DM07 : Data Mining and Investigating Treatment Options of Osteomyelitis with MRSA
Hamed Zahedi

DM08 : Discrete Choice Modeling with PROC MDC
John O Ang

DM09 : Yankees and Red Sox: A Time Series Analysis of Win Percentage Correlations
Grant A Johnson

Data Presentation

DP01 : Getting Started with PROC DOCUMENT and ODS
David W Kelley

DP02 : Visual Representation of Longitudinal Change in Cluster Analysis
Robert L Bauserman, Ann Albertson, Nort Holschuh, William McCarthy

DP03 : Developing a Dashboard to Aid in Effective Project Management
Paige Borden, Maureen Murray, Ali Yorkos

DP04 : To Cube or Not to Cube: Is OLAP the Better Choice?
Paige Borden, Evangeline Collado

DP05 : Recreating an Excel-Based Report with SAS and ODS
Linda M Lacey

Hands-On Workshops

HW01 : Creating Multi-Sheet Excel Workbooks the Easy Way with SAS
Vince DelGobbo

HW02 : Dynamic Projects in SAS Enterprise Guide: How to Create and Use Parameters
Susan J Slaughter, Lora D Delwiche

HW03 : Planning for and Designing a Data Warehouse: A Hands-On Workshop
Greg S Nelson

HW04 : Using Dictionary Tables: An Introduction to SAS Metadata
Frank DiIorio

HW05 : List Processing Basics: Creating and Using Lists of Macro Variables
Art Carpenter, Ronald J Fehd

HW06 : How to use PROC SQL SELECT INTO for List Processing
Ronald J Fehd

HW07 : Using INFILE and INPUT Statements to Introduce External Data into SAS
Andrew T Kuligowski

HW08 : How to Read, Write, & Manipulate SAS Dates
Jenine M Milum

Introduction to SAS

IS01: The Beginner’s Guide to Beginning in SAS
Frank DiIorio

IS02: Set, Match, Merge… Don’t You Love SAS
Peter W Eberhardt, Ying Liu

IS03: Formats, Informats and How to Program with Them
Ian Whitlock

IS04: Interactions Between the DATA Step and External Files – INFILE/INPUT and More
Andrew T Kuligowski


PO01 : A SAS Macro: Similar Code for the Similar Schools Data Processing
Imelda C Go

PO06 : A Study on Kentucky Highway Fatalities
Ryan J Glassford

PO07 : Application of an Exact Covariate Matching Macro in Outcome Analysis
Guiping Yang, Stephen Stemkovski

PO09 : Data Management Strategies
Abbas S Tavakoli, Kirby Jackson, Linda Moneyham, Kenneth Phillips, Gene Meding, Carolyn Murdaugh

PO10 : Use of ARIMA Time Series and Regressors to Forecast the Sale of Electricity
Beatrice Ugiliweneza

PO15 : Data Mining to Investigate University Expectations of Work
Guoxin Tang

PO16 : %TRAVERSE: A Knuth-style Recursive Procedure to Obtain Directory/Filenames
Andy E Barnett

PO17 : Reducing PROC CORR Output using ODS and DATA Step
Carry W Croghan

PO18 : Benefits of Using Bridging Metadata
Doug Janssen

PO19 : ROBUST_ES: A SAS Macro for Computing Robust Estimates of Effect Size
Jeffrey D Kromrey, Kevin B Coughlin

PO21 : Customized Base SAS Implemented Solvers
Ruben Chiflikyan, Mila Chiflikyan, Jean E Richardson, Renee B Karlsen, Donna Medeiros

PO22 : The CORR Procedure and Power of GTL
Mirjana Stojanovic, Donna Hollis, Laura Archer

PO23 : SSN Validation – Virtually at No Cost
Milorad Stojanovic

PO24 : Using SAS to Track Recruitment in a Multi-Center Study of Diabetes
Stephan A Villavicencio, Therese B Gibson, Patricia A Cleary

PO26 : SAS Macro Notes: Lines and Columns in the Log
Paul D Sherman


SD01 : “Powerful” SAS Techniques from the Windows API
Samuel T Croker

SD02 : The Twain Shall Meet: Facilitating Data Exchange between SAS and Matlab
Dimitri Shvorob

SD03 : Fast Prototyping using SAS/AF Software
Phil F Busby

SD04 : Creating Data-Driven Data Set Names in a Single Pass Using Hash Objects
Jack F Hamilton

SD05 : The SAS Community: How To Be a Part of It!
Gary E Schlegelmilch

SD06 : Old But Not Obsolete: Undocumented SAS Procedures
Barbara B Okerson

SD07 : The Sum of All Fears: or, So You’re the SAS Administrator?
Richard Phillips, Danny Grasse

SD08 : The DOW-Loop Unrolled
Paul M Dorfman, Lessia S Shajenko

SD09 : DATA Step Hieroglyphics
Harry Droogendyk

SD10 : Music to My Ears: Using SAS to Deal with External Files (and My iPod)
Sean Hunt

SD11 : Managing Your SAS Data Warehouse Project From Design to Delivery
Linda Sullivan, Paige Borden

SD12 : Exploring Cellular Automata
Daniel Olguin

SD13 : Smart SAS Tricks
Monal Kohli

SD14 : When PROC REPORT and TAGSETS Collide…
Eric Gebhart

Statistics and Data Analysis

SA01 : New SAS Statistical Software: Just Over the Horizon
Tonya Balan

SA02 : Structural Equation Modeling Using the CALIS Procedure
Yiu-Fai Yung

SA03 : Maryland Region Meteorologically Adjusted Ground-Level Ozone Trend Analysis
George G Antczak, Adrienne Wootten

SA04 : Using SAS/OR to Determine the Optimal Path to Graduation
Sandra J Archer, Robert L Armacost

SA05 : Information Criteria Methods in SAS for Multiple Linear Regression Models
Dennis J Beal

SA06 : Automated Realtime Forecasting of Stream Conditions with SAS
Samuel T Croker, Tomonori Ishikawa, Shane L Hornibrook

SA07 : PROC MIXED: Underlying Ideas with Examples
David A Dickey

SA08 : Selection Bias Adjustment: Root Canal Therapy and Self-Reported Oral Health
Mark S Litaker, Sandre F McNeal, Gregg H Gilbert

SA09 : Estimating the False Discovery Rate using SAS and JMP
Jason A Osborne, Clayton A Barker

SA10 : Virtual and Traditional Teams: Are they Really Different?
Andrea J Roofe, K. Galen Kroeck

SA11 : Cleaning Data the Chauvenet Way
Paul D Sherman, Lily Lin

SA12 : Data Mining Episode Groupers
Patricia B Cerrito


TU01 : DATA Step Hash Objects as Programming Tools
Paul M Dorfman, Lessia S Shajenko

TU02 : Delivering Multi-Sheet Excel Reports from a Parameterized Stored Process
Harry Droogendyk, Richard DeVenezia

TU03 : Efficiency: How Your Data Structure Can Help or Hurt!!!
Toby A Dunn

TU04 : Testing Survey Skip Patterns Using Metadata-Generated SAS Code
David Gilbertz

TU05 : Adapting Your SAS Programs into the SAS9 Paradigm
Warren Repole

TU06 : SAS Formats, More Than Just Another Pretty Face
Ying Liu

TU07 : Moving Forward with FORMATS
David Maddox

TU08 : Data Quality Management, Data Cleansing, and Discrepancy Reporting
Jenine M Milum

TU09 : Introduction to the SAS 9 Business Intelligence
Greg S Nelson

TU10 : User-Written DATA Step Functions
Robert S Ray, Jason Secosky

TU11 : Point-and-Click Style Editing in SAS Enterprise Guide
Susan J Slaughter, Lora D Delwiche