SESUG Proceedings 2017

These Proceedings are the official record of the 25th Annual SouthEast SAS Users Group (SESUG) Conference held in Cary, NC on November 5-7, 2017 at Embassy Suites and SAS Institute Headquarters. 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 2017: The Proceedings of the SouthEast SAS Users Group, Cary, NC, 2017

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 © 2017 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

Macros for creating a custom report of figures, Laura Williams

A SAS macro replacement for Dynamic Data Exchange (DDE) for use with SAS grid computing, Saki Kinney, David Wilson and Benjamin Carper

The %FRED Macro – Finding Risk in Education Data, Fred Edora

A Macro for Generating the Adverse Events Summary for ClinicalTrials.gov, Andrew Moseby and Maya Barton

SAS Macros for Time-Dependent Effects and Risk Factors on Survival: Quantile and Landmark Analysis, Chao Zhang, Manali Rupji and Jeanne Kowalski

Generating Reliable Population Rates Using SAS® Software, Jack Shoemaker

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

A Second Look at the ODS Destination for PowerPoint, Jane Eslinger

A macro of building predictive model in Proc Logistic with AIC-optimal variable selection embedded in cross-validation, Hongmei Yang and Andrea Maslow

Fuzzy Matching Programming Techniques Using SAS® Software, Stephen Sloan and Kirk Paul Lafler

Advanced project management, beyond Microsoft Project, using PROC CPM and Gantt and Advanced Graphics, Stephen Sloan and Lindsey Puryear

Detecting Outlying Data in Proficiency Studies with SAS, Stacey Slone

Ron Fehd, SAS-L’s Macro Maven, Answers Your Macro Questions, Ronald Fehd

Building Blocks

A Tutorial on the SAS® Macro Language, John Cohen

Joining Data in SAS – SQL or MERGE?, Harry Droogendyk

SAS® Survey Report Macro for Creating User-Friendly Descriptive Summaries, Tammiee Dickenson, Jessalyn Smith, Grant Morgan and William Zachary Smith

Table Lookups: Getting Started With Proc Format, John Cohen

Tired of CALL EXECUTE? Try DOSUBL, Jueru Fan

Automatic Verification of Combined Datasets, Marcus Maher and Joe Matise

Analysis of Tweets on Demonetization in India using SAS Enterprise Miner, Jital Patel and Narmada Panneerselvam

Building a Sequential Programs for a Routine Task with Five SAS Techniques, Gongmei Yu and Paul LaBrec

Tales from the Help Desk: Solutions to Common DATA Step Tasks, Bruce Gilsen

Beyond IF THEN ELSE: Techniques for Conditional Execution of SAS Code, Josh Horstman

Merge with Caution: How to Avoid Common Problems when Combining SAS Datasets, Josh Horstman

Using SAS® for Application Programming Interface Requests, Mike Jadoo

Using the Force of Python and SAS Viya on Star Wars Fan Posts, Grace Heyne

Unleash the Power of PROC REPORT With the ODS Excel Destination, Devi Sekar and Jean (Peggy) Hastie

One-to-one, One-to-many, and Many-to-many Joins Using PROC SQL, Charu Shankar and Kirk Paul Lafler

PROC IMPORT and more. Or: when PROC IMPORT just doesn’t do the job, David Horvath

Zen and the Art of Problem Solving, David Horvath

UCF Visual Analytics – Dataset Development for the Undergraduate Attrition Study, Scott Milbuta and Michelle Parente

Setting the Percentage in PROC TABULATE, David Franklin

SAS® Spontaneous Combustion: Securing Software Portability through Self-Extracting Code, Troy Hughes

SAS® and Hadoop: The 6th Annual State of the Union, Paul Kent

Challenges and Solutions for Handling Re-screened Subjects in SDTM, Charity Quick

Finding the Gold in Your Data: An Overview of Data Mining, Dave Dickey

Quality Control in SAS®: Checking Input, Work, and Output, Aaron Brown

Migrating from PC-SAS to SAS-Grid on Linux, Susan Myers, Rita Thissen and Inga Allred

Data Analysis and Storytelling – Communicating Analytical Results with Clarity, Precision and Efficiency, Kirk Paul Lafler

Old Age and Treachery vs. Youth and Skill: An Analysis of the Mean Age of World Series Teams, Joe DeMaio

Hash Beyond Lookups: Your Code Will Never be the Same!, Elizabeth Axelrod

Using SAS to Employ Propensity Score Matching in an Institutional Research Office to Create Matched Groups for Outcomes Analyses, Bobbie Frye and James Bartlett

Let SAS® Do Your DIRty Work, Richann Watson

SAS and the Voluntary Framework of Accountability: A Prime Example of the Use of SAS in Education, Kelly Smith, Bobbie Frye and Paul Earls

Coders Corner

Extracting Clinical Research Data from OnCore® and Preparing it for Statistical Analysis in SAS®, Chang Xu and Allison Deal

Automate Secure Transfers with SAS and PSFTP, Kyle Thompson and Ken Borowiak

Identifying and Removing Subjects with Duplicates in Long Data Format: A Simple Approach Using PROC SORT and PROC SQL, Szu-Fu Chao

An Introduction to Visit Window Challenges and Solutions, Mai Ngo

Identifying Semantically Equivalent Questions Using Singular Value Decomposition, Varsha Reddy Akkaloori

Format-o-matic: Using Formats To Merge Data From Multiple Sources, Marcus Maher and Joe Matise

Backward Variable Selection for Logistic Regression based on Percentage Change in Odds Ratio, Evan Kwiatkowski, Hannah Crooke and Kathy Roggenkamp

RETAINing YOUR SANITY: 5 IDEAS TO MANIPULATE DATA USING THE RETAIN STATEMENT, Matthew Taylor

Applying IFN and IFC Functions, Jinson Erinjeri and Saritha Bathi

ODS Basics, Mike Jadoo

Everyone can use a little Currency – when dependent data set updates silently make your analysis data set out of date., Scott Worrell

Creating a DOS Batch File to Run SAS® Programs, David Franklin

Dynamically Assigning Length to Transposed Variables, Ethan Ritchie

SAS ODS EXCEL Destination: Using the ID Option to Write Different Excel Workbooks at the same time., William E Benjamin Jr

SAS ODS EXCEL Destination: Using the STYLE Option to spruce up your Excel output workbook., William E Benjamin Jr

SAS ODS EXCEL Destination: Using the START_AT sub-option to place your data where you want it on the Excel Worksheet., William E Benjamin Jr

SAS Does Not Store Dates, Nat Wooding

A practical application of Vtable, Sumathi Subramaniam and Kannan Deivasigamani

Dictionary.columns is your friend while appending or moving data, Kiran Venna

Sending SAS® Data Sets and Output to Microsoft Excel®, Imelda Go

Advanced Programming Concepts: History of the List Processing and Cardinality Ratio Memes, Ronald Fehd

Data Management / Big Data

Reducing the space requirements of SAS data sets without sacrificing any variables or observations, Stephen Sloan

Statistician’s secret weapon: 20 ways of detecting raw data issues, Lixiang Liu

Data Quality Control: Preventing Information Loss Through High Performance Binning Procedures, Deanna Schreiber-Gregory

Guide to ETL Best Practices in SAS® Data Integration Studio, Sai Potluri and Ananth Numburi

ETL Load performance bench marking using different load transformations in SAS® Data Integration Studio., Sai Potluri

From Words to Actions: Using Text Analytics to Drive Business Decisions, Reid Baughman

From FREQing Slow to FREQing Fast: Facilitating a Four-Times-Faster FREQ with Divide-and-Conquer Parallel Processing, Troy Hughes

I spy PII: Detect, Protect and Monitor Personal Data with SAS® Data Management, Cecily Hoffritz

Data movement issues: Explicit SQL Pass-Through can do the trick, Kiran Venna

Identifying Duplicate Variables in a SAS ® Data Set, Bruce Gilsen

A Software Toolkit for Data Management, Kim Chantala, Jean Robinson and Helen Smith

Parallel Processing in a SAS Grid, Merry Rabb and Keith Brown

e-Posters

Beginner Beware: Hidden Hazards in SAS® Coding, Alissa Wise

Using SAS® Enterprise Miner for Categorization of Customer Comments to Improve Services at the U.S. Postal Service, Olayemi Olatunji

Statistical Analyses of Public Health Surveys Using SAS® Survey Package, Trung Ha and Julia Soulakova

How High will my Magikarp Jump?, Marcus Maher, Joe Matise and Dominick Hannah

Using SAS® to examine the relationship between nursing attitudes towards suicidal patients in the Emergency Department (ED), Abbas Tavakoli, Belinda Beaver, Stephanie Burgess and Deborah Mcquilkin

Mysteries of Posting Results on reddit, Adeline Wilcox

YAGI: a tool to help Newcomers to SAS efficiently learn Code and Syntax, Steph-Yves Louis

How to use UNIX commands in SAS code to read SAS logs, James Willis

Behind the Scenes: from Data to Customized Swimmer Plots Using SAS® Graphical Template Language (GTL), Rita Tsang and Hima Bhatia

When ANY Function Will Just NOT Do, Richann Watson and Karl Miller

Purrfectly Fabulous Feline Functions, Louise Hadden

Using SAS® to proactively monitor drug alerts: Implementing the URAC “Drug-Drug Interactions” measure for a specialty pharmacy, Karen Wallace

Hands on Workshops

Working in SGPLOT: Understanding the General Logic of Attributes, Jim Blum and Jonathan Duggins

SAS In The Classroom: Exploratory Data Analysis with SAS Studio, Jonathan Duggins and Jim Blum

Hands-On with an Excel-Based Code Playground for Creating and Sharing SAS ODS Graphics, Ted Conway

Hello World! – Getting Started with the SAS DS2 Language, Tricia Aanderud and Jonathan Boase

Introduction to ODS Graphics, Chuck Kincaid

Improving a Graph Using PROC GPLOT® and the GOPTIONS Statement, Wendi Wright

Getting Started with SAS® Prompts, Brian Varney

A Hands-on Introduction to SAS® DATA Step Hash Programming Techniques, Kirk Paul Lafler

Life Sciences, Healthcare, Insurance

Streamlining ADaM Dataset Specifications, Hunter Vega

Building an Out-of-Pocket Cost (OOPC) Calculator for Medical Expenses using the Medical Expenditure Panel Survey (MEPS), Barry Merriman

Timing Variables In Clinical Trials: Avoiding Common Mistakes And Dealing With Unforeseen Issues, Gregory Weller

Discovering CMS Data for Healthcare Research, Laxminarayana Ganapathi, Matthew Urato, Jean Hastie and Merry Rabb

Enrollment Simulation in Clinical Trials, Venita DePuy

One Project, Two Teams: The Unblind leading the Blind, Kristen Harrington

A Data-Driven Approach for Generating Define.xml v2.0 using ADaM Specifications and ADaM Datasets, Jaskaran Gill and Hima Bhatia

De-Identifying Data When Sharing Clinical Data, Pushpa Saranadasa

Automated Validation of Complex Clinical Trials Made Easy, Richann Watson and Josh Horstman

Planning Support Administration

Job Upward Mobility: Getting Better When You’re Already Good, Molly Hall

Parallelizing Windows Operating System Services Job Flows, David Kratz

Super Happy Fun Times: Diagnosing and Resolving an Intermittent Failure with the SAS 9.4 Grid Workspace Server, Rebecca Hayes

Understanding the influence of the day of week in the reviews written, Sujal Reddy Alugubelli

Pinching Off Your SAS® Log: Adapting from Loquacious to Laconic Logs To Facilitate Near-Real Time Log Parsing, Performance Analysis, and Dynamic, Data-Driven Design and Optimization, Troy Hughes

Tips for Effective SAS Platform and User Administration, Michael Sadof

You as a Brand: Tips for Managing Your Data Career, Tricia Aanderud

Document and Enhance Your SAS® Code, Data Sets, and Catalogs with SAS Functions, Macros, and SAS Metadata, Louise Hadden and Roberta Glass

Can A SAS Programmer Stay Cool, Jiangtang Hu

Getting on SAS Grid, Our Journey, David Wilson, Annette Green and Karen Terminiello

Wait, I don’t want to be the Linux Administrator for SAS Visual Analytics!, Jonathan Boase

Reporting / Visualization / JMP

Clinical Data Visualization using TIBCO Spotfire® and SAS®, Ajay Gupta

Mapping Roanoke Island Revisited: An OpenStreetMap (OSM) Solution, Barbara Okerson

Building a Nested Range Bar Chart with SAS® Graph Template Language, Fan Pan, Wenjia Wang and Jin Liu

Building Heat Maps for Data Cleaning and Beyond, Kristen Much and Nicole Bader

An Obvious Yet Helpful Guide to Developing Recurring Reports in SAS®, Rachel Straney

Removing the Mask of Average Treatment Effects in Chronic Lyme Disease Research Using Big Data and Sub-Group Analysis, Mira Shapiro and Lorraine Johnson

How to Data Science: Visualization of Spatial Data – Beyond the Standard Proc Gmap, Seth Hoffman

Applying JMP®’s Imaging Analytic Tools to Target Cancer Tumors that Guides External Beam Radiation Therapy, Melvin Alexander

Mapping Participants to the Closest Medical Center, David Franklin

Parallel Coordinates Plot Made Easy, Shane Rosanbalm

Using PROC REPORT® and ODS STYLE Options to Make Really Great Tables, Wendi Wright

Student Development and Enrollment Services Dashboard at UCF, Carlos Piemonti

Methods for Creating Sparklines using SAS®, Rick Andrews, Louise Hadden and Robert Allison

SAS® Visual Analytics Tricks We Learned from Reading Hundreds of SAS® Community Posts, Tricia Aanderud and Rob Collum

Visualization of Patient Electronic Records to Support Exploratory Analysis and Variable Derivation of Categorical Data, Steven Thomas, Mary Beth Ritchey and Costel Chirila

SAS/GRAPH® and GfK Maps: a Subject Matter Expert Winning Combination, Louise Hadden

Exploring JMP® Modeling Functionality Using Consumer Expenditure Data, Josh Klick

Statistics / Data Analysis

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

Tornado Inflicted Damages Pattern, Vasudev Sharma

Two Sample Parametric and Nonparametric Statistical Tests for a Large Number of Comparisons Made Easy, Dennis Beal

Applying Logistics Regression to Forecast Annual Organizational Retirements, Alan Dunham

Intracompany Social Media Support for a SAS GRID Migration, Harper Gordek

Multicollinearity: What Is It, Why Should We Care, and How Can It Be Controlled?, Deanna Schreiber-Gregory

PMML & SAS: An Introduction to PMML and PROC PSCORE, Andrew Gannon

Churn the Data Around. A Machine Learning Approach to Understanding Why Customers Leave., Sean Ankenbruck

Meta-Analysis and Matrix Multiplication: Adapting an IML-Based Macro for DerSimonian and Laird’s error calculation to use Base SAS., Venita DePuy

Propensity Score Methods for Causal Inference with the PSMATCH Procedure, Yiu-Fai Yung

Using Categorical Variables in Regression Analysis, Jonas Bilenas

Decomposing the R-squared of a Regression Using the Shapley Value in SAS®, Charles Coleman

Tips and Tricks for Raking Survey Data with Advanced Weight Trimming, Michael Battaglia, David Izrael and Sarah Ball

Binning of Predictors for the Cumulative Logit Model, Bruce Lund

MOPP the SOP – Makeover of Programming Process Steps in the Standard Operating Procedure, Kathy Harkins, Kristin Danna and Lisa Spring