SESUG Proceedings 2010

These Proceedings are the official record of the 18th annual SouthEast SAS Users Group (SESUG) Conference held in Savannah, GA on September 26 – 28, 2010 at the Hyatt Regency Savannah. 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 2010: The Proceedings of the SouthEast SAS Users Group, Savannah, GA, 2010

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 © 2010 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. The Institute is not responsible for the accuracy or originality of this material.

Beyond the Basics

%whatChanged: A Tool for the Well-Behaved Macro, Frank DiIorio

While You Were Sleeping, SAS® Was Hard At Work, Andrea Wainwright-Zimmerman

Which SASAUTOS Macros Are Available To My SAS® Session, Harry Droogendyk

QC Your SAS® and RDBMS Data Using Dictionary Tables, Harry Droogendyk

SAS/Data Integration Studio® – Creating and Using a Generated Transformation, Jeff Dyson

ExcelXP on Steroids: Adding Custom Options To The ExcelXP Tagset, Mike Molter

Mobile Macros – Get Up to Speed Somewhere New Fast, Patricia Hettinger

SAS® and Relational Databases: What You Must Know, Patricia Hettinger

A Serious Look Macro Quoting, Ian Whitlock

The Path, The Whole Path, And Nothing But the Path, So Help Me Windows, Art Carpenter

ODS Layout for RTF – A custom tagset, Richard A. DeVenezia

The DoW-Loop Unrolled, Paul M. Dorfman

PROC_CODEBOOK, Automating the Review and Documentation of SAS® Files, James Terry

Coders’ Corner

A View Toward Performance, Ed Heaton

Using SAS® to Produce Report-Ready Summaries of Likert-Type Survey Data: PROC TABULATE, Output Delivery System, PROC TEMPLATE, Imelda Go

Recoding “ALL THAT APPLY” Variables from Handhelds and Portable Computers, Wafa Handley, Barbara Bibb, Lilia Filippenko, Jay Levinsohn, Donna Medeiros

Making Sense of Census Data, Robert S. Matthews

By Your Command: Executing Windows DLLs from SAS® Enterprise Guide, Darryl Putnam

How to run an error check to stop SAS®, Dan Blanchette

%RESTRUCT – SAS® macro with Proc Univariate, Milorad Stojanovic

IF and %IF You Don’t Understand, Ian Whitlock

Automation of Data Updates: A Case Study, Carry Croghan

Using DICTIONARY Views to Eliminate Tedious Visual Review, Christine Davies

Application Dispatcher: Some Tweaks and Tricks, Carol Martell

SAS® TIPS FOR INSTITUTIONAL RESEARCHERS TO TRACK STUDENT OUTCOMES EFFICIENTLY, Vijayalakshmi Sampath

Bars and Lines: A Quick Introduction to PROC GBARLINE, Garland D. Maddox

Which Job Sent *THAT* Error Message – How to Generate a Lookup List From Your Metadata, Robert Janka

Your Friendly Neighborhood Webcrawler: A Guide to Crawling the Web with SAS®, James Cox

SAS® Abbreviations Are Your Friends; Use a Template Method to Code!, Elizabeth Ceranowski

Foundations and Fundamentals

Take Control: Understanding and Controlling Your Do-Loops, Sarah A. Woodruff, Toby Dunn

Building the Better Macro: Best Practices for the Design of Reliable, Effective Tools, Frank DiIorio

The Data Step; Your Key To Successful Data Processing In SAS®, Don Kros

SAS® Formats: Effective and Efficient, Harry Droogendyk

Fun with Functions, Yogini Thakkar

Merging into Hash: Some Practical Examples of Converting MERGE Statements into Hash Objects, Ying Liu

The MEANS/SUMMARY Procedure: Getting Started, Art Carpenter

Leave Your Bad Code Behind: 50 Ways to Make Your SAS® Code Execute More Efficiently, William E. Benjamin Jr

Know What Your Business Client Wants: An Introduction to how analytics is used to understand loyalty program in the hospitality industry, Tracy Li-moshenko

It’s Five O’Clock Somewhere!!! Handling Dates And Times In SAS®, Toby Dunn, Sarah A. Woodruff

Evolve from a Carpenter’s Apprentice to a Master Woodworker: Creating a Plan for Your Reports and Avoiding Common Pitfalls in REPORT Procedure Coding, Allison Booth

SAS® Programmer’s Paradise: New Goodies in SAS® Enterprise Guide® 4.3, Stephen Slocum

Point-and-Click Programming Using SAS® Enterprise Guide®, Mira Shapiro, Kirk P. Lafler

Hands-On Workshops

Statistical Analysis – The First Steps, Jennifer Waller

Macro Quoting – How and Why, Ian Whitlock

PROC TABULATE: Doing More, Art Carpenter

SAS/GRAPH® Elements You Should Know – Even If You Do Not Use SAS/GRAPH®, Art Carpenter

Two Guys on Hash, Paul M. Dorfman, Peter Eberhardt

How To Use Proc SQL select into for List Processing, Ronald Fehd

Traffic Lighting Your Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS®, Vince DelGobbo

Planning and Support

If you Have Programming Standards, Please Raise Your Hand: An Everyman’s Guide, Dianne Louise Rhodes

If You Can’t Learn It From A Book, Why Are You Reading This?, Steve Noga

At Your Service: Your Roadmap to Support from SAS®, Kathy Council

SAS-L and Beyond, Joe Kelley

Posters

Using SAS® to Examine Missing Data in Psychometric Research, JoAnne Herman, Elizabeth Register, Abbas Tavakoli

SAS® Maps as Tools to Display and Clarify Healthcare Outcomes, Barbara B. Okerson

LAG Function Combined with Conditional Functions – Useful in Identifying Differences in Like Data, Andrew Hummel

Solving Kenken Puzzles – By Not Playing, John R. Gerlach

ES_ANOVA: A SAS® Macro for Computing Point and Interval Estimates of Effect Sizes Associated with Analysis of Variance Models, Jeffrey D. Kromrey, Bethany A. Bell

How to Monitor “Don’t Know” and “Refusal” Non-responses in a Large National Survey – Using Simple SAS® Macros, a Few PROCs, and Data Steps., Mariah Cheng, Timothy Monbureau

Proc Report Data = Subject.Event_Chronology;, Christina Carty, Elizabeth Spence

TIPS AND TRICKS OF EFFICIENT SAS® PROGRAMMING FOR SDTM DATA, Eric Qi, Fikret Karahoda

Guide to ODS Graphics Editor in SAS® 9.2, Mirjana Stojanovic

Customizing Saved Proc Import Code, Carolyn D. Williams

Fitting multivariate random-effects models using SAS® PROC GLIMMIX, Lei Li

A SAS/AF® Application for Organizing the Data Management Activities of the CHIMES Follow Up Study, Emily A. Mixon, Valisa R. Brown, Karen B. Fowler
Technique of Using PROC SQL, Hui-Ping Chen

Analysis and Visual Review of Error Matrices in SAS® Stat Studios, Robert Seffrin

Sample Size Calculation to Evaluate Mediation Analysis, Rajendra Kadel

Developing a Telco Revenue Forecasting and Device Optimization Analytics Tool, Lan Guan

The SAS® User Group Community Activity, Don Kros

Using Dictionary Tables to Explore SAS® Datasets, Phillip Julian

Reporting and Information Visualization

Business intelligence 2.0: Are we there yet?, Greg Nelson

Using Linux Shell Commands, vi Editor, and Base SAS® to Parse through Log Files and Gather Log-information, Fuad J. Foty

Distance mapping in health and health care: SAS® as a tool for health geomatics, Barbara B. Okerson

SAS® Proc Report and ODS ExcelXP Tagsets to Produce Customized Excel Output Without DDE, Mira Shapiro

ODS RTF TEXT My New Best Friend!, Brian Spruell

SBSBOXPLOT: A SAS® Macro for Generating Side-by-Side Boxplots, Jason A. Schoeneberger, Grant B. Morgan, Bethany A. Bell

Yes! SAS® ExcelXP WILL NOT Create a Microsoft Excel® Graph; But SAS® Users Can Command Microsoft Excel® to Automatically Create Graphs From SAS® ExcelXP, William E. Benjamin Jr

Geocoding Crashes in Limbo, Carol Martell, Daniel Levitt

Producing Maps Using SAS® Enterprise Guide®, Harmon L. Jolley

Model Visualization Using JMP®, SAS®, and Excel, Jon Weisz

The Systems Development Life Cycle (SDLC) as a Standard: Beyond the Documentation, Dianne Louise Rhodes

Introduction to Graphics Using SAS/GRAPH® Software, Mike Kalt

Statistics and Data Analysis

A Taste of ADaM, Beilei Xu, Changhong Shi

Detecting Medicaid Data Anomalies Using Data Mining Techniques, Aran J. Canes, Qiling Shi, Shenjun Zhu

SAS® Macros for Estimating the Attributable Benefit of an Optimal Treatment Regime, Jason S. Brinkley

Potential Change in Reliability Measures Based on Decreased Sample Size for the Census Coverage Measurement Survey, Vincent T. Mule

A SAS® Macro to Compute Added Predictive Ability of New Markers Predicting a Dichotomous Outcome, Kevin Kennedy, Michael Pencina

Using SAS® Text Miner 4.1 to create a term list for patients with PTSD within the VA, Matthew R. Richardson, Stephen L. Luther, Donald Berndt

A Macro for Calculating Summary Statistics on Left Censored Environmental Data using the Kaplan-Meier Method, Dennis J. Beal

Using SAS® PROC CLUSTER to Determine University Benchmarking Peers, Elayne Reiss, Sandra Archer, Robert L. Armacost, Ying Sun, Yun Fu

Developing a Model for Person Estimation in Puerto Rico for the 2010 Census Coverage Measurement Program, Colt S. Viehdorfer

Stationarity Testing in High Frequency Seasonal Time Series, David A. Dickey

The Graph Template Language and the Statistical Graphics Procedures – An Example-Driven Introduction, Warren Kuhfeld

Take a Whirlwind Tour Around SAS® 9.2, Diane Hatcher

The Next Generation: SAS/STAT® 9.22, Phil Gibbs