SESUG Proceedings 2016

These Proceedings are the official record of the 24th Annual Southeast SAS Users Group (SESUG) Conference held in Bethesda, MD on October 16-18, 2016 at the Bethesda North Marriott Hotel and Conference Center. 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 2016: The Proceedings of the Southeast SAS Users Group, Bethesda, MD, 2016

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

Application/Macro Development

Creating Viable SAS® Data Sets From Survey Monkey® Transport Files, John R. Gerlach

Universal File Flattener, David Vandenbroucke

%SUBMIT_R: A SAS® Macro to Interface SAS and R, Ross Bettinger

New Game in Town: SAS® Proc Lua with Applications, Jiangtang Hu

Multiple Studies! DataDefinitionTracker, Made Easy!, Saritha Bathi

Breaking up (Axes) Isn’t Hard to Do: An Updated Macro for Choosing Axis Breaks, Alex Buck

A Waze App for Base SAS®: Automatically Routing around Locked Data Sets, Bottleneck Processes, and Other Traffic Congestion on the Data Superhighway, Troy Hughes

Moving Data and Results Between SAS® and Microsoft Excel, Harry Droogendyk

Using PROC FCMP for Short Test Assembly, Tsung-hsun Tsai; Yung-chen Hsu\

All Aboard! Next Stop is the Destination Excel, William E Benjamin Jr

The Demystification of a Great Deal of Files, Chao-Ying Hsieh

Building Blocks

The Power of PROC FORMAT, Jonas Bilenas; Kajal Tahiliani

An Introduction to SAS® Hash Programming Techniques, Kirk Paul Lafler

Building a Better Dashboard Using Base-SAS® Software, Kirk Paul Lafler

Fuzzy Matching: Where Is It Appropriate and How Is It Done? SAS® Can Help., Stephen Sloan; Dan Hoicowitz

Array Programming Basics, John Cohen

AutoHotKey: an Editor-independent Alternative to SAS® Keyboard Abbreviations, Shane Rosanbalm

SAS® Debugging 101, Kirk Paul Lafler

If you need these OBS and these VARS, then drop IF and keep WHERE., Jayanth Iyengar

Dynamically Changing Time Zones and Daylight Savings on Time Series Data, Chao-Ying Hsieh

Divide & Conquer: Simple Sub-Data Sets Creation with Call Execute, Dylan Holt; Wilhelmina Ross

An Easy Route to a Missing Data Report with ODS+PROC FREQ+A Data Step, Mike Zdeb

PROC DATASETS; The Swiss Army Knife of SAS® Procedures, Michael Raithel

True is not False: Evaluating Logical Expressions, Ronald Fehd

Creating Test Data Using SAS® Hash Tables

Using PROC EXPAND to Easily Manipulate Longitudinal and Panel Data, Matthew Hoolsema

Handling Numeric Representation SAS® Errors Caused by Simple Floating-Point Arithmetic Computation, Fuad Foty

Writing Code With Your Data: Basics of Data-Driven Programming Techniques, Joe Matise

Taming the Bear – Make Your Programs Easier to Control and Monitor, Bob Bolen

Introduction to PROC REPORT, Kirk Paul Lafler

Introduction to ODS Statistical Graphics, Kirk Paul Lafler


Using SAS®/QC to Design Optimal Experimental Designs in Consumer Lending., Jonas Bilenas

Using Regression Splines in SAS® STAT Procedures, Jonas Bilenas; Nish Herat

Leads and Lags: Static and Dynamic Queues in the SAS® DATA STEP, Mark Keintz

From Stocks to Flows: Using SAS® HASH objects for FIFO, LIFO, and other FO’s, Mark Keintz

Computing Risk Measures for Cross Collateralized Loans Using Graph Algorithms, Chaoxian Cai

Know your Interest Rate, Anirban Chakraborty

Coder’s Corner

WAPTWAP, but remember TMTOWTDI, Jack Shoemaker

What Do You Mean My CSV Doesn’t Match My SAS® Dataset?, Patricia Guldin; Young Zhuge

Using SAS® to Get a List of File Names and Other Information from a Directory in Microsoft® Windows, Imelda Go

PROC DOC III: Self-generating Codebooks Using SAS(R), Louise Hadden

A Five-Step Quality Control Method: Checking for Unintended Changes to SAS® Datasets, Aaron Brown

Talk to Me!, Elizabeth Axelrod

Extract Information from Large Database Using SAS® Array, PROC FREQ, and SAS Macro, Lifang Zhang

Tips for Pulling Data from Oracle® Using PROC SQL® Pass-Through, John Cohen

Converting Non-Imputed Partial Dates (for SDTM Data Sets) Using PROC FCMP, Noory Kim

Some _FILE_ Magic, Mike Zdeb

Personalized Birthday Wisher (PBW): An Indispensable SAS® Tool for Your Workplace, Jinson Erinjeri; Angela Soriano

Macro Code to Test Existence of Various Objects, Ronald Fehd

When PROPCASE Isn’t Proper: A Macro Supplement for the SAS® Function, Alex Buck

Using CALL VNAME to Populate Missing Data from a Default Values Lookup Dataset, Raghav Adimulam

Simplifying the Use of Multidimensional Array in SAS®, Alec Zhixiao Lin

Flexible Programming with Hash Tables, Joe Matise

Dynamically Setting Decimal Precision Using PUTN, Brandon Welch

Using SAS® Macros to Extract P-values from PROC FREQ, Rachel Straney

Your Own SAS® Macros Are as Powerful as You Are Ingenious, Yinghua Shi

Cover Your Assumptions with Custom %str(W)ARNING Messages, Shane Rosanbalm

From Professional Life to Personal Life: SAS® Makes It Easy, Nushrat Alam; Charlotte Baker

Using an Array to Examine Gastric and Colorectal Cancer Risk Factors, Verlin Joseph

Data Management/Big Data

Fuzzy Name-Matching Applications, Alan Dunham

Using Proc FCMP To Improve Fuzzy Matching, Christine Warner

Super Boost Data Transpose Puzzle, Ahmed Al-Attar

Using SAS® Hash Object to Speed and Simplify Survey Cell Collapsing Process, Ahmed Al-Attar

Removal of PII, Stanley Legum

What to Expect When You Need to Make a Data Delivery: Helpful Tips and Techniques, Tom McCall; Louise Hadden

Sorting a Bajillion Records: Conquering Scalability in a Big Data World, Troy Hughes

Spawning SAS® Sleeper Cells and Calling Them into Action: Implementing Distributed Parallel Processing in the SAS University Edition Using Commodity Computing To Maximize Performance, Troy Hughes

Your database can do complex string manipulation too!, Harry Droogendyk

Stress Testing and Supplanting the SAS® LOCK Statement: Implementing Mutex Semaphores To Provide Reliable File Locking in Multiuser Environments To Enable and Synchronize Parallel Processing, Troy Hughes


Using SAS® to Examine Relationships among Leadership Styles of College of Nursing Deans and Faculty Job Satisfaction Levels in Research Intensive Institutions, Abbas Tavakoli; Karen Worthy

Using SAS® to Examine the Relationship between Primary Caregivers’ Adverse Childhood Experiences (ACE) and Child Abuse Allegations, Abbas Tavakoli; Katherine Chappell; Senna Dejardins

Patients with Morbid Obesity and Congestive Heart Failure Have Longer Operative Time and Room Time in Total Hip Arthroplasty, Yubo Gao

The Power of Interleaving Data, Yu Feng

Formula 1: Analytics behind the tracks to the podium, Pallabi Deb and Piyush Lashkare

Privacy Protection using Base SAS®: Purging Sensitive Information from Free Text Emergency Room Data, Michelle White; Thomas Schroeder; Li Hui Chen; Jean Mah

Extracting Email Domains and Geo-Processing IP Addresses in SAS®, Alec Zhixiao Lin

The Orange Lifestyle, Sangar Rane; Mohit Singhi

Using SAS® to create a Build Combinations Tool to Support Modularity, Stephen Sloan

Strike a pose! Quick and Easy Camera Ready Reporting with SAS®, Nancy McGarry

A Failure to EXIST: Why Testing for Data Set Existence with the EXIST Function Alone Is Inadequate for Serious Software Development in Asynchronous, Multi-User, and Parallel Processing Enviro, Troy Hughes

SAS® Macro for Automated Model Selection Involving PROC GLIMMIX and PROC MIXED, Fan Pan; Jin Liu

A prediction model for which country will win the highest number of “Gold” in 2016, Antarlina Sen; Gaurang Margaj

Predicting student success based on interactions with virtual learning environment, Vivek Doijode; Neha Singh

Applying SAS® to Explore the Utilization and Impact of Sensitive Clinical Indicators on a Heart Failure Unit, Jametta Magwood-Golston; Abbas Tavakoli; Christina Payne; Harmony Robinson; Veronica Deas; Forrest Fortier

Text mining and sentiment analysis on video game user reviews using SAS® Enterprise Miner”, Mukesh Kumar Singh

Text Analysis of American Airline Reviews, Rajesh Tolety

Hands on Workshop

A Tutorial on the SAS® Macro Language. John Cohen

Making Sense of PROC TABULATE, Jonas Bilenas; Kajal Tahiliani

Fundamentals of the SAS® Hash Object, Paul Dorfman

New for SAS® 9.4: A Technique for Including Text and Graphics in Your Microsoft Excel Workbooks, Part 1, Vince DelGobbo

A Short Introduction to Longitudinal and Repeated Measures Data Analyses, Leanne Goldstein

Introduction to Data Simulation, Jason Brinkley

Quick Results with SAS® Enterprise Guide®, Kirk Paul Lafler; Mira Shapiro ; Ryan Paul Lafler

Life Sciences/Healthcare/Insurance

A Novel Approach to Calculating Medicare Hospital Readmissions for the SAS® Novice, Karen Wallace

Protecting the Innocent (and your data), Stanley Legum

Sankey Diagram with Incomplete Data – From a Medical Research Perspective, Yichen Zhong

How is Healthcare Cost Data Distributed? Using Proc Univariate to Draw Conclusions about Millions of Different Customers., Aran Canes

Are You Sure That Is Correct?: An Overview Of Good Practices For Dataset And Output Validation, Gregory Weller; Alex Buck
Evaluating Sociodemographic and Geographic Disparities of Hypertension in Florida using SAS®, Desiree Jonas; Shamarial Roberson

A General SAS® Macro to Implement Optimal N:1 Propensity Score Matching Within a Maximum Radius, Kathy Fraeman

I See de Codes: Using SAS® to Process and Analyze ICD-9 and ICD-10 Diagnosis Codes Found in Administrative Healthcare Data, Kathy Fraeman
SDTM What? ADaM Who? A Programmer’s Introduction to CDISC, Venita DePuy

Building Efficiencies in Standard Macro Library using Polymorphism, Binoy Varghese; Sagar Rana

Sample Size Estimation with PROC FREQ and PROC POWER, Adeline Wilcox


Tales from the Help Desk 7: Solutions to Common SAS® Tasks, Bruce Gilsen

What’s Hot – Skills for SAS® Professionals, Kirk Paul Lafler

Downloading, Configuring, and Using the Free SAS® University Edition Software, Kirk Paul Lafler

How To Win Friends and Influence People – A Programmer’s Perspective in Effective Human Relationships, Priscilla Gathoni

Take a SPA Day with the SAS® Performance Assessment (SPA): Baselining Software Performance across Diverse Environments To Elucidate Performance Placement and Performance Drivers, Troy Hughes

Your Local Fire Engine Has an Apparatus Inventory Sheet and So Should Your Software: Automatically Generating Software Use and Reuse Libraries and Catalogs from Standardized SAS® Code, Troy Hughes

Divide and Conquer – Writing Parallel SAS® Code to Speed Up Your SAS Program, Doug Haigh

Using JMP to apply Decision Trees and Random Forests as Screening Tools for Limiting Candidate Predictors in Regression Models, Jason Brinkley

Proc Report, the Graph Template Language, and ODS Layouts: Used in Unison to Create Dynamic, Customer-Ready PowerPoints, Amber Carlson; Amelia Stein; Xiaobin Zhou

Exploring JMP®’s Image Visualization Tools in Medical Diagnostic Applications, Melvin Alexander

Mapping Roanoke Island: from 1585 to present, Barbara Okerson

UCF Stored Process Conversion for Current STEM Retention Reports, Carlos Piemonti

Utilize SAS® 9 SGPLOT to Create Genome Wide Association Studies Plots, Huei-Ling Chen; Jialin Xu

Color Speaks Louder than Words, Jaime Thompson

Five Secrets for Building Fierce Dashboards, Tricia Aanderud

Make the jump from Business User to Data Analyst in SAS® Visual Analytics, Ryan Kumpfmiller

CMISS® the SAS® Function You May Have Been MISSING, Mira Shapiro

Creating a Publication Quality Graphic with SAS®, Charlotte Baker

SAS® Formats: Effective and Efficient, Harry Droogendyk

A Real World Example: Using the SAS® ODS Report Writing Interface to revamp South Carolina’s School District Special Education Data Profiles, Fred Edora

Building Interactive Microsoft Excel Worksheets with SAS® Office Analytics, Tim Beese

Enhanced Swimmer Plots: Tell More Sophisticated Graphic Stories in Oncology Studies, Ilya Krivelevich; Andrea Dobrindt; Simon Lin; Xiaomin He

Time-to-Degree Issue – Solution using Academic Analytics, Sivakumar Jaganathan; Thanuja Sakruti; Abhishek Uppalapati

Success Takes Balance, Don’t Fall Over With Your SAS® Visual Analytics Implementation, Ryan Kumpfmiller and Craig Willis

Diabetes Self-Management Education Programs in Florida, Adetosoye Oladokun; Rahel Dawit

Data Visualization Through 3-D Graphs Using SAS® Graph Template Language (GTL), Venu Perla

Annotating the ODS Graphics Way!, Dan Heath

Geospatial Analysis with SAS®, mike jadoo

Statistics/Data Analysis

Identifying Gaps in Time Series Data, Bruce Gilsen

Finding the Area of a Polygon… On a Sphere!, Seth Hoffman


Empowering Self-Service Capabilities with Agile Analytics, Tho Nguyen; Paul Segal

In the Pursuit of Balanced Groups: A SAS® Macro for an Adaptive Randomization Test, Tyler Hicks; Jeffrey Kromrey

Mixture Priors 101: Using SAS® to Obtain Powerful Frequentist Inferences with Bayesian Methods, Tyler Hicks; Jeffrey Kromrey

A Simple SAS® Macro to Perform Blinder-Oaxaca Decomposition, Taylor Lewis; Stanislas Ezoua
PROC LOGISTIC: Traps for the unwary, Peter Flom

Missing Data and Complex Sample Surveys Using SAS®: The Impact of Listwise Deletion vs. Multiple Imputation on Point and Interval Estimates when Data are MCAR and MAR, Anh Kellermann; DeAnn Trevathan; Jeffrey Kromrey

The HPSUMMARY® Procedure: A Younger (and Brawnier) Cousin to an Old SAS® Friend, Anh Kellermann; Jeffrey Kromrey

A Macro for Calculating Kendall’s Tau-b Correlation on Left Censored Environmental Data, Dennis Beal

Analyzing non-normal data with categorical response variables, Niloofar Ramezani; Ali Ramezani

A Data Mining Approach to Predict Student-at-risk, Youyou Zheng; Sivakumar Jaganathan; Thanuja Sakruti; Abhishek Uppalapati

Surviving the Interim: Insights Into Interim Survival Analyses, Venita DePuy

Statistical Model Building for Large, Complex Data: Five New Directions in SAS/STAT® Software, Robert Rodriguez