MWSUG 2019 Conference Proceedings

Chicago, Illinois
September 29 - October 1, 2019

Analytics Business Leadership Hands On Workshop Industry Rapid Fire SAS 101 Plus e-Poster

Analytics

AL-041. No Wrong Door
Jack Shoemaker, Medical Home Network

AL-047. Connecting to Datasets through Python and SAS
Joe Matise, NORC

AL-059. Track SAS Viya user logins to identify usage and drive improvement using actionable Intelligence: navigate visual reports, track KPIs and visualize long term trends.
*** BEST PAPER ***
Anurag Kulkarni, Revspring

AL-078. Machine Learning? The Machine Already Knows. Software-Intelligent Application Development Provides Reliability, Reusability, Extendability, and Maintainability for Strong Smart Systems in an Ever-Changing World
LeRoy Bessler, Bessler Consulting and Research

AL-111. Legislative Action on Human Trafficking: Towards a Data-Driven Policy
David Corliss, Peace-Work

AL-114. Deploying SAS Viya Docker images to the cloud - a step by step guide
Alan Zablocki, RedMane Technology

AL-115. Deploying SAS Viya to Docker - a practical guide for data scientists
Alan Zablocki, RedMane Technology

AL-127. Why choose between SAS Data Step and PROC SQL when you can have both?
(No paper available)
Charu Shankar, SAS

AL-128. Stacking Up - Horizontal or Vertical with PROC SQL or DATA Step
(No paper available)
Charu Shankar, SAS

AL-129. Power Up Your Reporting Using the SAS® Output Delivery System
(No paper available)
Chevell Parker, SAS

AL-132. Gaining Comfort With SAS® Grid Computing for Analysts and Data Scientists
(No paper available)
Margaret Crevar, SAS

AL-134. Top SAS® Architecture Pitfalls: Lessons Learned the Hard Way
(No paper available)
Margaret Crevar, SAS

Business Leadership

BL-006. Differentiate Yourself
Kirk Paul Lafler, Software Intelligence Corporation

BL-066. Are you Ready? Preparing and Planning to Make the Most of your Conference Experience
Richann Watson, DataRich Consulting
Louise Hadden, Abt Associates Inc.

BL-068. Taxi Ride Prediction: Does the Yellow Cab Supply Meet Customer Demands?
Sreejita Biswas, Oklahoma State University, Stillwater
Miriam McGaugh, Oklahoma State University

BL-074. Impact of Aging Population on Social Security and Underlying Trends
Prajakta Pai, Oklahoma State University
Miriam McGaugh, Oklahoma State University

BL-076. Why Admitted Students Opt-out of College Enrollment?
Manasi Murde, Oklahoma State University
Miriam McGaugh, Oklahoma State University

BL-101. Exploring and characterizing time series data in a non-regression based approach
Steven Myers, The University of Akron

BL-104. Explore your data before you rush to analysis, you will thank me later: explorations in cross section data
*** BEST PAPER ***
Steven Myers, The University of Akron

Hands On Workshop

HW-007. Powerful and "Sometimes" Hard-to-find PROC SQL Features
Kirk Paul Lafler, Software Intelligence Corporation

HW-020. Survival Tips for Survival Analysis
Xiaoting Wu, University of Michigan

HW-022. Understanding Administrative Healthcare Data sets using SAS programming tools
Jayanth Iyengar, Data Systems Consultants LLC

HW-037. Parallel Processing Your Way to Faster Software and a Big Fat Bonus: Demonstrations in Base SAS®
Troy Hughes, Datmesis Analytics

HW-050. Doing More with the SGPLOT Procedure
Josh Horstman, Nested Loop Consulting

HW-063. Interactive Graphs
Richann Watson, DataRich Consulting
Kriss Harris, SAS Specialists Ltd

HW-086. Base SAS® & SAS® Enterprise Guide® Automate Your SAS® World with Dynamic Code ~ Forwards & Backwards
*** BEST PAPER ***
Kent Phelps, Illuminator Coaching, Inc.
Ronda Phelps, Illuminator Coaching, Inc.

HW-094. Not Even One Single Solitary Semicolon: Powerful SAS Things You Can Do Without Writing Programs
Ben Cochran, The Bedford Group

HW-133. Introduction to Bayesian Computation using SAS®
(No paper available)
Amy Shi, SAS

Industry

IN-014. Comparison of three methods for transforming predictor variables to improve model fit using SAS
Doug Thompson, Rush Health

IN-015. Scatterplots: Basics, enhancements, problems and solutions.
Peter Flom, Peter Flom Consulting

IN-019. Time-To-Event Analysis in the Presence of Competing risks
Xiaoting Wu, University of Michigan

IN-021. Exploring the Skills Needed by the Data Science / Analytics Professional
(No paper available)
Kirk Paul Lafler, Software Intelligence Corporation

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

IN-044. The SAS EG Process Flow: A Customizable Data Mining Tool in the Search for Healthcare Fraud
Andrea McLain, Cigna Health Insurance

IN-061. Leveraging RAREEVENTS Procedure Options to Monitor and Evaluate Infrequent Events in Healthcare
Lynn (Xiaohong) Liu, Ann & Robert H. Lurie Childrens Hospital of Chicago
Roderick Jones, Ann & Robert H. Lurie Children's Hospital of Chicago

IN-064. Detecting Side Effects and Evaluating Effectiveness of Drugs from Customers' Online Reviews using Text Analytics and Data Mining Models
Thu Dinh, Oklahoma State University

IN-080. Do undergraduates need prerequisites for common courses?
Lin Qi, Oklahoma State University
Archana Chinnaswamy, InterWorks.Inc
Miriam McGaugh, Oklahoma State University

IN-083. Classifying Risk in Life Insurance using Predictive Analytics
*** BEST PAPER ***
Sai Gopi Krishna Govindarajula, Oklahoma State University

IN-088. Timing is Everything: Defining ADaM Period, Subperiod and Phase
Nancy Brucken, Syneos Health

IN-095. Findings About: De-mystifying the When and How
Michael Wise, Syneos Health
Soumya Rajesh, Syneos Health

IN-113. Sample Size and Design Considerations in Studies Assessing Non-Inferiority using Continuous Outcomes
Michael G. Wilson, IUSM

IN-116. Simulating Skewed Multivariate Distributions Using SAS: Cases of Lomax, Mardia's Pareto (Type I), Logistic, Burr and F Distributions
Zhixin Lun, Oakland University
Ravindra Khattree, Oakland University

IN-130. Real World Evidence and Population Health Analytics: Intersection and Application Outside
(No paper available)
David Olaleye, SAS

Rapid Fire

RF-003. A Visual Step-by-step Approach to Converting an RTF File to an Excel File
Kirk Paul Lafler, Software Intelligence Corporation

RF-004. Saving and Restoring Startup (Initialized) SAS® System Options
Kirk Paul Lafler, Software Intelligence Corporation

RF-017. 3 ways to get Pretty Excel-Style Tables: PROC REPORT, PROC TABULATE, and Help from SAS Enterprise Guide®
*** BEST PAPER ***
Brooke Ellen Delgoffe, Marshfield Clinic Research Institute

RF-024. Navigating the Ins and Outs of Mapping in SAS Enterprise Guide
Ruth Kurtycz, Spectrum Health

RF-029. Using the XLSX libref engine with metadata available in Dictionary Tables
Michael Harper, A-Line Staffing

RF-033. The Doctor Ordered a Prescription&Not a Description: Driving Dynamic Data Governance Through Prescriptive Data Dictionaries That Automate Quality Control and Exception Reporting
Troy Hughes, Datmesis Analytics

RF-034. Abstracting and Automating Hierarchical Data Models: Leveraging the SAS® FORMAT Procedure CNTLIN Option To Build Dynamic Formats That Clean, Convert, and Categorize Data
Troy Hughes, Datmesis Analytics

RF-038. Evaluate your SCORE: Logistic regression prediction comparison using the SCORE statement
Robert G. Downer, Grand Valley State University

RF-058. Like, Learn to Love SAS® Like
Louise Hadden, Abt Associates Inc.

RF-060. DOMinate your ODS Output with PROC TEMPLATE, ODS Cascading Style Sheets (CCS), and the ODS Document Object Model (DOM)
Louise Hadden, Abt Associates Inc.
Troy Hughes, Datmesis Analytics

RF-067. Breaking Human Trafficking Network: An Analytics Approach
Raj Laxmi Prakash, Oklahoma State University
Miriam McGaugh, Oklahoma State University

RF-069. The Advent of Renewable Energy
Sai Teja Sagi, Oklahoma State University
Miriam McGaugh, Oklahoma State University

RF-077. Utilizing Macros to Create Patient Site Matching via Zip-Code Radiuses
Kathryn Schurr, Quest Diagnostics

RF-079. US Airline Passenger Satisfaction using SAS Enterprise Miner
Harish Reddy Patlolla, Oklahoma State University
Miriam McGaugh, Oklahoma State University

RF-100. Surviving Survival Analysis 101: Making the Likelihood Ratio Test Easier Using a Macro
Katelyn Ware, Grand Valley State University
Rachel Baxter, Grand Valley State University

RF-105. Comparing Dates without an Array
Laurie Smith, Cincinnati Children's Hospital Medical Center

RF-108. What Not to Do in a Program Used with %include
Stephanie Thompson, Datamum

RF-109. 10 Cool Things You Can Do in a DATA STEP
Stephanie Thompson, Datamum

SAS 101 Plus

SP-002. SAS® Macro Programming Tips and Techniques
Kirk Paul Lafler, Software Intelligence Corporation

SP-012. PROC FORMAT with HTML - for useful Drill Down output in Web and/or Excel
(No paper available)
Zeke Torres, RedMane Technology

SP-026. Logistic Regression, Basics and Beyond
Bruce Lund, Independent Consultant

SP-031. User-Defined Multithreading with the SAS® DS2 Procedure: Performance Testing DS2 Against Functionally Equivalent DATA Steps
Troy Hughes, Datmesis Analytics

SP-043. Look up not down: Advanced Table Lookup Techinques in BASE SAS
Jayanth Iyengar, Data Systems Consultants LLC
Josh Horstman, Nested Loop Consulting

SP-052. Fifteen Functions to Supercharge Your SAS® Code
Josh Horstman, Nested Loop Consulting

SP-053. Using Macro Variable Lists to Create Dynamic Data-Driven Programs
Josh Horstman, Nested Loop Consulting

SP-057. Using ODS Trace (DOM), Procedural Output and ODS Output Objects to Create the Output of Your Dreams
Louise Hadden, Abt Associates Inc.

SP-065. Quick, Call the "FUZZ": Using Fuzzy Logic
Richann Watson, DataRich Consulting
Louise Hadden, Abt Associates Inc.

SP-072. Powerful SAS® Output Delivery with ODS EXCEL
*** BEST PAPER ***
LeRoy Bessler, Bessler Consulting and Research

SP-093. Urge to Merge? Maybe You Should Update Instead.
Ben Cochran, The Bedford Group, Inc.

SP-131. It's All About the Base - Procedures
(No paper available)
Jane Eslinger, SAS

e-Poster

PO-023. Creating a True LSF Batch Job Submission Capability on SAS EG in a SAS Grid
Derek Grittmann, General Dynamics Federal Civilian Health
Adam Hendricks, General Dynamics Federal Civilian Health

PO-028. Generating SAS Datasets from ASCII Files Using a Crosswalk
Jose Centeno, NORC at the University of Chicago

PO-030. Badge in Batch with Honeybadger: Generating Conference Badges with Quick Response (QR) Codes Containing Virtual Contact Cards (vCards) for Automatic Smart Phone Contact List Upload
Troy Hughes, Datmesis Analytics

PO-045. Have Your SAS Program and Schedule It Too!
Mario Tejada, NORC at the University of Chicago

PO-071. Frequency matching case-control techniques: an epidemiological perspective
Hai Nguyen, UIC-School of Public Health

PO-082. Oh, There's No Place Like SAS ODS Graphics for the Holidays!
Ted Conway, Self

PO-097. Exploring Wine Reviews: How Language and Word Use Varies in Wine Reviews
Abigail Zysk, Grand Valley State University
Kylie Springer, Grand Valley State University

PO-098. Profiling hospital length of stay using the mode
*** BEST PAPER ***
Anne Cain-Nielsen, University of Michigan
Scott Regenbogen, University of Michigan