SESUG Proceedings 2013

These Proceedings are the official record of the 21th Annual SouthEast SAS Users Group (SESUG) Conference held in St. Pete Beach, FL on October 20–23, 2012 at the TradeWinds Island Grand. 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 2013: The Proceedings of the SouthEast SAS Users Group, St. Pete Beach, FL, 2013

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

Back to Basics

Ten Things You Should Know About PROC FORMAT, Jack Shoemaker

Tailoring Proc Summary for More Efficient Summarizations, Bill Parman

Basketball Analytics: Optimizing the Official Basketball Box-Score (Play-by-Play), William Cade

A Few Usefull Tips When Working with SAS®, Milorad Stojanovic

Help! I Need to Report a Crime! Why is PROC REPORT So Hard to Use?, Dessa Overstreet

Repetitive Tasks and Dynamic Lists: Where to Find What You Need and How to Use It, Richard Addy

Chi-Square and T-Tests Using SAS®: Performance and Interpretation, Jennifer Waller and Maribeth Johnson

Transitioning from Batch and Interactive SAS to SAS Enterprise Guide, Brian Varney

A Quick and Gentle Introduction to PROC SQL, Shane Rosanbalm and Sam Gillett

Lost in Translation: A Statistician’s (Basic) Perspective of PROC LIFETEST, Alexandra Buck

Going from Zero to Report Ready with PROC TABULATE, Rachel Straney

Submitting SAS® Code on the Side, Vince DelGobbo

Data Entry in SAS® Strategy Management: A New, Better User (and Manager) Experience, David Shubert

Looking for an Event in a Haystack?, Maya Barton and Rita Slater

Beyond the Basics

5 Simple Steps to Improve the Performance of your Clinical Trials Table Programs using Base SAS® Software, Sally Walczak

Data Review Information: N-Levels or Cardinality Ratio, Ronald Fehd

Data in the Doughnut Hole: Using SAS® to Report on What is NOT There, Sarah Woodruff

EG and SAS: WORK-ing together, Bruce Albriton

Use SAS® to create equal sized geographical clusters of people, Josh Young

PEEKing at Roadway Segments, Carol Martell

Reading Data from Microsoft Word Documents: It’s Easier Than You Think, John Bentley

Your Opinion Counts: Using Twitter to Poll Conference Attendees, Peter Eberhardt and Matt Malczewski

Taming a Spreadsheet Importation Monster, Nat Wooding

Small Sample Equating: Best Practices using a SAS Macro, Anna Kurtz and Andrew Dwyer

Computing Counts for CONSORT Diagrams: Three Alternatives, David Abbott

Averaging Numerous Repeated Measures in SAS Using DO LOOPS and MACROS: A Demonstration Using Dietary Recall Data, Kendra Jones and Kyla Shelton

A Novel Approach to Code Generation for Data Validation and Editing using Excel and SAS, Mai Nguyen, Katherine mason and Shane Trahan

Same Data Different Attributes: Cloning Issues with Data Sets, Brian Varney

Finding the Gold in your Data – an Introduction to Data Mining, David Dickey

List Processing With SAS: A Comprehensive Survey, Jiangtang Hu

Black Belt

Solving Samurai Sudoku Puzzles – A First Attempt, John R Gerlach

Pre-conference seminar: Advanced Macro Design, Ronald Fehd

Big Data in the Warehouse – Quality is King and SAS Can Do It All, Ted Shelly

Binning Bombs When You’re Not a Bomb Maker: A Code-Free Methodology to Standardize, Categorize, and Denormalize Categorical Data, Troy Martin Hughes

Introducing the New ADAPTIVEREG Procedure for Adaptive Regression, Weijie Cai

Hands On Workshops

SAS® Enterprise Guide® 5.1: A Powerful Environment for Programmers, Too!, Rupinder Dhillon

Know Thy Data: Techniques for Data Exploration, Andrew Kuligowski and Charu Shankar

A Row is a Row is a Row, or is it? A Hands-on Guide to Transposing Data, Christianna Williams

How To DOW, Paul Dorfman

How to Use ARRAYs and DO Loops: Do I DO OVER or Do I DO i?, Jennifer Waller

Introduction to Interactive Drill Down Reports on the Web, Michael Sadof and Louis Semidey

The Armchair Quarterback: Writing SAS® Code for the Perfect Pivot (Table, That Is), Peter Eberhardt

Extend the Power of SAS® to Use Callable VBS and VBA Code Files Stored in External Libraries to Control Excel Formatting Routines, William Benjamin

Give the Power of SAS® to Excel Users Without Making Them Write SAS Code, William Benjamin

Planning and Administration

Survey of Big Data Solutions using SAS(r) Technologies, Jack Shoemaker

Rebuilding SAS Web Application for Web Report Studio 4.3, Ranjit Singh

The Many Hats of a SAS Administrator: An Insider’s Guide on Becoming an Indispensable Asset in Your Organization, Jennifer Parks

The Hitchhiker’s Guide to Github: SAS Programming Go Social, Jiangtang Hu

Your Analytics project is going to fail… Ask me why, Adam Hood and Martin Young

A Practical Approach to Process Improvement Using Parallel Processing, Viraj Kumbhakarna

Parallel processing techniques for performance improvement for SAS processes: Part II, Viraj Kumbhakarna

I heart SAS Users, Joanne Ellwood

The Disk Detective: A Tool Set for Windows SAS© Administrators, Darryl Putnam

A Hitchhiker’s guide for performance assessment & benchmarking SAS® applications, Viraj Kumbhakarna

Increasing College Tuition and Its Impacts on Student Loans, Harjanto Djunaidi and Monica Djunaidi

SAS Enterprise Business Intelligence Deployment Projects in the Federal Sector, Jenni Parks

Reporting and Information Visualization

Analytical modeling and content analysis mapping with SAS, Nancy Landreville

Not Enough Time To Catch Extreme Observations? Flag and Report with Macros and Arrays, Jamelle Simmons

Automating Visual Data Mining Using Bihistograms, the SAS Annotate Facility and SAS Macros, Forrestt Severtson

Seven Steps to a SAS EBI Proof-of-Concept Project, Sheryl Weise

Seamless Dynamic Web (and Smart Device!) Reporting with SAS®, DJ Penix

Instant Disaggregation: Using the macro language to provide reports with parallel structure across different subsets of the data set, Daniel Ralyea

Case Study: Migrating an Existing SAS Process to Run on the SAS Intelligence Platform, Joseph Urbi

Mobile Reporting at University of Central Florida, Carlos Piemonti

Experiences in Using Academic Data for BI Dashboard Development, Evangeline Collado and Michelle Parente

Uncovering Patterns in Textual Data with SAS Visual Analytics and SAS Text Analytics, Meera Venkataramani

How to Replicate Excel Stacked Area Graphs in SAS, Sharon Avrunin-Becker

Creating ZIP Code-Level Maps with SAS®, Barbara Okerson

A Map is Just a Graph Without Axes, Nat Wooding

“Google-like” Maps in SAS, Darrell Massengill

SAS Macros to Produce Publication-ready Tables from SAS Survey Procedures, Emma Frazier, Shuyan Zhang and Ping Huang

Hospital Readmissions: Characteristics of readmits within 30 days and beyond 30 days, Daniel Clark, Pradeep Podila, Edward Rafalski and George Relyea


When Little Objective Data Are Available, Find Root Causes and Effects with Interrelationship Digraphs and JMP®, Melvin Alexander

From Raw Data to Beautiful Graph using JSL, Michael Hecht

I’m a SAS Programmer. Why should I JMP?, Barbara Okerson

Using JMP® Partition to Grow Decision Trees in Base SAS®, Mira Shapiro

Pharma and Healthcare

Coding For the Long Haul With Managed Metadata and Process Parameters, Mike Molter

Imputing Dose Levels for Adverse Events, John R Gerlach and Igor Kolodezh

Identifying patient characteristics towards reducing hospital readmissions: Propensity Score Matching using JMP Pro, Pradeep Podila, George Relyea and Daniel Clark

Patient Profile Graphs Using SAS®, Sanjay Matange

Using SAS to read, modify, copy, and create comments on a Case Report Form in .pdf format, John Fulda

The Baker Street Irregulars Investigate: Perl Regular Expressions and CDISC, Peter Eberhardt and Wei Liu

What Do Your Consumer Habits Say About Your Health? Using Third-Party Data to Predict Individual Health Risk and Costs, Satish Garla

Kaplan-Meier Analysis: A Practical Guide For Programmers, Madhi Saranadasa

Using the 7th Edition American Joint Committee on Cancer (AJCC) Cancer Staging Manual to Determine Esophageal Cancer Staging in SEER-Medicare Data, Johnita Byrd and Felix Fernandez

Survey of Population Risk Management Applications Using SAS(r), Jack Shoemaker

Statistics and Data Analysis

PROC SURVEYSELECT as a Tool for Drawing Random Samples, Taylor Lewis

A SAS Macro for Finding Optimal k-Means Clustering in One Dimension with Size Constraints, Fengjiao Hu and Robert Johnson

SAS® Macros CORR_P and TANGO: Interval Estimation for the Difference between Correlated Proportions in Dependent Samples, Pei-Chen Wu, Patricia Rodriguez de Gil, Thanh Pham, Diep Nguyen, Jeanine Romano, Jeffrey D. Kromrey and Eun Sook Kim

Using Predetermined Factor Structures to Simulate a Variety of Data Conditions, Kevin Coughlin, Jeffrey Kromrey and Susan Hibbard

Forecasting Enrollment in Higher Education using SAS Forecast Studio, Erik Bowe and Steven Merritt

Analyzing Multiway Models with ANOM Slicing, Peter Wludyka

Maximizing Confidence and Coverage for a Nonparametric Upper Tolerance Limit for a Fixed Number of Samples, Dennis Beal

Dealing with Missing Data for Credit Scoring, Steve Fleming

Evaluating the Accuracy Assessment Methods of a Thematic Raster through SAS® Resampling Techniques and GTL Visualizations, Robert Seffrin

Evaluating the Performance of the SAS® GLIMMIX Procedure for the Dichotomous Rasch model: A Simulation Study, Isaac Li, Yi-Hsin Chen and Jeffrey Kromrey

GEN_OMEGA2: A SAS® Macro for Computing the Generalized Omega-Squared Effect Size Associated with Analysis of Variance Models, Anh P. Kellermann, Jeanine Romano, Patricia Rodríguez de Gil, Than Pham, Patrice Rasmussen, Yi-Hsin Chen and Jeffrey D. Kromrey

Area under a Receiving Operating Characteristic (ROC) Curve: comparing parametric estimation, Monte Carlo simulation and numerical integration, Paulo Macedo

You like What? Creating a Recommender System with SAS, Wayne Thompson

An Intermediate Primer to Estimating Linear Multilevel Models using SAS® PROC MIXED, Bethany Bell, Whitney Smiley, Mihaela Ene, Phillip Sherlock, Jr. and Genine Blue

Modeling Categorical Response Data, Maura Stokes

Coder’s Corner

Let SAS® Do the Coding for You, Robert Williams

Format Follows Function: User-Written Formats and User-Written Functions that talk to the SAS Metadata Server, Philip Busby

Writing Macro Do Loops with Dates from Then to When, Ronald Fehd

Database Vocabulary: Is Your Data Set a Dimension (LookUp) Table, a Fact Table or a Report?, Ronald Fehd

Report Dates: %Sysfunc vs Data _Null_;, Bill Parman

Summarizing Character Variables Using SAS® Proc Report, Priya Suresh and Elizabeth Heath

Proc Compare – The Perfect Tool for Data Quality Assurance, Ted Shelly

The Power of Combining Data with the PROC SQL, Stacey Slone

Comparisons of SAS Mixed and Fixed Effects Modeling for Observed over Expected Count Outcomes in the Presence of Hierarchical or Clustered Data, Rachel E Patzer and Laura Plantinga

Selecting Earliest Occurrence: Watch Your Step, David Abbott

Handling data with multiple records per subject: 4 quick methods to pull only the records you want, Elizabeth Leslie

Fit Discrete Distributions via SAS Macro, Feng Liu

The BEST. Message in the SASLOG, Andrew Kuligowski

Array Applications in Determining Periodontal Disease Measurement, Liang Wei, Laurie Barker and Paul Eke

Automating Data Vetting Using SAS Macros, Forrestt Severtson

Using Arrays to Handle Transposed Data, Michael Leitson

How SAS Processes If-Then-Else Statements, Michael Leitson and Elizabeth Leslie

Don’t Get the Finger… You Know the FAT Finger Creating a Modular Report Approach using BASE SAS, Penny Eckert

PROC FORMAT in DATA Step mathematics, Elizabeth Schreiber

Using Heatmaps and Trend Charts to Visualize Kidney Recipients’ Post- Transplant Hospitalizations, Sebastian Perez

Resistance is Futile: SAS Enterprise Guide Assimilates PC SAS, Sheryl Weise

The Short-Order Batch, Carol Martell

How Many Licks to the Center of that Column?, Spencer Childress

Using SAS to calculate Modularity of a Graph for Community Detection Problems, Song Chen

Explore RFM approaches using SAS, Ruiwen Zhang


Using SAS to Examine Social Networking Difference between Faculty and Students, Abbas Tavakoli, Joan Culley, Hein Laura, Blake Frazier and Williams Amber

Getting Out of the PROC PRINT Comfort Zone to Start Using PROC REPORT, Imelda C. Go and Abbas S. Tavakoli

SAS Macros to Conduct Common Biostatistical Analyses and Generate Reports, Dana Nickleach, Yuan Liu, Adam Shrewsberry, Robert Steven Gerhard, Kenneth Ogan, Sungjin Kim and Zhibo Wang

Let the Code Report the Running Time, Zi Feng

Not just another macro, Y. Christina Song

SAS Web Editor, is it the right choice for you?, Rebecca Ottesen and Jamelle Simmons

Does the Percentage of College Student and Military Personnel Group Quarters Affect Political Contributions per Zip Code? Visualization with PROC GMAP, Jamelle Simmons

GLIMMIX_Rasch: A SAS® Macro for Fitting the Dichotomous Rasch Model, Yi-Hsin Chen, Isaac Li and Jeffrey Kromrey

POSTEQUATE: A SAS® Macro for Conducting Non-IRT Test Post-equating, Isaac Li and Jeffrey Kromrey

Analytical Approach for Bot Cheating Detection in a Massive Multiplayer Online Racing Game, Andrea Villanes Arellano

Role of Fibrinogen, HDL Cholesterol and Cardio Respiratory Fitness in Predicting Mortality Due to Cardio-vascular Disease: Results From the Aerobics Center Longitudinal Study, Srinivasa Madhavan, Steven Blair and Abbas Tavakoli

Comparing PROC MI and IVEWare callable software, Bruno Vizcarra and Amang Sukasih

Winning the War on Terror with Waffles: Maximizing GINSIDE Efficiency for Blue Force Tracking Big Data, Troy Martin Hughes

Stock Prices Analysis, Dhanashree Gadkari


ISO 101: A SAS® Guide to International Dating, Peter Eberhardt and Xiao Jin Qin

RUN_MACRO Run! With PROC FCMP and the RUN_MACRO Function from SAS® 9.2, Your SAS® Programs Are All Grown Up, Dylan Ellis