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

---