WUSS 2018 Conference Proceedings

Sacramento, California
September 5-7, 2018

Beginner Techniques

(PDF) Essential Programming Techniques Every SAS® User Should Learn
Keywords: sas, essential sas, sas programming, sas efficiency, sas performance, author, sas press author, Lafler, Kirk Paul Lafler, sasNerd
Author: Kirk Paul Lafler

(PDF) Bring the Vampire out of the Shadows: Understanding the RETAIN and COUNT functions in SAS
Keywords: SAS RETAIN COUNT
Author: Steven C. Black

(PDF) Dating for SAS Programmers
Author: Josh Horstman

(PDF) Let’s Talk About Variable Attributes
Author: Elizabeth Guerrero Angel

(PDF) PROC DATASETS;The Swiss Army Knife of SAS® Procedures
Author: Michael A. Raithel

Beyond the Basics

(PDF) Introduction to Data-driven Programming Using SAS®
Keywords: SAS, data-driven, data driven, metadata, sas metadata, DICTIONARY, DICTIONARY tables, system tables, SASHELP views, system views, author, sas press, sas press author, consultant, sas consultant, sql, sql consultant, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd
Author: Kirk Paul Lafler

(PDF) Case Study: Using Base SAS to Automate Quality Checks of Excel Workbooks that have Multiple Worksheets
Authors: Lisa A. Mendez; Andrew T. Kuligowski

(PDF) Efficient Use of Disk Space in SAS® Application Programs
Keywords: data sets, disk space, efficiency, SQL, PROC COPY, PROC DATASETS, encryption
Author: Thomas E. Billings

(PDF) Wow! You Did That Map With SAS®?! Round II
Author: Louise Hadden

(PDF) How to automatically cover arbitrary changes Using automatic code generation method in SAS Enterprise Guide
Author: Kaiqing Fan

(PDF) Using Memory Resident Hash Tables to Manage Your Sparse Lookups
Keywords: Metadata, Macro Language, Hash Object, PROC FCMP, Control Files, %SYSCALL, %SYSFUNC
Author: Arthur L. Carpenter

(PDF) Name that Function: Punny Function Names with Multiple MEANings and Why You Do Not Want to be MISSING Out
Keywords: DATA step, Functions
Author: Arthur L. Carpenter

(PDF) How Best to Use Macro Quoting Functions
Author: Arthur Xuejun Li

(PDF) A Simple Method for Colorizing Saved Log Files
Author: Matthew Slaughter

(PDF) Ron Fehd, SAS-L’s Macro Maven, Answers Your Questions on Macros or Reusable Program Development
Author: Ronald J. Fehd

(PDF) Advanced Programming Concepts: History of the List Processing and Cardinality Ratio Memes
Author: Ronald J. Fehd

(PDF) Stop the Madness! Detecting Runtime Errors and Exiting from Nested Macros Gracefully
Author: Ted Williams

(PDF) This Too Shall Pass: Passing Simple and Complex Parameters In and Out of Macros
Author: Ted Williams

(PDF) Cell Growth Simulation Using SAS Software
Author: Karen Walker

(PDF) Data-Driven Data Analysis
Author: Jack N. Shoemaker

(PDF) Confessions of a SAS Proc SQL Instructor
Author: Charu Shankar

(PDF) IMPORTING DATA WITH DDE (Dynamic Data Exchange) Or Proc Import?
Author: Humberto Cisneros

(PDF) Is Really No PR Bad PR? Debunking the Myth
Authors: Imran Selim; Devanand Chintoju

(PDF) OUT= is in: Visualizing PROC COMPARE Results in a Dataset
Authors: Varaprasad Ilapogu; Masaki Mihaila

(PDF) Stay Connected to Work Away from Work: A Simple Approach to Send Emails from SAS® using VBScript
Author: Nikita Sathish

(PDF) Automating SAS Job Streams with the Power of VB Script
Authors: Lindsey Whiting; Joey Kaiser

(PDF) The Missing Link: A Robust Macro for Recoding General Missing Data Values
Authors: Hunter Glanz; Josh Horstman

(PDF) Abstracting and Automating Hierarchical Data Models: Leveraging the SAS® FORMAT Procedure CNTLIN Option To Build Dynamic Formats That Clean, Convert, and Categorize Data
Keywords: SAS, PROC FORMAT, FORMAT procedure, CNTLIN option, control table, control data set, hierarchical data model, data taxonomy, data mapping, multimap, SAS macro language, DSM-5
Author: Troy Martin Hughes

(PDF) The Doctor Ordered a Prescription…Not a Description: Driving Dynamic Data Governance Through Prescriptive Data Dictionaries That Automate Quality Control and Exception Reporting
Keywords: SAS, data dictionary, prescriptive data dictionary, descriptive data dictionary, control table, control data set, data model, business rules, SAS macro language, SAS macros, Will Ferrell
Author: Troy Martin Hughes

(PDF) Validating User-Submitted Data Files with Base SAS®
Keywords: validating, validation, QC, specs, specifications, PROC COMPARE, PROC APPEND, audit, integrity constraints
Author: Michael A. Raithel

(PDF) PROC SORT (then and) NOW
Author: Derek P. Morgan

(PDF) A Survey of Some of the Most Useful SAS Functions
Author: Ron Cody

(PDF) Deep neural nets in SAS Enterprise Miner
Author: Russell M. Lavery

(PDF) Extend the Power of SAS® to Use Callable VBS and VBA Code Files Stored in External Libraries to Control Excel Formatting Routines and SAS ODS Excel Destination Commands
Keywords: SAS, Excel, VBA, VBS
Author: William E. Benjamin, Jr.

Using SAS to Perform in-database Programming in Teradata
Authors: Michael Johnston; Paul Segal

Career Development & Leadership

(PDF) A Walk through Time: Growing Your SAS Career
Keywords: INTCK, INTNX, MDY, Timeline, SAS Programming Career Development
Author: Arthur L. Carpenter

(PDF) So You Want To Be An Independent Consultant
Author: Josh Horstman

(PDF) How to land work as a SAS professional
Author: Charu Shankar

(PDF) Something Old, Something New: A little programming management can go a long way
Authors: Janet Li; Aakar Shah

(PDF) Innovation and Your Career in a Rapidly Changing World of Job Titles: How Different is Data Scientist from What I Do?
Author: Richelle Serrano

(PDF) From Student to Expert: Leveraging SAS Conferences as Professional Development Opportunities
Author: Deanna Schreiber-Gregory

(PDF) The Hidden Job Market: Tips and Techniques to Advance Your SAS® Career
Author: Molly Meade Hall

Data Analytics & Statistics

(PDF) Parallel Processing with Base SAS
Author: Jim Barbour

(PDF) Using PROC MCMC in a Process Control Setting: An Illustrative Example with PROC IML
Author: Austin Brown

(PDF) Oops, I D-I-D It Again! Advanced Difference-in-Differences Models in SAS®
Authors: E. Margaret Warton; Melissa Parker

(PDF) Non-parametric Analysis of the Variance in SAS®
Author: Hend Aljobaily

(PDF) SAS Techniques to Handle Large Files And Reduce Execution times
Author: Kaiqing Fan

(PDF) Analyzing international assessments: An ensemble and model comparison approach
Authors: Chong Ho Yu; Hyun Seo Lee; Siyan Gan; Emily Lara

(PDF) “Training Wheels” for learning mixed models
Authors: YuTing Tian; Russell M. Lavery

(PDF) Forecasting tourist’s arrivals to the USA with SARIMA models.
Author: Mostafa Zahedjahromi

(PDF) A latent variable location scale model for intensive longitudinal data
Author: Shelley Blozis

(PDF) When the Mean Isn’t Enough: Methods for Assessing Individual Differences using SAS
Author: Melissa McTernan

(PDF) Modeling Heterogeneous Within-Subject Variability
Authors: Madeline Craft; Shelley Blozis

(PDF) Crime in the USA: Using SAS to Analyze Recidivism Rates
Author: Philip Mayevskiy

(PDF) Agreeing to Disagree: Using SAS to Make Reasoned Decisions When Information Criteria Select Different Models
Author: Wendy Christensen

(PDF) Machine Learning – Why we should know it and how it works
Author: Kevin Lee

(PDF) Markov Chains as a Predictive Analytic Approach Using SAS/IML
Author: Gregory McKinney

(PDF) Logistic and Linear Regression Assumptions: Violation Recognition and Control
Author: Deanna Schreiber-Gregory

(PDF) Regularization Techniques for Multicollinearity: Lasso, Ridge, and Elastic Nets
Author: Deanna Schreiber-Gregory

(PDF) From FREQing Slow to FREQing Fast: Facilitating a Four-Times-Faster FREQ with Divide-and-Conquer Parallel Processing
Keywords: SAS, PROC FREQ, FREQ procedure, FREQFAST, multithreading, multithreaded, parallel processing, divide and conquer, efficiency, performance, performance testing, stress testing, software runtime, software speed, SYSTASK statement, SAS macro language, SAS macros
Author: Troy Martin Hughes

(PDF) Time Series Analysis of Hate Speech in Social Media
Author: David J. Corliss

(PDF) Forecasting: Something Old, Something New
Author: David A. Dickey

Taking XML’s Measure: Using SAS® to Read In and Create XML for Analytic Use and Websites
Author: Louise Hadden

Hands-on Workshops

(PDF) Advanced Programming Techniques Using the DS2 Procedure
Author: Viraj R. Kumbhakarna

(PDF) Animate your Data!
Keywords: Animation, Proc SGPLOT, SAS, Data Visualization, animation=start, animduration=0.5, animloop=yes, noanimoverlay, Proc Expand, Expand, Interpolation
Authors: Richann Watson; Kriss Harris

(PDF) Getting Started with the SGPLOT Procedure
Keywords: PROC SGPLOT, SAS, ODS, statistical graphics
Author: Josh Horstman

(PDF) The shape of SAS code
Author: Charu Shankar

(PDF) Survey data analysis made easy with SAS: a hands-on workshop
Authors: Melanie Dove; Katherine Heck

(PDF) The ODS Excel Destination: Assorted Tips and Techniques to Simplify Writing SAS(R) Data to Excel Workbooks
Author: William E. Benjamin, Jr.

Everything is better with friends: Executing SAS code in Python scripts with SASPy
Authors: Isaiah Lankham; Matthew Slaughter

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

Industry Solutions

(PDF) Customized Sharing Settings to Improve the Sustainability of HIEs: An Experimental Approach Using SAS
Author: Mohamed Abdelhamid

(PDF) Generating Variable Attributes for Define 2.0
Keywords: Define 2.0, Data Types, Variable attributes, Define XML
Author: Abhinav Srivastva

(PDF) The Anatomy of Artificial Intelligence Solution for Automation of Underwriting Decision-Making Process.
Keywords: SAS®, underwriters’ performance metrics, artificial intelligence, stochastic machine-learning classification, SVM, Firth penalized regression, data structure, workers compensation insurance, automation of underwriting decision-making process.
Authors: Samuel Berestizhevsky; Tanya Kolosova

(PDF) Using a lookup table to transform electronic laboratory results into standardized case-specific information to manage a record-breaking flu season
Authors: Rachel Perry; Laura Erhart; Shane Brady

(PDF) Combined Predictor Selection for Multiple Clinical Outcomes Using PHREG
Authors: L. Grisell Diaz-Ramirez; Siqi Gan; Sei Lee; Alexander Smith; John Boscardin

(PDF) Dependency Macro: Ensuring data reliability in healthcare analytics
Authors: Lissa Bayang; Wayne Leonetti

(PDF) Using Net Lift Measure to Model the Effects of Changes in Interest Rates on Mortgage Prepayment
Authors: Alec Zhixiao Lin; Xiao Hu

(PDF) Interpreting electronic health data using SAS PRX functions
Authors: Amy Alabaster; Mary Anne Armstrong

(PDF) Interactive Live Clinical Data Monitoring Dashboards with Drill-Down Using SAS & Microsoft Excel
Authors: Parmodh Sharma; Ankit Bansal; Parvesh Boora

(PDF) How FDA will reject non-CDISC submission
Keywords: CDISC FDA rejection RTF eCTD eSubmission
Author: Kevin Lee

(PDF) Dissecting the Burnout Factor for Modeling Mortgage Refinancing
Author: Alec Zhixiao Lin

(PDF) A Macro to Avoid P21 FDAC036 Error Message for Regulatory Submission Datasets
Authors: Venkata N Madhira; Prabhakara Rao Burma

(PDF) Formatting outputs for clinical trial data to aid in readability
Authors: Lingjiao Qi; Bharath Donthi

(PDF) Defensive programming techniques for ongoing clinical studies
Authors: Bharath Donthi; Lingjiao Qi

(PDF) How sensitive is your analysis? A case study on addressing it at ADaM level.
Keywords: ADaM, PRO, Sensitivity Analysis, SDTM, Missing Data, LOCF, Clinical Trials, WOCF, Imputation.
Authors: Bhargav Koduru; Balavenkata Pitchuka

(PDF) CDISC in Phase I/II Studies: Approaches to adopting standards for CSR deliverables
Authors: Emily Woolley; Amber Randall

(PDF) A Macro Tool to Find and/or Split Variable Text String Greater Than 200 Characters for Regulatory Submission Datasets.
Authors: Venkata N Madhira; Harish Yeluguri

Avoiding Mistakes in CDISC Implementation
Authors: Richann Watson; Carey G. Smoak

Annotations of SDTM CRFs
Author: Maria Paz

Reporting & Data Visualization

(PDF) Making Your SAS® Results, Reports, Tables, Charts and Spreadsheets More Meaningful with Color
Keywords: sas, ods, graphs, statistical graphics, sgplot, sgpanel, sgscatter, programmer, sas programmer, author, sas press, sas press author, consultant, sas consultant, consulting, sas consulting, educator, sas educator, trainer, sas trainer, training, sas training, lafler, kirk lafler, kirk paul lafler, @sasnerd
Author: Kirk Paul Lafler

(PDF) Building Dashboard with Base SAS – Institutional Research Experience
Author: Abdus Shahid

(PDF) Customizing and Automating your Graphs using the SAS SG Procedures
Authors: Jesse A. Canchola; Alen Dzidic; Shiva Narra

(PDF) Connecting the Dots: Using ODS RTF ANCHORS, ODS RTF BOOKMARKS, and Table of Contents to Guide Readers Through Your SAS® RTF Reports
Author: Debra A. Goldman

(PDF) Better than Average: Calculating Geometric Means Using SAS®
Author: Kim Roenfeldt

(PDF) Use of SAS® Graph Template Language (GTL) and HIGHLOWPLOT to Create a Next-Generation Sequencing Multi-Gene Panel Grid
Author: John Bennett

(PDF) Never Cut and Paste Results Again: How to Automate Results with ODS PowerPoint, Metadata and Macros
Author: Ted Williams

(PDF) DOMinate your ODS Output with PROC TEMPLATE, ODS Cascading Style Sheets (CCS), and the ODS Document Object Model (DOM) by Mastering ODS TRACE DOM, Parsing CSS with a PROC TEMPLATE Front End, and Overriding ODS Style Inheritance with Customized Styles
Keywords: document object model (DOM), output delivery system (ODS), PROC REPORT, report style, configuration, data-driven programming, data-driven software design
Authors: Louise Hadden; Troy Martin Hughes

SAS Essentials

(PDF) How SAS Thinks: SAS Basics I
Author: Susan J. Slaughter

(PDF) Introduction to DATA Step Programming: SAS Basics II
Author: Susan J. Slaughter

(PDF) Introduction to SAS Procedures: SAS Basics III
Author: Susan J. Slaughter

ePosters

(PDF) Creating BDS DERIVED parameters for a subject-level frequency summary table? Then this macro can be useful
Author: Masaki Mihaila

(PDF) Password Protection of SAS® Enterprise Guide® Projects
Keywords: SAS Enterprise Guide, passwords, security, metadata
Author: Thomas E. Billings

(PDF) Let’s Get FREQy with our Statistics: Data-Driven Approach to Determining Appropriate Test Statistic
Keywords: FREQ, Cochran-Armitage, Binomial Proportion Confidence Intervals, Data-Driven, Test Statistic
Authors: Richann Watson; Lynn Mullins

(PDF) Great Time to Learn GTL
Keywords: ODS Graphics, GTL, GRAPH TEMPLATE LANGUAGE, LAYOUT, OVERLAY, GRIDDED
Authors: Richann Watson; Kriss Harris

(PDF) Purrfectly Fabulous Feline Functions
Author: Louise Hadden

(PDF) Create Cupid Arrow into Two Love Hearts Image Using SAS PROC TEMPLATE — For the Valentine’s Day
Author: Kaiqing Fan

(PDF) Use of PROC Tabulate Out File to Customize Tables
Author: Abdus Shahid

(PDF) Pick a Treatment, Any Treatment! Using Discrete Choice Experiments to Analyze Treatment Preferences.
Author: Cynthia Alvarez

(PDF) Automate Repetitive Programming Tasks: Effective SAS® Code Generators
Keywords: “SAS Code Generator, Call Execute, Macro Variable, Create Data Set Label”
Author: Yun (Julie) Zhuo

(PDF) An Efficient Way to Output Univariate Analysis Results with Multiple Predictors
Authors: Bocheng Jing; Kathy Fung; John Boscardin

(PDF) The Inevitable Use of RETAIN Statement in Multiple Scenarios with Examples for Creating Efficacy Parameters
Authors: Prabhakara Rao Burma; Venkata N Madhira

(PDF) Optimizing Exam Schedules at Oklahoma State University
Author: Thu Nguyen

The Relationship Between Psychological Distress and the Initiation of Tobacco Use Among Young Adults 18 to 29 Years
Authors: Sarah Mendez; Marie Boman-Davis

Becoming A Master Manipulator: Using Macro Functions To Manipulate SAS Enterprise Guide Date Prompts
Author: Edward Lan