MWSUG 2018 Conference Proceedings

Indianapolis, Indiana
September 30 - October 2, 2018

Business Leadership Hands-on Workshops Health Sciences SAS 101 Plus SAS 301 Beyond the Basics Statistics / Advanced Analytics e-Posters

Business Leadership

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

BL-28. Computer Karma: Non-Monetary Benefits from Statistical And Information Technology Volunteer Work
Brandy Sinco, University of Michigan

BL-43. How to Succeed in Consulting
Chuck Kincaid, Experis Business Analytics

BL-50. Customized Project Tracking with SAS and Jira
Nancy Brucken, InVentiv Health Clinical

BL-64. So You Want To Be An Independent Consultant
Josh Horstman, Nested Loop Consulting

BL-90. Analyzing YouTube comments on gun violence using SAS® Viya and SAS® Text Miner
Sridevi Loya, Student

BL-101. Analytics in the Cloud: Beware of "hidden" costs
(No paper available)
Paul Segal, Teradata

BL-103. Accelerate Your Analytics with SAS® and Teradata Using Disparate Data Sources
(No paper available)
Paul Segal, Teradata

BL-104. What is Leadership?
(No paper available)
Peter Eberhardt, Fernwood Consulting Group Inc

BL-122. How to HOW: Hands-on-Workshops Made Easy
Chuck Kincaid, Experis Business Analytics

BL-127. From Readability to Responsible Risk Management: Facilitating the Automatic Identification and Aggregation of Software Technical Debt within an Organization Through Standardized Commenting in SAS® Program Files and SAS Enterprise Guide Project Files
Troy Hughes, Datmesis Analytics

BL-144. Become a Data-Driven Organization with People, Process and Technology
(No paper available)
*** BEST PAPER ***
Tho Nguyen, Teradata

BL-146-SAS. Comparing SAS® Viya® and SAS® 9.4 Capabilities: A Tale of Two SAS Platform Engines
(No paper available)
Amy Peters, SAS

BL-147. Data For Good as a Community Service Project at Work
David Corliss, Peace-Work

BL-159. Advance Your Career with PROC TM!
John Labore, Consultant
Josh Horstman, Nested Loop Consulting

Hands-on Workshops

HW-9. A Hands-on Introduction to SAS® Metadata DICTIONARY Tables and SASHELP Views
Kirk Paul Lafler, Software Intelligence Corporation

HW-33. Animate Your Data!
Richann Watson, DataRich Consulting
Kriss Harris, SAS Specialists Ltd

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

HW-65. Getting Started with the SGPLOT Procedure
Josh Horstman, Nested Loop Consulting

HW-98. The Joinless Join ~ The Impossible Dream Come True Using SAS® Enterprise Guide® and Base SAS® PROC SQL and DATA Step; Expand the Power of SAS® Enterprise Guide® and Base SAS® in New Ways
Kent Phelps, Illuminator Coaching, Inc.
Ronda Phelps, Illuminator Coaching, Inc.

HW-99. The Baker Street Irregulars Investigate: Discoveries Using Perl Regular Expressions and SAS®
Peter Eberhardt, Fernwood Consulting Group Inc

Health Sciences

HS-27. Tips, Tricks, and Traps on Longitudinal Data Analysis with Discrete and Continuous Times
Brandy Sinco, University of Michigan
Edie Kieffer, University of Michigan
Michael Spencer, University of Washington
Gray Ficker, CHASS Center
Gretchen Piatt, University of Michigan

HS-36. How to Navigate in a Maze of the Raking Macro with Advanced Weight Trimming
Michael Battaglia, Battaglia Consulting Group, LLC
David Izrael, Abt Associates
Sarah Ball, Abt Associates

HS-38. Assessing Model Adequacy in Proportional Hazards Regression
Michael G. Wilson, IUSM

HS-39. Using SAS® to Validate Clinical Prediction Models
Xiaoting Wu, University of Michigan
Chang He, The Michigan Society of Thoracic and Cardiovascular Surgeons Quality Collaborative
Donald Likosky, Michigan Medicine

HS-45. Pan-Cancer Epigenetic Biomarker Selection from Blood Sample Using SAS®
Xi Chen, University of Kentucky
Jin Xie, Department of Statistics, University of Kentucky
Qingcong Yuan, Department of Statistics, Miami University

HS-53. Creating suicide attempt/intentional self-harm episodes using administrative billing data
Jamie Kammer, New York State Office of Mental Health
Mahfuza Rahman, NYS OMH
Qingxian Chen, NYS OMH

HS-71. Leveraging SHEWHART Procedure Options to Monitor and Evaluate Improvements in Healthcare
Roderick Jones, Ann & Robert H. Lurie Children's Hospital of Chicago
Lynn (Xiaohong) Liu, Ann & Robert H. Lurie Childrens Hospital of Chicago

HS-73. A Macro to Import Subject Data Saved in a Location with Separate Subfolders for each Subject
Laurie Smith, Cincinnati Children's Hospital Medical Center

HS-74. Use of SAS Macros to automate the Production of Statistical Process Control Charts
Lynn (Xiaohong) Liu, Ann & Robert H. Lurie Childrens Hospital of Chicago
Roderick Jones, Ann & Robert H. Lurie Children's Hospital of Chicago

HS-83. A Macro to Calculate Sample Size for Studies Using the Proportional Time Assumption
Brian Mosier, University of Kansas Medical Center
John Keighley, University of Kansas Medical Center
Milind Phadnis, University of Kansas Medical Center

HS-88. Baseline Mean Centering for Analysis of Covariance (ANCOVA) Method of Randomized Controlled Trial Data Analysis
Jennifer Scodes, New York State Psychiatric Institute

HS-94. Genocide Modeling - Historical Risk Factors and Odds Ratios
David Corliss, Peace-Work

HS-118. Bootstrap Linear Mixed-Effects Models using SAS Procedures
Adams Kusi Appiah, University of Nebraska Medical Center

HS-119. Automated Transfer of a Sea of SAS® Programs between Data Transfers
Xuelin Li, Eli Lilly and Company
Jameson Cai, Eli Lilly and Company
Cindy Lee, Eli Lilly and Company

HS-132. Toward Adoption of Agile Software Development in Clinical Trials
Troy Hughes, Datmesis Analytics

HS-142. Spotfire Clinical visualizations from SAS and R
Zeqing Lu, Eli LIlly
Hillary Graham, Eli Lilly
Jessica Chen, Eli Lilly

HS-143. AutoPDF : an R Package to Output Vector Graphics
Hillary Graham, Eli Lilly
Zeqing Lu, Eli LIlly
Michelle Carlsen, Eli Lilly

HS-160. Avoiding Sinkholes: Common Mistakes During ADaM Data Set Implementation
Richann Watson, DataRich Consulting

SAS 101 Plus

SP-2. Making Your SAS® Output, Results, Reports, Charts and Spreadsheets More Meaningful with Color
Kirk Paul Lafler, Software Intelligence Corporation

SP-48. Using Multilabel Formats with PROC SUMMARY to Generate Report Data with Overlapping Time Segments
John Schmitz, Luminare Data

SP-49. Data-driven Data Analysis
Jack Shoemaker, Texture Health

SP-54. Using your FREQ effectively: Displays to Decipher Proportional Odds in Ordinal Regression
Robert G. Downer, Grand Valley State University

SP-57. A Macro that Can Get the Geo Coding Information from the Google Map API
Ting Sa, Cincinnati Children's Hospital Medical Center

SP-61. Seeing the Forest for the Trees: Part Deux of Defensive Coding by Example
Donna Levy, Syneos Health
Nancy Brucken, Syneos Health

SP-62. Efficiency Programming with Macro Variable Arrays
*** BEST PAPER ***
Veronica Renauldo, QST Consultations

SP-63. Dating for SAS Programmers
Josh Horstman, Nested Loop Consulting

SP-66. Merge with Caution: How to Avoid Common Problems when Combining SAS Datasets
Josh Horstman, Nested Loop Consulting

SP-69. What's the Difference? Using the PROC COMPARE to find out.
Larry Riggen, Indiana University

SP-75. From Clicking to Coding: Using ODS Graphics Designer as a Tool to Learn Graph Template Language
Margaret Kline, Grand Valley State University
Daniel Muzyka, Grand Valley State University

SP-76. Tips, Traps, and Techniques in BASE SAS for vertically combining SAS data sets
Jayanth Iyengar, Data Systems Consultants LLC

SP-78. Improving Plots Using XAXISTABLE and YAXISTABLE
Jacob Keeley, Grand Valley State University
Carl Nord, Eli Lilly and Company

SP-100. Using SASv9.cfg, autoexec.sas, SAS® Registry, and Options to Set Up Base SAS®
Peter Eberhardt, Fernwood Consulting Group Inc

SP-116. Order, Order! Four Ways to Reorder Your Variables, Ranked by Elegance and Efficiency
Louise Hadden, Abt Associates Inc.

SP-139-SAS. Keeping Up to Date with ODS Graphics
Warren Kuhfeld, SAS

SAS 301 Beyond the Basics

SB-10. A Quick Look at Fuzzy Matching Programming Techniques Using SAS® Software
Kirk Paul Lafler, Software Intelligence Corporation
Stephen Sloan, Accenture

SB-19. Visual Storytelling - The Art of Communicating Information with Graphics
Kirk Paul Lafler, Software Intelligence Corporation

SB-34. Backsplash patterns for your world: A look at SAS OpenStreetMap (OSM) tile servers
Barbara Okerson

SB-40. Conversion of CDISC specifications to CDISC data - specifications driven SAS programming for CDISC data mapping
Yurong Dai, Eli Lilly
Jiangang Jameson Cai, Eli Lilly

SB-52. Show Me That? Using SAS VIYA, Visual Analytics and Free ESRI Maps to Show Geographic Data
John Schmitz, Luminare Data

SB-59. Finding National Best Bid and Best Offer - Quote by Quote
Mark Keintz, Wharton Research Data Services

SB-60. From Stocks to Flows: Using SAS® HASH objects for FIFO, LIFO, and other FO's
Mark Keintz, Wharton Research Data Services

SB-89. Analyzing Amazon's Customer Reviews using SAS® Text Miner for Devising Successful Product Launch Strategies
*** BEST PAPER ***
Manideep Mellachervu, Oklahoma State University
Anvesh Reddy Minukuri, Comcast Corporation

SB-93. Quality Control for Big Data: How to Utilize High Performance Binning Techniques
Deanna Schreiber-Gregory, Henry M Jackson Foundation for the Advancement of Military Medicine
Karlen Bader, Henry M Jackson Foundation for the Advancement of Military Medicine

SB-102. Speed up your Data Processing with SAS Code Accelerator.
(No paper available)
Paul Segal, Teradata

SB-114. Wow! You Did That Map With SAS®?! Round II
Louise Hadden, Abt Associates Inc.

SB-140-SAS. Square Peg, Square Hole-Getting Tables to Fit on Slides in the ODS Destination for PowerPoint
Jane Eslinger, SAS

SB-141-SAS. Advanced ODS Graphics Examples
(No paper available)
Warren Kuhfeld, SAS

SB-145. Perl Regular Expression - The Power to Know the PERL in Your Data
Kaushal Chaudhary, Eli Lilly and Company
Dhruba Ghimire, Eli Lilly and Company

Statistics / Advanced Analytics

AA-29. Automatic Indicators for Dummies: A macro for generating dummy indicators from category type variables
Matthew Bates, Affusion Consulting

AA-30. Confounded? This example shows how to use SAS chi-square tests, correlations and logistic regression to unconfound a result.
Michael Grierson, Self

AA-31. Screening, Transforming, and Fitting Predictors for Cumulative Logit Model
Bruce Lund, Consultant for Magnify Analytic Solutions

AA-41. Alternative methods of regression when OLS is not right.
Peter Flom, Peter Flom Consulting

AA-42. An introduction to classification and regression trees with PROC HPSPLIT.
*** BEST PAPER ***
Peter Flom, Peter Flom Consulting

AA-47. Propensity Scores and Causal Inference for (and by) a Beginner
Bruce Lund, OneMagnify

AA-91. Logistic and Linear Regression Assumptions: Violation Recognition and Control
Deanna Schreiber-Gregory, Henry M Jackson Foundation for the Advancement of Military Medicine
Karlen Bader, Henry M Jackson Foundation for the Advancement of Military Medicine

AA-92. Regularization Techniques for Multicollinearity: Lasso, Ridge, and Elastic Nets
Deanna Schreiber-Gregory, Henry M Jackson Foundation for the Advancement of Military Medicine
Karlen Bader, Henry M Jackson Foundation for the Advancement of Military Medicine

AA-109. Application of heavy-tailed distributions using PROC IML, NLMIXED and SEVERITY
Palash Sharma, University of Kansas Medical Center

AA-117. An Introduction to the process of improving a neural network
Yuting Tian, 7326090713

AA-120. Handling Missing Data in Exploratory Factor Analysis Using SAS
Min Chen, Cook Research Inc.

AA-121. How to Score Big with SAS Solutions: Various Ways to Score New Data with Trained Models
Scott Koval, Pinnacle Solutions, Inc

AA-137-SAS. Getting Started with Bayesian Analytics
(No paper available)
Danny Modlin, SAS

AA-138-SAS. Introduction to Machine Learning in SAS
(No paper available)
Brett Wujek, SAS

e-Posters

PO-32. Great Time to Learn GTL
Richann Watson, DataRich Consulting
Kriss Harris, SAS Specialists Ltd

PO-44. Self-service utility to List and Terminate SAS grid jobs
Venkateswarlu Toluchuri, Tech Lead SAS Administrator

PO-51. An Update on the CS Standard Analyses and Code Sharing Working Group
Nancy Brucken, Syneos Health
Jared Slain, MPI Research

PO-68. Factors Responsible for Students' Enrollment at Oklahoma State University
Parag Vilas Sasturkar, Oklahoma State University

PO-111. How to Avoid Possible Tricks When Using DATA STEP MERGE Instead of PROC SQL JOIN
Guangtao Gao, Cleveland State University

PO-115. Purrfectly Fabulous Feline Functions
*** BEST PAPER ***
Louise Hadden, Abt Associates Inc.

PO-136. Addressing Opioid Crisis using Data Science
Rishabh Mishra, Oklahoma State University