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
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, Ryan Kumpfmiller 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
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