2017 Proceedings

WUSS 2017 Proceedings

Advanced Techniques

Automating Code Generation to reduce errors and effort
Steve Cavill
justice.nsw.gov.au
I’ve Got to Hand It to You; Portable Programming Techniques
Art Carpenter1 and Mary Rosenbloom2
1CA Occidental Consultants, 2Alcon, a Novartis Company
Secure Macro-Based Method to Assign LIBNAMEs for Databases
Thomas Billings
MUFG Union Bank
The Future of the SAS Platform
Amy Peters
SAS
A Quick Look at Fuzzy Matching Programming Techniques Using SAS® Software
Kirk Paul Lafler1 and Stephen Sloan2
1Software Intelligence Corporation, 2Accenture
Hash Beyond Lookups: Your Code Will Never be the Same!
Elizabeth Axelrod
Abt Associates Inc.
Building Intelligent Macros: Using Metadata Functions with the SAS® Macro Language
Art Carpenter
CA Occidental Consultants
Methods to Identify and Validate SAS®-Proprietary and AES Encrypted SAS® Data Sets
Thomas Billings
MUFG Union Bank
Sending Text Messages from SAS®
Matthew Slaughter
Kaiser Permanente Center for Health Research
Planning WUSS 2018
Andra Northup1 and Jeanina (Nina) Worden2
1Advanced Analytic Designs, Inc., 2Santen
Keeping Passwords, AES Encryption Keys, and Other Sensitive Parameters Out of Source Code and Logs
Thomas Billings
MUFG Union Bank
Automated Validation of Complex Clinical Trials Made Easy
Richann Watson1 and Josh Horstman2
1Experis, 2Nested Loop Consulting
Open Source Platform Unveiled
Karen Walker
InVentiv Health Clinical
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
Datmesis Analytics
Building Macros for Quick Survey Scoring
Vincent Chan and Lorena Ortiz
IMPAQ International LLC
Building Intelligent Macros: Driving a Variable Parameter System with Metadata
Art Carpenter
CA Occidental Consultants
Generating Reliable Population Rates Using SAS® Software
Jack Shoemaker
MDwise
Analytics & Statistics
Propensity Score Matching: A Cautionary Tale
Isaiah Lankham
University of California Office of the President
Five Things You Should Know about Quantile Regression
Bob Rodriguez
SAS
A-NEST-ED Development: A One-Step PROC SQL Trick For Comparing Transactions To Their Own Summary Statistics Using Nested Functions
Ahmed Khan
AT&T
Analyzing multiple membership hierarchical data using PROC GLIMMIX
Maria Vazquez and Jeffrey Wilson
Arizona State University
Variance Ratio Estimation using the PrecMod SAS® Macro
Jesse Canchola1 and Pari Hemyari2
1Roche Molecular Systems, Inc., 2Roche Molecular Systems Inc.
Propensity Score Methods for Causal Inference with the PSMATCH Procedure
Maura Stokes
SAS
Is My Model the Best? Methods for Exploring Model Fit
Deanna Schreiber-Gregory
Henry M Jackson Foundation for the Advancement of Military Medicine 111
Examining the Performance of a Control Chart for the Shifted Exponential Distribution using Penalized Maximum Likelihood Estimators: A Simulation Study using SAS
Austin Brown and Bryce Whitehead
University of Northern Colorado
A One-Sided Fisher’s Exact Test: A Tail of Clinical Worsening
Bill Coar
Axio Research
Maximizing Cross-Sell Opportunities with Predictive Analytics for Financial Institutions
Nate Derby
Stakana Analytics
Multicollinearity: What Is It and What Can We Do About It?
Deanna Schreiber-Gregory
Henry M Jackson Foundation for the Advancement of Military Medicine
Step Up Your Statistical Practice with Today’s SAS/STAT® Software
Bob Rodriguez
SAS
Applications Development

Scripting to Automate Workflows
Chris Whalen1 and Amy Garrett2
1Clovis Oncology, 2Robarts Clinical Trials
The Future of Transpose: How SAS is Rebuilding its Foundation by Making What is Old New Again
Scott Mebust
SAS
Modernizing Legacy SAS® Applications and Program Code
Kirk Paul Lafler1 and Clark Roberts2
1Software Intelligence Corporation, 2SAS Consultant, Data Analyst and Application Developer
NFL Data Analytics for a New Era  
Mitchell Collins
Cal Poly SLO
Your Local Fire Engine Has an Apparatus Inventory Sheet and So Should Your Software: Automatically Generating Software Use and Reuse Libraries and Catalogs from Standardized SAS® Code
Troy Hughes
Datmesis Analytics
Beginner’s Techniques

How SAS Thinks: SAS Basics I
Susan Slaughter
Avocet Solutions
Introduction to DATA Step Programming: SAS Basics II
Susan Slaughter
Avocet Solutions
Introduction to SAS Procedures: SAS Basics III
Susan Slaughter
Avocet Solutions
Learnings and Pitfalls from my EG Migration
Kent Lewandowski
Kaiser Permanente
Using SAS® to proactively monitor drug alerts: Implementing the URAC “Drug-Drug Interactions” measure for a specialty pharmacy
Karen Wallace
Centene Corporation
Decision Trees: a Gentle Introduction
Richard Hector
Arizona Care Network
Merge with Caution: How to Avoid Common Problems when Combining SAS Datasets 
Josh Horstman
Nested Loop Consulting
Many Means to a Mean 
Shannon Pileggi
California Polytechnic State University, San Luis Obispo
Ten Things You Should Know About PROC FORMAT
Jack Shoemaker
Texture Health
Simplifying Effective Data Transformation Via PROC TRANSPOSE
Arthur Li
City of Hope
SAS Jeopardy! (2017 Edition)
Tasha Chapman
Oregon Department of Consumer and Business Services
One-to-One, One-to-Many, and Many-to-Many Joins Using PROC SQL
Kirk Paul Lafler1 and Charu Shankar2
1Software Intelligence Corporation, 2SAS Institute Inc.
SAS Abbreviation: The Snippets that Keep on Giving
Robert Bikwemu
Pharmapace INC
Fifteen Functions to Supercharge Your SAS Code
Josh Horstman
Nested Loop Consulting
Programming Triage:  Rooting out Dataset Discrepancies in the Validation Process  
Julia Sturgeon
SynteractHCR
An Easy Way to Split a SAS® Data Set into Unique and Non-Unique Row Subsets  
Thomas Billings
MUFG Union Bank
Big Data & Data Science

Integrating Health Data Sources to Identify, Stratify, and Predict High Utilizers of Public Systems.
Benjamin Knisley1, Dr. Joshua Morgan1, Dr. Linn Carothers2, Keith Haigh1
1San Bernardino Department of Behavioral Health Research and Evaluation, 2California Baptist University
Using SAS® Enterprise Miner for Categorization of Customer Comments to Improve Services at the U.S. Postal Service
Olayemi Olatunji
U.S.Postal Service Office of Inspector General
Get Smart! Eliminate Kaos and Stay in Control – Creating a Complex Directory Structure with the DLCREATEDIR Statement, SAS® Macro Language, and Control Tables
Louise Hadden
Abt Associates Inc.
An Overview of SAS Visual Data Mining and Machine Learning on SAS Viya*
Radhikha Myneni
SAS
A Data Mining Approach for Developing Intervention Programs to Lessen Body Dissatisfaction and Promote Healthy Weight Management
Pitipa Chongwatpol1 and Jongsawas Chongwatpol2
1Institute of Nutrition, Mahidol University, 2NIDA Business School, National Institute of Development Administration
Statistical Methodology for Data Harmonization
yan wang
UCLA
Examining Distributional Shifts by Using Population Stability Index (PSI) for Model Validation and Diagnosis
Alec Zhixiao Lin
Loan Depot
Nonlinear modeling with big data in SAS and JMP
Chong Ho Yu1, Hyun Seo Lee2, Siyan Gan3, Emily Brown2
1, 2Azusa Pacific University, 3Pepperdine University
Next Best Offer Analytics using SAS
Robin Way and William Eisenhauer
Corios
Data Management

Five Ways to Flip-Flop Your Data
Josh Horstman
Nested Loop Consulting
An Intro to PROC SQL: Simple & Complex Queries
Melissa Navarro
Individual Contributor
A SAS® Format Catalog for ICD-9/CD-10 Diagnoses and Procedures: Data Research Example and Custom Reporting Example
Robert Springborn
Office of Statewide Health Planning & Development
Creating a Data Dictionary Using Base SAS
Tasha Chapman
Oregon Department of Consumer and Business Services
Database-ics II: Design, Standardize and Control the Process for Better Data Management
Frank Ferriola
Elk Crossing Consulting
ePosters

Categorical Data: Comparing SAS® an and R for Logistic and Poisson Regression
Lillian Chow
San Francisco State University 68
Visual interpretation of interaction effects in Generalized Linear Mixed Model with Proc PLM from a randomized controlled trial
Yingbo Ma1 and Kwa Sey2
1Los Angeles County Public Health, 2Los Angeles county Department of Public Health
Moving Along in Health Research: Applying PROC EXPAND to Medical Encounter Data
Rayna Matsuno
NA
Uploading the IPEDS Human Resources Survey with SAS
Joyce Garcia
University of Utah
Identifying Unforeseen Strains on Local Health Care Ecosystems
Evan Wallis
Office of Statewide Health Planning and Development
Lessons Learned in Building a Successful SAS Business Analytic Program
Wendy Wang
Trident University
Hands On Workshops
Working with the SAS® ODS EXCEL Destination to Send Graphs, and Use Cascading Style Sheets When Writing to EXCEL Workbooks
William E Benjamin Jr
Owl Computer Consultancy LLC
Effectively Utilizing Loops and Arrays in the DATA Step
Arthur Li
City of Hope
Single File Deliverables: Next Steps
Bill Coar
Axio Research
A Hands-on Introduction to SAS® DATA Step Hash Programming Techniques
Kirk Paul Lafler
Software Intelligence Corporation
Modeling Longitudinal and Multilevel Data in SAS
Niloofar Ramezani
George Mason University
Parallel Processing Your Way to Faster Software and a Big Fat Bonus: Demonstrations in Base SAS®
Troy Hughes
Datmesis Analytics
Tune In to Model Tuning
Radhikha Myneni
SAS
SAS® Studio: A New Way to Program in SAS®
Lora Delwiche1 and Susan Slaughter2
1Self-Employed, 2Avocet Solutions
Analysis of Complex Survey Data with SAS
Christine Wells
UCLA
Industry Solutions
SDTMs in a Medical Device Trial – A First Attempt
Phil Hall
Edwards Lifesciences
Zeroing in on Effective Member Communication: An Rx Education Study
Brian Mitchell
Humana Inc
Standardized Approaches for Analyzing Quality Improvement Interventions in Healthcare Settings
Polina Kukhareva
University of Utah
Avoiding Sinkholes: Common Mistakes During ADaM Data set Implementation
Richann Watson1 and Karl Miller2
1Experis, 2inVentiv Health
The Cox Hazard Model for Claims Data.
Samuel Berestizhevsky1 and Tanya Kolosova2
1InProfix Inc, 2Co-author
Building a member centric world from a transactional data galaxy
Brian Mitchell
Humana Inc
Approaches in Loan and Vintage Level ROI Forecasting – A Consumer Lending Industry Perspective
SRIDHAR SANKRANTI
Axcess Financial
Validation Method Selection, not just a ‘Match’
Rituraj Saxena and Nina Worden
Santen Inc.
Quality Control of Clinical Data Listings with Proc Compare
Robert Bikwemu and Nicole Wallstedt
Pharmapace INC
A Critique of Implementing the Submission Data Tabulation Model (SDTM) for Drugs and Medical Devices
Carey Smoak
DataCeutics, Inc.
Professional Development



Job Upward Mobility: Getting Better When You’re Already Good
Molly Hall
Synchrony Solutions, Inc.
Show Me The Jobs!
Richelle Serrano
Clindata Insight
How to Maximize Productivity While Working Remotely
james joseph
PAREXEL
The Role of A Data Consultant at Kaiser Permanente
Cyrus Davis
Kaiser Permanente
A Review of “Free” Massive Open Online Content (MOOC) for SAS® Learners
Kirk Paul Lafler
Software Intelligence Corporation
Reporting and Data Visualization

PROC DOC III: Self-generating Codebooks Using SAS®
Louise Hadden
Abt Associates Inc.
Replay SG Graphs with IBACK in SAS/GRAPH®
Abhinav Srivastva
Gilead Sciences
Cell Growth Simulation using SAS
Karen Walker
InVentiv Health Clinical
Creating Completely Automated Reports in SAS® using the ODS RTF Destination: Protect Your Results from Human Error
Debra Goldman
Memorial Sloan Kettering Cancer Center
Which Paint Brush Shall I Choose– Mapping Out Your Visualization Plan for Clinical Study
Chen Shi
Santen Inc.
Exploring Data for Sweet Spots by Using Heat Maps in SAS®
Alec Zhixiao Lin
Loan Depot
Integrating SAS and non-SAS Tools and Systems for Behavioral Health Data Collection, Processing, and Reporting
Manuel Gomez, Keith Haigh, Joshua Morgan
San Bernardino County Department of Behavioral Health
Minimize PROC REPORT time and maximize your beach time
Nadira Babaeva
SynteractHCR
Pattern of Adverse Events: The Use of Boxplot
Jui-Fu Huang
Shire
Text Wrapping with Indentation for RTF Reports®
Abhinav Srivastva
Gilead Sciences
SAS/GRAPH® and GfK Maps: a Subject Matter Expert Winning Combination
Louise Hadden
Abt Associates Inc.
PROC TABULATE Made Easy
Yunin Ludena and Elizabeth Guerrero Angel
University of California, Davis
2 Broken Axis In a Single Graph – That’s Crazy Talk – How To Use PROC TEMPLATE, SGRENDER, and SGANNO To Make Your Graphs Look Awesome.
Steven C. Black
Agility-Clinical
Making a Difference With SAS Software
Humberto Cisneros and Carrin Huff
Arizona Supreme Court
Red Rover, Red Rover, Send Data Right Over: Exploring External Geographic Data Sources with SAS®
Louise Hadden
Abt Associates Inc.
A Method for Simultaneously Programming Mock and Computed Tables
Michael Williams
ICON Clinical Research
Importing CSV Data to All Character Variables
Art Carpenter
CA Occidental Consultants
Maintaining ORDER in Your (Proc) Reporting
Bill Coar
Axio Research
All Aboard! Next Stop is the Destination Excel
William E Benjamin Jr
Owl Computer Consultancy LLC