SESUG Proceedings 2015

These Proceedings are the official record of the 23rd Annual SouthEast SAS Users Group (SESUG) Conference held in Savannah, GA on September 27-29, 2015 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 2015: The Proceedings of the SouthEast SAS Users Group, Savannah, GA, 2015

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 © 2015 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 Development

Integrating Microsoft® VBScript and SAS®, Christopher Johnson

Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques, Kirk Paul Lafler

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

Programming Compliance Made Easy with a Time Saving Toolbox, Patricia Guldin

Masking data to obscure confidential values: a simple approach, Bruce Gilsen

SAS/GRAPH® and ANNOTATE Facility – More Than Just a Bunch of Labels and Lines, Mike Hunsucker

One SAS® To Rule Them All …, William “Gui” Zupko II

Unlock SAS® Code Automation with the Power of Macros, William “Gui” Zupko II

Automating Simulation Studies with Base SAS® Macros, C. Vincent Hunter

Rapidly Assessing Data Completeness, David H. Abbott

The Perfect Marriage: Using SAS® Enterprise Guide, the SAS® Add-In for Microsoft Office, and Excel to support enrollment forecasting at a large university, Andre Watts

You’ve Got Mail®: Automating SAS® from an Email, Peter P. Davis

Greenspace: A Macro to Improve a SAS® Data Set Footprint, Brian Varney

SAS® Data Integration Studio – Take Control with Conditional & Looping Transformations, Harry Droogendyk

A Methodology for Truly Dynamic Prompting in SAS® Stored Processes, Haikuo Bian

Using PROC SURVEYSELECT: Random Sampling, Raissa Kouadjo Bordenave

Data Labs with SAS® and Teradata: Value, Purpose and Best Practices, Bob Matsey

Banking and Finance

Getting Your SAS® Program to do Your Typing for You!, Nancy K. Wilson

Migrating Databases from Oracle to Teradata, Phillip Julian

Reducing Credit Union Member Attrition with Predictive Analytics, Nate Derby

Population Stability and Model Performance Metrics Replication for Business Model at SunTrust Bank, Bogdan Gadidov

Analysis of the Impact of Federal Funds Rate Change on US Treasuries Returns using SAS, Svetlana Gavrilova

Regulatory Stress Testing – A Manageable Process with SAS®, Wei Chen

Building Blocks

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

Better Metadata Through SAS® II: %SYSFUNC, PROC DATASETS, and Dictionary Tables, Louise Hadden

Removing Duplicates Using SAS®, Kirk Paul Lafler

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

Hash: Is it Always the Best Solution?, David Izrael and Elizabeth Axelrod

Hash Objects for Everyone, Jack Hall

A Beginner’s Babblefish: Basic Skills for Translation Between R and SAS®, Sarah Woodruff

Using the SAS® Hash Object with Duplicate Key Entries, Paul M. Dorfman

No FREQ-in Way, Renee Canfield

Sampling in SAS ® using PROC SURVEYSELECT, Drew Doyle; Rachael Becker

PROC TRANSPOSE: Flip your Data 90o and Save Time, Rachel Straney

Table Lookups: Getting Started With Proc Format, John Cohen

Arrays – Data Step Efficiency, Harry Droogendyk

Don’t Forget About Small Data, Lisa Eckler

To Macro or Not … that is the Question, Claudine Lougee

A Survey of Some of the Most Useful SAS® Functions, Ron Cody

Introduction to SAS® Data Loader: The Power of Data Transformations in Hadoop, Keith Renison

Coders Corner

Date Dimension, Christopher Johnson

RUN; RUN; RUN; – Methods for Running Multiple Programs in a Series, Robert Matthews

Count the number of delimiters in the input file, Kannan Deivasigamani

Running Parts of a SAS® Program While Preserving the Entire Program, Stephen Sloan

The Mystery of Automatic Retain in a SAS® Data Step, Huei-Ling Chen, Hong Zhang and Patricia Guldin

Tips for Identifying Patient Characteristics Associated with Diagnostic Concordance between Two Measures Using SAS®, Seungyoung Hwang

All Data Are (Most Likely) Not Created Equal: A SAS® Macro to Compare Structure and Data Across Multiple Datasets, Jason L. Salemi

Implementing a Bayesian Approach to Record Linkage, Lynn Imel and Vincent Thomas Mule, Jr.

PROC CATALOG, the Wish Book SAS® Procedure, Louise Hadden

Document and enhance your SAS® code, data sets, and catalogs with SAS® functions, macros and SAS® metadata, Roberta Glass and Louise Hadden

Beautiful PROC CONTENTS Output Using the ODS Excel Destination, Suzanne Dorinski

Using MULTILABEL Formats in SAS® to Analyze Data Over Moving Periods of Time, Christopher M. Aston

Having a Mean Headache on Summary Data? Using SAS® to Compute Actual Data from Summary Data, William “Gui” Zupko II

29 Shades of Missing, Darryl Putnam

Merging and Analysis of Complex Survey Data Sets by using Proc Survey Procedures in SAS®, Nushrat Alam

The %LetPut Macro, and Other Proactive Macro Debugging Techniques, Shane Rosanbalm

Where do the titles or footnotes go when using PROC SGPLOT in ODS PDF?, Julie Liu

The COMPRESS Function: Hidden Superpowers, Pamela L. Reading

Because We Can: Using SAS® System Tools to Help Our Less Fortunate Brethren, John Cohen

A macro to copy, rename, update and move your SAS® programs- all in one click, Julio Ruiz

Title: Using PROC MEANS to summarize months of eligibility for Medicaid beneficiaries, John Wedeles and Colleen Sonosky

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

Past, Present, and Future… who KNEW (Knows New Exciting Ways)?, Claudine Lougee

IA_CTT: A SAS® Macro for Conducting Item Analysis Based on Classical Test Theory, Chen Yi-Hsin

Accessing and Extracting Unstructured XML Data using SAS and Python, Sai Mandagondi

Successful Ways to Add and Drop Data, While Also Reformatting Data, Adetosoye Oladokun

Hands On Workshops

Quick Results with SAS® Enterprise Guide®, Kirk Paul Lafler

Application Development Techniques Using PROC SQL, Kirk Paul Lafler

How to DoW, Paul M. Dorfman

Applications Design and Development, a case study of the EDA Summarize-Each-Variable Suite, Ronald J. Fehd

Introduction to ODS Graphics, Chuck Kincaid

Intermediate SAS® ODS Graphics, Chuck Kincaid

A Tutorial on the SAS® Macro Language, John J. Cohen

An Introduction to Perl Regular Expressions, Ron Cody

Pharma and Healthcare

Multilevel Randomization, Marina Komaroff and Lois Lynn

A Descriptive Analysis of Reported Health Issues in Rural Jamaica, Verlin Joseph

ANOVA_Robust: A SAS® Macro for Various Robust Approaches to Testing Mean Differences in One-Factor ANOVA Models, Thanh V. Pham, EunSook Kim, Diep T. Nguyen, Yan Wang, Jeffrey D. Kromrey, and Yi-Hsin Chen

How to Build Study Quality Surveillance for a Clinical Study?, Angela Teng

Creating Quartiles from Continuous Responses: Making Income Data Manageable, Michelle M. Dahnke and Tyra Dark

Same Question, Different Name: How to Merge Responses, Michelle M. Dahnke and Tyra Dark

Using SAS ® Programing to Identify Super-utilizers and Improve Healthcare Services, An-Tsun Huang

Prescription Opioid Use in the U.S. in 2012: Characterizing Sustained vs. Infrequent Use Using the Medical Expenditure Panel Survey, Monika C. Lemke

Planning, Support and Administration

A Review of “Free” Massive Open Online Content (MOOC) for SAS® Learners, Kirk Paul Lafler

Google® Search Tips and Techniques for SAS® Users, Kirk Paul Lafler and Charles Edwin Shipp

Differentiate Yourself, Kirk Paul Lafler

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

Tips and Tricks for Introductory Workshops in SAS® for Health Professionals, Jason Brinkley

Supporting SAS in the Workplace: A Corporate SAS User Community, Barbara B. Okerson and Jennifer Harney

When Bad Things Happen to Good SAS® Programmers, Jiangtang Hu, d-Wise

Handling Sticky Situations – The Paper, Stephanie R. Thompson

Get cozy with your data sources using LSF queue technology: One LSF Cluster to Rule them All, Steven B. Garrison, Sr.

Tips and Tricks for Organizing and Administering Metadata, Michael G. Sadof

UCF SAS® Visual Analytics: Implementation, Usage, and Performance, Scott A. Milbuta, Carlos Piemonti and Ulf Borjesson

Predictive Modeling Using SAS Visual Statistics: Beyond the Prediction, Xiangxiang Meng, Wayne Thompson, and Jennifer Ames

A Health Analytics Framework, Krisa Tailor and Jeremy Racine

The Power of DS2 Programming, Bob Matsey and Tho Nguyen

Posters

Multifunctional SAS Macro for Fold Rise Calculation in Immunogenicity Analysis, Yan Liu

Maintaining a ‘Look and Feel’ throughout a Reporting Package Created with Diverse SAS® Products, Barbara B Okerson

Using SAS to Examine Health-Promoting Life Style Activities of Upper Division Nursing Students at USC, Abbas S. Tavakoli and Mary Boyd

Reporting of treatment emergent adverse events based on pooled data Analysis or Country Specific Submissions: A case study, Sheetal Shiralkar

Automating Preliminary Data Cleaning in SAS®, Alec Zhixiao Lin

Using SAS® to Examine Health Effects of Intimate Partner Violence among HIV+ Women, Abbas S. Tavakoli, Sabra S. Custer, and Yu Min

Ouch, How did that get there? The pitfalls of merging., Nancy McGarry

A SAS® Macro to Investigate Statistical Power in Meta-analysis, Jin Liu and Fan Pan

Documentation as you go: aka Dropping Breadcrumbs, Elizabeth Axelrod

Many Tables, Short Turnaround: Displaying Survey Results Quickly and Efficiently, Rebecca V. Fink, David Izrael, Sarah W. Ball, and Sara M. A. Donahue

Using SAS® Macros to Split a Data Set into Several Output Files, Imelda C. Go

SAS® Macros for Constraining Arrays of Numbers, Charles D. Coleman

Time Series Analysis: U.S. Military Casualties in World War Two, Rachael Becker

Streamlining Medicaid Enrollment Reporting and Calculation of Enrollment Trends Using Macro and PROC Statements in SAS, Deniz Soyer

PROG REG: A SAS® Macro to Determine Cut Score for a Universal Pre-School Maladaptive Screener, Fan Pan, Yin Burgess, Jin Liu, and Christine DiStefano

Reporting and Information Visualization

Layout the Grid and you control the document: ODS meets OOP and you reap the benefits., Daniel Ralyea and Karen Price

Text Analytics Using JMP®, Melvin Alexander

How to Make a Stunning State Map Using SAS/Graph® for Beginners, Sharon Avrunin-Becker

PROC RANK, PROC SQL, PROC FORMAT and PROC GMAP Team Up and a (Map) Legend is Born!, Christianna Williams and Louise Hadden

Plots to Assess Relationships between Before and After Treatment Change in Clinical Outcomes and Biomarkers with SAS SG Procedures and Graph Template

Language., Neeta Shenvi and Amita Manatunga

Bridging the Gap: Importing Health Indicators Warehouse Data into SAS® Visual Analytics using Stored Processes and APIs, Li-Hui Chen, Manuel Figallo, and Josh McCullough

How to Become the MacGyver of Data Visualizations, Tricia Aanderud

Design of Experiments (DOE) Using JMP® and SAS®, Charles E. Shipp

The Last Axis Macro You’ll Ever Need, Shane Rosanbalm

How We Visualize Data and How to Apply Those Findings in SAS® Visual Analytics., Ryan Kumpfmiller

A Journey from data to dashboard: Visualizing the university instructional classroom utilization and diversity trends with SAS® Visual Analytics, Shweta Doshi and Julie Davis

From SAS® Data to Interactive Web Graphics Built Through PROC JSON, Robert Seffrin

Key Features in ODS Graphics for Efficient Clinical Graphing, Yuxin (Ellen) Jiang

Take Your Data Analysis and Reporting to the Next level by Combining SAS® Office Analytics, SAS® Visual Analytics and SAS® Studio, David Bailey and Casey Smith

Creating Geographic Rating Area Maps: How to Combine Counties, Split Counties, and use Zip Code Boundaries, Rick Andrews and Robert Allison

Statistics and Data Analytics

Alternative methods of regression when OLS is not right, Peter Flom

Introducing Two-Way and Three-Way Interactions into the Cox Proportional Hazards Model Using SAS®, Seungyoung Hwang

Comparing Results from Cox Proportional Hazards Models using SUDAAN® and SAS® Survey Procedures to a Logistic Regression Model for Analysis of

Influenza Vaccination Coverage, Y. Zhai, K.E. Kahn, A. O’Halloran and T.A. Santibanez

Optimizing Pilot Connection Time Using PROC REG and PROC LOGISTIC, Andy Hummel and Shevawn Christian

Adaptive Fractional Polynomial Modeling in SAS®, George J. Knafl

Integrating PROC REG and PROC LOGISTIC for Collinearity Examination, Sample Scoring and Model Evaluation, Alec Zhixiao Lin

How to be a Data Scientist Using SAS®, Charles Kincaid

Confidence Intervals for Binomial Proportion Using SAS®: The All You Need to Know and No More, Jiangtang Hu

Behavioral Trajectories: An Analysis of Growth Patterns and Predictors of Changes from Preschool to First Grade, Jin Liu, Fan Pan, Yin Burgess, and Christine DiStefano

Probability Density for Repeated Events, Bruce Lund

A SAS® Algorithm for Imputing Discrete Missing Outcomes Based on Minimum Distance, Macaulay Okwuokenye, Karl E. Peace and Jian-Ping Hsu

Where Did My Students Go?, Stephanie R. Thompson

A SAS® Macro for Improved Correlation Coefficient Inference, Stephen W. Looney

Using SAS® to Create an Effect Size Resampling Distribution for a Statistical Test, Peter Wludyka

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

An Intermediate Guide to Estimating Multilevel Models for Categorical Data using SAS® PROC GLIMMIX, Whitney Smiley, Elizabeth Leighton, Zhaoxia Guo, and Mihaela Ene

An Empirical Comparison of Multiple Imputation Approaches for Treating Missing Data in Observational Studies, Yan Wang, Seang-Hwane Joo, Patricia Rodríguez de Gil, Jeffrey D. Kromrey, Rheta E. Lanehart, Eun-Sook Kim, Jessica Montgomery, Reginald Lee, Chunhua Cao, and Shetay Ashford

Can Fit Indices Yielded from the SAS® GLIMMIX Procedure Select the Accurate Q-matrix?, Yan Wang, Yi-Hsin Chen, Isaac Y. Li, and Chunhua Cao

High-Performance Procedures in SAS® 9.4: Comparing Performance of HP and Legacy Procedures, Jessica Montgomery, Sean Joo, Anh Kellermann, Jeffrey D. Kromrey, Diep T. Nguyen, Patricia Rodriguez de Gil, and Yan Wang

Regression Analysis of the Levels of Chlorine in the Public Water Supply in Orange County, FL, Drew Doyle

MIXED_RELIABILITY: A SAS Macro for Estimating Lambda and Assessing the Trustworthiness of Random Effects in Multilevel Models, Jason A. Schoeneberger and Bethany A. Bell

How Latent Structure Analysis Can Improve the Fit of a Regression Model, Deanna Schreiber-Gregory