WUSS 2019 Conference Proceedings

Seattle, Washington
September 4-6, 2019

Advanced Techniques

(PDF) Principles of Automation
Author: Robert Ellsworth

(PDF) Saving and Restoring Startup (Initialized) SAS System Options
Keywords: SAS, SAS System Options, options, PROC OPTSAVE, OPTSAVE, PROC OPTLOAD, OPTLOAD, Lafler, Kirk Paul Lafler
Author: Kirk Paul Lafler

(PDF) People Keep ASCIIng Me About These Characters
Authors: Daniel Konkler; Rebecca Bowermaster; Stephanie Sanchez

(PDF) Fun With The Fun King: The SAS Solution to the Magic Square
Author: Frank A. Ferriola, Jr.

(PDF) Tips for Correctly and Efficiently Comparing Two Files in SAS
Author: Aaron Brown

(PDF) Working with Sparse Matrices in SAS
Authors: Andrew T. Kuligowski; Lisa A. Mendez

(PDF) User-Defined Multithreading with the SAS DS2 Procedure: Performance Testing DS2 Against Functionally Equivalent DATA Steps
Keywords: SAS, PROC DS2, DS2 procedure, efficiency, performance, performance testing, performance evaluation, stress testing, load testing, parallel processing, multithreaded, multithreading, dive and conquer
Author: Troy Martin Hughes

(PDF) Proc Dtree VS Proc Hpsplit
Author: YuTing Tian

(PDF) Fifteen Functions to Supercharge Your SAS Code
Keywords: SAS programming DATA step functions
Author: Josh Horstman

Analytics and Statistics

(PDF) Limit of Detection (LoD) Estimation Using Maximum Likelihood from (Hit) Rate Data: The LoD_MLE SAS Macro
Authors: Jesse A. Canchola; Jeffrey E. Vaks; Shaowu Tang

(PDF) Measuring Test-Retest Reliability: The Intraclass Kappa
Authors: Dennis Fisher; Grace Reynolds-Fisher; Eric Neri; Arthur M. Noda; Helena Chmura Kraemer

(PDF) General, Age-Specific, and Total Fertility Rates in Montana, 2008-2017
Author: Matthew Ringel

(PDF) Automating a Summary Report of PSM Model and Match Results
Authors: Desiree Hall; Blake Krebs

(PDF) Statistical Power Calculations Using SAS Software
Author: Russell M. Lavery

(PDF) Using convergence status in a macro to iterate through a series of models
Author: Kristi Metzger

(PDF) Choosing Wisely: Using the Appropriate Statistical Test for Trend in SAS
Authors: Christina Park; Jui-Ting Hsiung; Melissa Soohoo; Elani Streja

(PDF) A strategy for speed Dating
Author: YuTing Tian

(PDF) Implementing the Hamiltonian Monte Carlo sampling algorithm in PROC MCMC
Authors: Elsa Vazquez Arreola; Jeffrey Wilson

(PDF) Variable Selection Using Random Forests in SAS
Author: Denis Nyongesa

(PDF) Polynomial Regression for Modeling Curvilinear Data: A Biological Example
Author: Elisha Johnston

Applications Development and Open Integration

(PDF) Writing to excel from SAS, DDE vs ODS
Author: Robert Ellsworth

(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

(PDF) Python applications in SAS programming for medical device clinical trial studies
Authors: Jianlin Li; Sherry Cao

(PDF) Connecting to Datasets through Python and SAS
Author: Joe Matise

(PDF) Git’r’done: Using Git in the production SAS environment
Author: Joe Matise

(PDF) SAS to Excel: ODS Tagsets to Hundred Files or Hundred Tabs
Author: Abdus Shahid

(PDF) Spec to Code in Seconds: Use Microsoft Excel for Repetitive Code Writing
Keywords: CONCATENATE, SAS, Microsoft Excel, CONCATENATE function, Pinky Anandani, Pinky Dutta, Pinky Anandani Duta, Repetitive Code Writing, Repetitive Coding in SAS, Repetitive Coding, If-Else Statements, Variable Label Statements
Author: Pinky Anandani Dutta

(PDF) Using SAS to enhance data sharing across REDCap projects: Reducing errors, streamlining management, and improving quality
Author: Rachel Myers

(PDF) Automating ADSL Programming Using Pinnacle 21 Specifications
Keywords: ADSL automation, Pinnacle 21 define specifications
Authors: Tracy Sherman; Aakar Shah

(PDF) 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
Keywords: SAS, software quality, risk management, quantiative risk evaluation, risk mitigation, technical debt, SAS program file, SAS EGP file, SAS Enterprise Guide, code comments, automatic code parsing
Author: Troy Martin Hughes

(PDF) Pipe it! Extract it! Build it!
Authors: Smitha Krishnamurthy; Sofia Shamas

(PDF) Python and R made easy for the SAS Programmer
Authors: Janet Li; Varaprasad Ilapogu

(PDF) Using Jupyter to Take Your Data Science Workflow to the Next Level
Keywords: SAS, Jupyter, Notebook
Author: Hunter Glanz

Beginner’s Techniques

(PDF) Counting The Work Days Until .
Author: Robert Ellsworth

(PDF) Order, Order! Four Ways to Reorder Your Variables, Ranked by Elegance and Efficiency
Keywords: SAS, Reorder Variables, Data Step, PROC SQL, Deliverable, Efficiency
Author: Louise Hadden

(PDF) Writing Code With Your Data
Author: Joe Matise

(PDF) Quote the SASLOG
Keywords: Base SAS, PROC FORMAT, MERGE, JOIN
Author: Andrew T. Kuligowski

(PDF) Easy Solutions To %LET You Reduce Repetitive Programming
Author: Ekaterina Roudneva

(PDF) Like, Learn to Love SAS Like
Keywords: SAS, Reorder Variables, Data Step, PROC SQL, Deliverable, Efficiency
Author: Louise Hadden

(PDF) Merge with Caution: How to Avoid Common Problems when Combining SAS Datasets
Keywords: SAS merge merging data step programming program data vector
Author: Josh Horstman

(PDF) Keyboard Macros! An awesome tool you may have never heard of – once you do, you will never program the same again (It’s that amazing!)
Keywords: SAS Keyboard Macros, Keyboard Abbreviations, Keyboard Shortcuts
Author: Steven C. Black

(PDF) A Strategy for Dealing with Pinnacle 21 Errors and Warnings
Author: Carey G. Smoak

Big Data and Data Science

(PDF) TB Fuzzy-Matches Made Easy: Designing shareable SAS code to accurately and efficiently identify exact and close genetic matching tuberculosis isolates
Author: Evan Timme

(PDF) Multi-way Splits in Decision Trees Where The Dependent Variable Has More Than Two Levels
Authors: Russell M. Lavery; YuTing Tian

(PDF) Better To Be Mocked Than Half-Cocked: Data Mocking Methods To Support Functional and Performance Testing of SAS Software
Keywords: SAS, data mocking, performance testing, load testing, stress testing, performance evaluation, efficiency, efficiency testing
Author: Troy Martin Hughes

(PDF) Bayesian Nonparametric Clustering in SAS
Author: Hend Aljobaily

Business Analytics

(PDF) Analyzing factors influencing viewer count of TED Talks through Text Analytics
Authors: Yasha Pastaria; Miriam McGaugh

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

(PDF) Loan Default Prediction
Authors: Amarjeet Cheema; Miriam McGaugh

(PDF) Telecom Industry : Customer Churn Prediction
Authors: Aakash Dwivedi; Miriam McGaugh

(PDF) Who Do We Need to Follow-Up With? Developing a Process to Track Study Response Rates
Author: Vincent Chan

Data Management

(PDF) Getting the Message Across: Cutting Run Times and Updating Databases with SAS/ACCESS
Author: Elise Mara

(PDF) Tis better to give than receive: considerations when sharing data
Author: Melissa R. Pfeiffer

(PDF) Tips for the lazy typist (and other strategies for smart coding)
Authors: Melissa R. Pfeiffer; Kristi Metzger

(PDF) Should You Move Your SAS Into the Cloud?
Keywords: SAS 9.4 CLOUD INSTANCE CONTAINER VIRTUALIZATION VIYA AWS
Author: Paul Janssen

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) A HOW on Hashing
Author: Russell M. Lavery

(PDF) Interactive Graphs!
Keywords: Drill-down, ODS Graphics, DRILLTARGET, SGRENDER, PROC TEMPLATE
Authors: Richann Watson; Kriss Harris

(PDF) Everything is better with friends: Executing SAS code in Python scripts with SASPy
Keywords: Western Users of SAS Software (WUSS) 2019 Hands-on Workshop, SASPy, SAS University Edition, Python, Open-Source Software, JupyterLab
Authors: Isaiah Lankham; Matthew Slaughter

(PDF) Doing More with the SGPLOT Procedure
Keywords: PROC SGPLOT, SAS, statistical graphs
Author: Josh Horstman

(PDF) PARSING: Using SAS When the Data Are Hiding in a Non-Standard Format
Author: Andrew T. Kuligowski

Industry Solutions

(PDF) Validate the validated: A python script for study leads to review clinical outputs
Authors: Varaprasad Ilapogu; Janet Li; Masaki Mihaila; Ernesto Gutierrez

(PDF) Stay Ahead of the Curve: How to implement New FDA Recommendation Study Data Standardization Plan (SDSP) in your organization?
Authors: Aakar Shah; Heather Riley

(PDF) Root Cause Analysis Using Pinnacle 21 Validation Reports: How to Improve End-to-End Programming Processs
Authors: Aakar Shah; Tracy Sherman

(PDF) Bespoke outputs, just like everyone else s: using the SAS Macro Language to create template programs for standard presentations of your client s clinical trial data
Author: Sean-Paul Claypool

Professional Development

(PDF) Are you Ready? Preparing and Planning to Make the Most of your Conference Experience
Keywords: Prepare, Plan, Conference, Travel, Dietary, Network
Authors: Richann Watson; Louise Hadden

(PDF) One Boys Dream: Hitting a Homerun in the Bottom of the Ninth Inning
Author: Carey G. Smoak

(PDF) A Fun (if Snarky) Look at SAS Certification Exams
Author: Aaron Brown

(PDF) 20 Years of Success and Failure to Learn From, the Best and Worst
Author: Bob J. Hull

(PDF) Transporting Your SAS Content to SAS Communities and Integrating Your Content into GitHub
Keywords: SAS, Reorder Variables, Data Step, PROC SQL, Deliverable, Efficiency
Author: Louise Hadden

Reporting and Visualization

(PDF) Great Time to Learn GTL: A Step-by-Step Approach to Creating the Impossible
Keywords: ODS Graphics, GTL, GRAPH TEMPLATE LANGUAGE, LAYOUT, OVERLAY, GRIDDED
Author: Richann Watson

(PDF) Modern data visualization for SAS users
Author: Jay Ahn

(PDF) Simple Steps for Great Graphics: Beyond the Default Settings for More Effective Data Visualization
Author: Kristi Metzger

(PDF) Building Blocks of Beautiful ODS RTF Destination Reports: Using Microsoft Word s Heading System to Add an Outline Content Pane
Author: Debra A. Goldman

(PDF) Using SAS Visual Analytics to Effectively Visualize Health Care Data
Authors: Scott P. Leslie; Donavin Drummond

(PDF) Have it Your Way: Using the ODS Excel Destination with the Data Step Report Writing Interface
Author: Peter J. Lund

ePosters

(PDF) Using Factor Analysis and Multivariate Analysis of Variance to Explore Academic Achievement in the 2016 Monitoring the Future Study
Author: Stefanie Kairs

(PDF) LaTeX and SAS for creating and assembling Data Monitoring Committee reports
Author: Adam Omidpanah

(PDF) Ordinal vs. Multinomial. Does model selection make a difference?
Author: Corey Leadbeater