WUSS 2017 Conference Proceedings

Long Beach, California
September 20-22, 2017

Advanced Techniques

(PDF) Generating Reliable Population Rates Using SAS® Software
Author: Jack N. Shoemaker

(PDF) Building Intelligent Macros: Using Metadata Functions with the SAS® Macro Language
Keywords: “Metadata, macro language, DATA step functions, %SYSFUNC, OPEN, ATTRN, ATTRC, FETCH, CLOSE”
Author: Arthur L. Carpenter

(PDF) I’ve Got to Hand It to You; Portable Programming Techniques
Keywords: “Macro, %SYSGET, AUTOEXEC, %SYSFUNC, portable, SAS_EXECFILEPATH, Batch submissions, UNIX, Windows”
Authors: Arthur L. Carpenter; Mary F. O. Rosenbloom

(PDF) Building Intelligent Macros: Driving a Variable Parameter System with Metadata
Keywords: Metadata, macro language, CALL EXECUTE, %NRSTR, %TSLIT
Author: Arthur L. Carpenter

(PDF) Keeping Passwords, AES Encryption Keys, and Other Sensitive Parameters Out of Source Code and Logs
Author: Thomas E. Billings

(PDF) Secure Macro-Based Method to Assign LIBNAMEs for Databases
Author: Thomas E. Billings

(PDF) Methods to Identify and Validate SAS®-Proprietary and AES Encrypted SAS® Data Sets
Author: Thomas E. Billings

(PDF) Open Source Platform Unveiled
Author: Karen Walker

(PDF) Hash Beyond Lookups: Your Code Will Never Be the Same!
Author: Elizabeth N. Axelrod

(PDF) Automating Code Generation to Reduce Errors and Effort
Author: Steve Cavill

(PDF) Automated Validation of Complex Clinical Trials Made Easy
Keywords: automated validation SAS COMPARE
Authors: Richann Watson; Josh Horstman

(PDF) Sending Text Messages from SAS®
Author: Matthew Slaughter

(PDF) Building Macros for Quick Survey Scoring
Authors: Vincent Chan; Lorena Ortiz

(PDF) Pinching Off Your SAS® Log: Shifting the Perception of “SAS® Logs” from a Post Hoc Validation Used Haplessly and Often Too Late…to a Dynamic Quality Control That Drives Exception Handling and Program Flow
Keywords: SAS, SAS logs, log analysis, real-time log analysis, PINCHLOG macro, SAS macro language, SAS macros, SYSTASK statement, PROC PRINTTO, PRINTTO statement
Author: Troy Martin Hughes

(PDF) A Quick Look at Fuzzy Matching Programming Techniques Using SAS® Software
Keywords: sas, matching, fuzzy matching, SAS functions, compare, compged, complev, spedis, author, sas author, sas press, sas press author, consultant, sas consultant, consulting, sas consulting, trainer, sas trainer, training, sas training, educator, sas educator, sloan, stephen sloan, lafler, kirk lafler, kirk paul lafler, @sasnerd
Authors: Kirk Paul Lafler; Stephen B. Sloan

The Future of the SAS® Platform
Author: Amy Peters

Analytics and Statistics

(PDF) Variance Ratio Estimation Using the PRECMOD SAS® Macro
Authors: Jesse A. Canchola; Pari Hemyari

(PDF) Maximizing Cross-Sell Opportunities with Predictive Analytics for Financial Institutions
Keywords: financial institution, cross-sell, targeted marketing, logistic regression
Author: Nate Derby

(PDF) A-NEST-ED Development: A One-Step PROC SQL Trick For Comparing Transactions To Their Own Summary Statistics Using Nested Functions
Author: Ahmed Khan

(PDF) Exploratory Analysis of the Factors Related to Gun Mortality
Authors: Gabrielle Ilenstine; Stephanie Mendoza; Evelyn Fox

(PDF) Examining the Performance of a Control Chart for the Shifted Exponential Distribution using Penalized Maximum Likelihood Estimators: A Simulation Study using SAS®
Authors: Austin Brown; Bryce Whitehead

(PDF) A Data Mining Approach for Developing Intervention Programs to Lessen Body Dissatisfaction and Promote Healthy Weight Management
Authors: Pitipa Chongwatpol; Jongsawas Chongwatpol

(PDF) Analyzing Multiple Membership Hierarchical Data Using PROC GLIMMIX
Authors: Maria Elsa Vazquez Arreola; Jeffrey Wilson

(PDF) Is My Model the Best? Methods for Exploring Model Fit
Author: Deanna Schreiber-Gregory

(PDF) Multicollinearity: What Is It and What Can We Do About It?
Author: Deanna Schreiber-Gregory

(PDF) Step Up Your Statistical Practice with Today’s SAS/STAT® Software
Author: Robert N. Rodriguez

(PDF) Five Things You Should Know about Quantile Regression
Author: Robert N. Rodriguez

(PDF) Propensity Score Methods for Causal Inference with the PSMATCH Procedure
Author: Maura E. Stokes

Propensity Score Matching: A Cautionary Tale
Author: Isaiah Lankham

Analyzing Categorical and Ordinal Data in the Presence of Missing Data: Application to Length of Stay in Social and Biomedical Studies
Authors: Niloofar Ramezani; Ali Ramezani

Applications Development

(PDF) Scripting to Automate Workflows
Authors: Chris Whalen; Amy Garrett

(PDF) 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
Keywords: SAS, software quality, software reusability, software reuse, reuse catalog, reuse library, SAS program files, SAS Enterprise Guide files, zip files, code comments, automatic code parsing
Author: Troy Martin Hughes

(PDF) NFL Data Analytics for a New Era
Author: Mitchell Collins

(PDF) Modernizing Legacy SAS® Applications and Program Code
Authors: Kirk Paul Lafler; Clark M. Roberts

(PDF) The Future of Transpose: How SAS® is Rebuilding its Foundation by Making What is Old New Again
Author: Scott Mebust

Beginner’s Techniques

(PDF) Importing CSV Data to All Character Variables
Keywords: PROC IMPORT, CSV, Character variables, MIXED= option
Author: Arthur L. Carpenter

(PDF) Many Means to a Mean
Keywords: column means, row means, DATA step, MEAN function, PROC MEANS, PROC TABULATE, PROC REPORT, PROC SQL
Author: Shannon Pileggi

(PDF) Learnings and Pitfalls from My EG Migration
Author: Kent Lewandowski

(PDF) Merge with Caution: How to Avoid Common Problems when Combining SAS® Datasets
Keywords: WUSS 2017
Author: Josh Horstman

(PDF) Using SAS® to Proactively Monitor Drug Alerts: Implementing the URAC “Drug-Drug Interactions” Measure for a Specialty Pharmacy
Author: Karen Wallace

(PDF) Programming Triage: Rooting Out Dataset Discrepancies in the Validation Process
Author: Julia Sturgeon

(PDF) Fifteen Functions to Supercharge Your SAS® Code
Author: Josh Horstman

(PDF) SAS® Abbreviation: The Snippets that Keep on Giving
Author: Robert Bikwemu

(PDF) Decision Trees: a Gentle Introduction
Author: Richard Hector

(PDF) One-to-One, One-to-Many, and Many-to-Many Joins Using PROC SQL
Keywords: SAS, SQL, PROC SQL, sql basics, proc sql basics, intro sql, intro proc sql, quick results sql, quick results proc sql, query, sql query, case expression, case sql, view, join, sql join, join sql, inner join, outer join, consultant, consulting, sas consultant, educator, sql consultant, sql consulting, sas author, sas press, sas press author, sql author, sql lafler, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd, software intelligence, software intelligence corporation, sas san diego, sql san diego, sas training, sas trainer, sql training, sql trainer, sas trainer san diego, sas training san diego, sql trainer san diego, sql training san diego
Authors: Charu Shankar; Kirk Paul Lafler

(PDF) An Easy Way to Split a SAS® Data Set into Unique and Non-Unique Row Subsets
Author: Thomas E. Billings

(PDF) Simplifying Effective Data Transformation Via PROC TRANSPOSE
Author: Arthur Xuejun Li

(PDF) Ten Things You Should Know About PROC FORMAT
Author: Jack N. Shoemaker

SAS® Jeopardy! (2017 Edition)
Author: Tasha Chapman

How SAS® Thinks: SAS® Basics I
Author: Susan J. Slaughter

Introduction to DATA Step Programming: SAS® Basics II
Author: Susan J. Slaughter

Introduction to SAS® Procedures: SAS® Basics III
Author: Susan J. Slaughter

Big Data and Data Science

(PDF) Nonlinear Modeling with Big Data in SAS® and JMP
Authors: Chong Ho Yu; Hyun Seo Lee; Siyan Gan; Emily Brown

(PDF) Next Best Offer Analytics using SAS®
Authors: Robin E. Way; William Eisenhauer

(PDF) Examining Distributional Shifts by Using Population Stability Index (PSI) for Model Validation and Diagnosis
Author: Alec Zhixiao Lin

(PDF) Integrating Health Data Sources to Identify, Stratify, and Predict High Utilizers of Public Systems
Authors: Benjamin Knisley; Joshua Morgan; Linn Carothers; Keith Haigh

(PDF) Using SAS® Enterprise Miner for Categorization of Customer Comments to Improve Services at the U.S. Postal Service
Author: Olayemi Olatunji

(PDF) Parallel Processing Your Way to Faster Software and a Big Fat Bonus: Demonstrations in Base SAS®
Keywords: SAS, parallel processing, multithreaded, multithreading, software performance, performance testing, divide and conquer, SYSTASK statement
Author: Troy Martin Hughes

(PDF) An Overview of SAS Visual Data Mining and Machine Learning on SAS® Viya™
Author: Radhikha Myneni

(PDF) Hi-Velocity SAS® Coding: Applying Engineering Principles to SAS® Programming Tasks
Author: Joe Perry

Data Management

(PDF) Creating a Data Dictionary Using Base SAS®
Author: Tasha Chapman

(PDF) Get Smart! Eliminate Kaos and Stay in Control – Creating a Complex Directory Structure with the DLCREATEDIR Statement, SAS® Macro Language, and Control Tables
Author: Louise Hadden

(PDF) A SAS® Format Catalog for ICD-9/ICD-10 Diagnoses and Procedures: Data Research Example and Custom Reporting Example
Author: Robert Springborn

(PDF) An Intro to PROC SQL: Simple & Complex Queries
Author: Melissa Navarro

(PDF) Five Ways to Flip-Flop Your Data
Author: Josh Horstman

(PDF) Database-ics II: Design, Standardize and Control the Process for Better Data Management
Author: Frank A. Ferriola, Jr.

E-Posters

(PDF) Identifying Unforeseen Strains on Local Health Care Ecosystems
Author: Evan Wallis

Categorical Data: Comparing SAS® and R for Logistic and Poisson Regression
Author: Lillian Chow

Uploading the IPEDS Human Resources Survey with SAS®
Author: Joyce Garcia

Visual Interpretation of Interaction Effects in Generalized Linear Mixed Model with PROC PLM from a Randomized Controlled Trial
Authors: Yingbo Ma; Kwa Sey

Moving Along in Health Research: Applying PROC EXPAND to Medical Encounter Data
Author: Rayna Matsuno

Lessons Learned in Building a Successful SAS® Business Analytic Program
Author: Wendy Wang

Validation of Regression Models in SAS®
Author: Mostafa Zahedjahromi

Hands-On-Workshops

(PDF) A Hands-On Introduction to SAS® DATA Step Hash Programming Techniques
Keywords: SAS, Hash, hash object, hash data step construct, how to sas hash, sas hash basics, hash methods, hash programming, hash technique, hash programming technique, match-merge, join, author, author lafler, sas author, sas press, sas press author, sas press author lafler, educator, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd
Author: Kirk Paul Lafler

(PDF) SAS® Studio: A New Way to Program in SAS®
Authors: Lora D. Delwiche; Susan J. Slaughter

(PDF) Modeling Longitudinal and Multilevel Data in SAS®
Author: Niloofar Ramezani

(PDF) Effectively Utilizing Loops and Arrays in the DATA Step
Author: Arthur Xuejun Li

(PDF) Analysis of Complex Survey Data with SAS®
Author: Christine Wells

(PDF) Working with the SAS® ODS EXCEL Destination to Send Graphs, and Use Cascading Style Sheets When Writing to EXCEL Workbooks
Author: William E. Benjamin, Jr.

(PDF) Doing More with the SAS® Display Manager: From Editor to ViewTable – Options and Tools You Should Know
Keywords: Display Manager, Enhanced Editor, ViewTable, SAS Explorer, WSAVE, GSUBMIT
Author: Arthur L. Carpenter

Industry Solutions

(PDF) Building a Member Centric World from a Transactional Data Galaxy
Author: Brian Mitchell

(PDF) Zeroing in on Effective Member Communication: An Rx Education Study
Author: Brian Mitchell

(PDF) The Cox Hazard Model for Claims Data
Authors: Samuel Berestizhevsky; Tanya Kolosova

(PDF) Avoiding Sinkholes: Common Mistakes During ADaM Data Set Implementation
Keywords: CDISC ADaM Implementation
Authors: Richann Watson; Karl Miller

(PDF) Validation Method Selection, Not Just a ‘Match’
Authors: Rituraj Saxena; Nina Worden

(PDF) SDTMs in a Medical Device Trial – A First Attempt
Author: Phil Hall

(PDF) Approaches in Loan and Vintage Level ROI Forecasting – A Consumer Lending Industry Perspective
Author: Sridhr Sankranti

(PDF) Standardized Approaches for Analyzing Quality Improvement Interventions in Healthcare Settings
Author: Polina Kukhareva

(PDF) Quality Control of Clinical Data Listings with PROC COMPARE
Authors: Robert Bikwemu; Nicole Wallstedt

(PDF) A Critique of Implementing the Submission Data Tabulation Model (SDTM) for Drugs and Medical Devices
Author: Carey G. Smoak

Professional Development

(PDF) A Review of “Free” Massive Open Online Content (MOOC) for SAS® Learners
Keywords: mooc, massive open online course, massive open online content, sas, worldwide classroom, sas classroom, sas university edition, sas u, support.sas.com, sascommunity, sascommunity.org, youtube, sas youtube channel, author, sas press, sas press author, consultant, sas consultant, consulting, sas consulting, trainer, sas trainer, training, sas training, lafler, kirk lafler, kirk paul lafler, @sasnerd
Author: Kirk Paul Lafler

(PDF) Show Me The Job!
Author: Richelle Serrano

(PDF) Job Upward Mobility: Getting Better When You’re Already Good
Author: Molly Meade Hall

(PDF) The Role of A Data Consultant at Kaiser Permanente
Author: Cyrus Davis

Planning WUSS 2018
Authors: Andra Northup; Nina Worden

Volunteering For the WUSS 2018 Conference
Authors: Andra Northup; Nina Worden

What I’ve Learned from Being the Academic Chair of WUSS
Author: Mary F. O. Rosenbloom

Reporting and Data Visualization

(PDF) Cell Growth Simulation using SAS®
Author: Karen Walker

(PDF) Creating Completely Automated Reports in SAS® Using the ODS RTF Destination: Protect Your Results from Human Error
Author: Debra A. Goldman

(PDF) Which Paint Brush Shall I Choose — Mapping Out Your Visualization Plan for Clinical Studies
Author: Chen Shi

(PDF) PROC DOC III: Self-Generating Codebooks Using SAS®
Author: Louise Hadden

(PDF) Data Exploration for Sweet Spots by Using Heat Maps in SAS®
Author: Alec Zhixiao Lin

(PDF) SAS/GRAPH® and GfK Maps: a Subject Matter Expert Winning Combination
Keywords: GfK, SAS/Graph, Maps
Author: Louise Hadden

(PDF) Red Rover, Red Rover, Send Data Right Over: Exploring External Geographic Data Sources with SAS®
Author: Louise Hadden

(PDF) Text Wrapping with Indentation for RTF Reports
Keywords: Text Wrapping, Indentation, RTF outputs
Author: Abhinav Srivastva

(PDF) Replay SG Graphs with IBACK in SAS/GRAPH®
Keywords: IBACK, GREPLAY, Replay multiple graphs
Author: Abhinav Srivastva

(PDF) Modernizing and Integrating SAS and non-SAS Tools and Systems for Behavioral Health Data Collection, Processing, and Reporting”
Authors: Manuel Gomez; Keith Haigh; Joshua Morgan

(PDF) Pattern of Adverse Events: The Use of Box Plot
Author: Jui-Fu Huang

(PDF) Maintaining ORDER in Your (PROC) Reporting
Author: Bill Coar

(PDF) PROC TABULATE Made Easy
Authors: Yunin Ludena; Elizabeth Guerrero Angel

(PDF) 2 Broken Axes in a Single Graph – That’s Crazy Talk – How to Use PROC TEMPLATE, SGRENDER, and SGANNO To Make Your Graphs Look Awesome
Keywords: PROC TEMPLATE. SGANNO. BROKEN AXIS, PROC SGRENDER, GRAPHING TEMPLATE LANGUAGE, GTL, FIGURE, PK, GRAPH, LATTICE
Author: Steven C. Black

(PDF) Making a Difference With SAS®
Authors: Humberto Cisneros; Carrin Huff

(PDF) Minimize PROC REPORT Time and Maximize Your Beach Time
Author: Nadira Babaeva

(PDF) A Method for Simultaneously Programming Mock and Computed Tables
Author: Michael Williams

(PDF) All Aboard! Next Stop is the Destination Excel
Author: William E. Benjamin, Jr.