WUSS 2023 Conference Proceedings
San Diego, California
October 31 – November 2, 2023
Advanced Programming & Techniques
APT-101. Going Command(o): Power(Shell)ing Through Your Workload
Richann Watson, DataRich Consulting
Louise Hadden, Abt Associates Inc.
APT-104. Calculate Physical Length of String in RTF file with Times New Roman’ by SAS
Yueming Wu, Astex Pharmaceuticals
Steven Li, Medtronic PLC.
APT-105. 10 Tips for Getting Tipsy with SAS
Lisa Mendez, Catalyst Clinical Research
Richann Watson, DataRich Consulting
APT-107. How to Assemble Macros from Metadata and Execute them
Karen Walker, Walker Consulting LLC
APT-109. The Great Escape(char)
Louise Hadden, Abt Associates Inc.
APT-121. Running Parts of a SAS Program while Preserving the Entire Program
Stephen Sloan, Accenture
APT-128. Creating Dated Archive Folders Automatically with SAS
Derek Morgan, Bristol Myers Squibb
APT-129. Demystifying Intervals
Derek Morgan, Bristol Myers Squibb
APT-145. With a View to Make Your Metadata Function(al): Exploring SAS Sources of Information on SAS Formats
Louise Hadden, Abt Associates Inc.
APT-150. Wrangling Excel Worksheets
Tom Kari, Unknown
APT-156. Table Lookup by Enclosing Hash in FCMP
Wenyu Hu, Merck Sharp & Dohme
APT-157. TARDIS: Tracking Alterations and Record Differences in SAS, a Macro to Add Color to Your Dataset Comparisons
Inka Leprince, PharmaStat, LLC
APT-166. Undo SAS Fetters with Getters and Setters: Supplanting Macro Variables with More Flexible, Robust PROC FCMP User-Defined Functions That Perform In-Memory Lookup and Initialization Operations
Troy Martin Hughes, Datmesis Analytics
APT-171. Picking Scabs and Digging Scarabs: Refactoring User-Defined Decision Table Interpretation Using the SAS Hash Object To Maximize Efficiency and Minimize Metaprogramming
Troy Martin Hughes, Datmesis Analytics
Louise Hadden, Abt Associates Inc.
APT-172. Automating Reports Using Macros and Macro Variables
Ekaterina Roudneva, UC Davis
APT-174. Waterfall vis a vis Spider plots: Complex oncology efficacy endpoint made simpler.
Yoganand Budumuru, IQVIA
APT-187. Leveraging Teradata ClearScape Analytics to Improve ROI
Gregory Goralski, Teradata
Paul Segal, Teradata
APT-189. A SAS Code Hidden in Plain Sight
[Additional Materials (ZIP Archive)]
Bart Jablonski, yabwon
APT-209. List Processing using SQL Select Into to Replace Call Symputx Creating Indexed Arrays of Macro Variables
Ronald Fehd, Fragile-Free Software
APT-210. A Batch Processing Companion, how to write Windows *.bat and *.cmd files for my-program.sas
Ronald Fehd, Fragile-Free Software
APT-214. List Processing Macro Call-Macro
Ronald Fehd, Fragile-Free Software
APT-227. Tapping the Power of PRX Functions in SAS 9.4 and in SAS Viya
John LaBore, SAS
Edwin Xie, SAS
APT-228. Super Demo:Getting Started with Bayesian Analysis
(No paper available)
Danny Modlin, SAS
APT-229. Super Demo: Sandwich Your SAS Data Set to Excel Pivot Tables
(No paper available)
Charu Shankar, SAS Institute
APT-230. Super Demo: Missing Data and Proc MCMC
(No paper available)
Danny Modlin, SAS
APT-231. Super Demo: Tips and Tricks for Sending Emails Using SAS
(No paper available)
Chris Hemedinger, SAS
APT-232. Super Demo: How Do I Debug in SAS Data Step
(No paper available)
Chris Hemedinger, SAS
Analytics & Statistics
AS-102. Blinding Indexes – Generalized and Unified Framework – a SAS Macro
Eduard Poltavskiy, NA
Rima Nandi, Herbert Wertheim School of Public Health, University of California, San Diego, USA
Jeehyoung Kim, Department of Orthopedic Surgery, Seoul Sacred Heart General Hospital, Seoul, Korea
Heejung Bang, Division of Biostatistics, Department of Public Health Sciences, University of California, Davis, CA, USA
AS-108. Introduction to Machine Learning – Descriptions and Best Practices
Jim Box, SAS Institute
AS-113. Regression Analysis Made Easy Using SAS Studio
Kirk Paul Lafler, sasNerd
Zheyuan Walter Yu, Optimus Dental Supply
Nuoer Lu, University of North Carolina at Chapel Hill
Nicklas (Rebel) Yee, University of Washington, Seattle
Yanzhang Gavin Chen, University of California, Los Angeles
Kai Kang, University of California, Berkeley
AS-117. Dashboard Development: From Prepping to Visualizing Data
Bert Cisneros, Arizona Supreme Court – Adminstrative Office of the Courts
Richard Rivera, Arizona Supreme Court
AS-119. Advanced Project Management beyond Microsoft Project, Using PROC CPM, PROC GANTT, and Advanced Graphics
Stephen Sloan, Accenture
Lindsey Puryear, SAS Institute
AS-126. A unique and innovative end-to-end demand planning and forecasting process using a collection of SAS products
Stephen Sloan, Accenture
Kevin Gillette, Accenture Federal Services
AS-158. Univariate Outlier Detection Using SAS
Fan Yang, Johnson and Johnson Vision
AS-164. The Delta Method in Statistical Inference, with Applications in the SAS IML Procedure
Carter Sevick, Division of Health Care Policy and Research, School of Medicine, University of Colorado Anschutz Medical Campus, Aurora, Colorado, USA
Camille Moore, Center for Genes, Environment and Health, National Jewish Health, Denver, Colorado, USA
Samantha MaWhinney, Department of Biostatistics, Colorado School of Public Health, University of Colorado Anschutz Medical Campus, Aurora, Colorado, USA
AS-170. Sorting a Bajillion Variables: When SORTC and SORTN Subroutines Have Stopped Satisfying, User-Defined PROC FCMP Subroutines Can Leverage the Hash Object to Reorder Limitless Arrays
Troy Martin Hughes, Datmesis Analytics
AS-175. What’s next after model comparison? Model selection and model averaging in SAS
Chong Ho Yu, Hawaii Pacific University
Charlene Yang, Azusa Pacific University
AS-178. Unraveling the Layers within Neural Networks: Designing Artificial and Convolutional Neural Networks for Classification and Regression Tasks using TensorFlow in Python
Ryan Lafler, Premier Analytics Consulting, LLC
Anna Wade, Premier Analytics Consulting, LLC
AS-196. Creating and Customizing High-Impact Excel Workbooks from SAS with ODS EXCEL
Josh Horstman, Nested Loop Consulting
AS-203. Survey Data Analysis in SAS
Denis Nyongesa, KAISER PERMANENTE
Marianne Jurasic, Boston University
Gregg Gilbert, University of Alabama at Birmingham
Tamara Lischka, Kaiser Permanente Center for Health Research
AS-216. D-I-D the policy have an impact? Difference-in-difference methods applied to survey data in SAS
Melanie Dove, UC Davis
AS-219. Data Wrangling and Descriptive Statistics
(No paper available)
Tom Grant, SAS
AS-221. Tales from a Tech Support Guy: The Top Ten Most Impactful Reporting and Data Analytic Features for the SAS Programmer
(No paper available)
Chevell Parker
AS-223. Quick Start to Mixed Modeling
(No paper available)
Danny Modlin, SAS
AS-226. Leveraging Logistic Regression and Bootstrap Sampling to Assess a Decision Threshold in Classification Predictive Analytics
Colleen McGahan, BC Cancer Agency
Beginner’s Techniques
BT-112. Data Access Made Easy Using SAS Studio
Kirk Paul Lafler, sasNerd
Shaonan Wang, Columbia University
Nuoer Lu, University of North Carolina at Chapel Hill
Zheyuan Walter Yu, Data Analyst and Biostatistics Professional Optimus Dental Supply
Daniel Qian, Ten Square International, Inc.
Swallow Xiaozhe Yan, President, US Education Without Borders
BT-130. The Essentials of SAS Dates and Times
Derek Morgan, Bristol Myers Squibb
BT-193. The 5 CATs in the Hat Sleek Concatenation String Functions
Kirk Paul Lafler, sasNerd
Data Management & Administration
DMA-110. How To Easily Ingest (Lots Of) External Data Into The SAS Ecosystem By Only Setting One Parameter – Welcome to Data Ingestion Auto Pilot (DIAP)
Stephan Weigandt, SAS Institute
DMA-120. Reducing the space requirements of SAS data sets without sacrificing any variables or observations
Stephen Sloan, Accenture
DMA-122. Getting a Handle on All of Your SAS 9.4 Usage
Stephen Sloan, Accenture
DMA-161. Processing Large Volumes of Communicable Disease Data: SAS Techniques from the COVID-19 Experience in San Diego County
Whitney Webber, County of San Diego
Nathaly Moran, County of San Diego
Jacob Ritz, County of San Diego
Fatema Sakha, County of San Diego
Jacquelyn Ho, County of San Diego
Jennifer Nelson, County of San Diego
DMA-167. Make You Holla’ Tikka Masala: Creating User-Defined Informats Using the PROC FORMAT OTHER Option To Call User-Defined FCMP Functions That Facilitate Data Ingestion Data Quality
Troy Martin Hughes, Datmesis Analytics
DMA-207. SAS Outputs as the Hub of Your Organization’s Data Ecosystem
Michael Aleman, WUSS
DMA-213. Q&A with the Macro Maven: Do we need Macros? An Essay on the Theory of Application Development
Ronald Fehd, Fragile-Free Software
DMA-220. The SAS Viya ETL Playbook
(No paper available)
Charu Shankar, SAS Institute
DMA-222. How Do I Read and Write Excel Files Using SAS?
(No paper available)
Chris Hemedinger, SAS
e-Posters
PO-114. Soft Skills to Gain a Competitive Edge in the 21st Century Job Market
Kirk Paul Lafler, sasNerd
PO-136. A Deep Dive into Enhancing SAS/GRAPH and SG Procedural Output with Templates, Styles, Attributes, and Annotation
Louise Hadden, Abt Associates Inc.
PO-139. Great Time to Learn GTL
Richann Watson, DataRich Consulting
Kriss Harris, SAS Specialists Ltd
PO-140. When ANY Function Will Just NOT Do
Richann Watson, DataRich Consulting
Karl Miller, IQVIA
PO-144. Ten Rules for Better Charts, Figures and Visuals
Kirk Paul Lafler, sasNerd
PO-152. Let’s Get FREQy with our Statistics: Data-Driven Approach to Determining Appropriate Test Statistic
Richann Watson, DataRich Consulting
Lynn Mullins, PPD
PO-169. Five Reasons To Swipe Right on PROC FCMP, the SAS Function Compiler for Building Modular, Maintainable, Readable, Reusable, Flexible, Configurable User-Defined Functions and Subroutines
(No paper available)
Troy Martin Hughes, Datmesis Analytics
PO-204. Who’s Bringing That Big Data Energy? A 47-Year Longitudinal Analysis of 30,000 Presentations in the SAS User Community To Elucidate Top Contributors and Rising Stars
Troy Martin Hughes, Datmesis Analytics
Hands-on Workshops
HOW-111. Application of Fuzzy Matching Techniques Using SAS Software
Kirk Paul Lafler, sasNerd
Stephen Sloan, Accenture
HOW-134. Zip Code 411: An In-Depth Approach to Analyzing, Visualizing and Reporting on Zip Code Level Data
(No paper available)
Louise Hadden, Abt Associates Inc.
HOW-155. The Battle of the Titans: DATA Step versus PROC SQL
Kirk Paul Lafler, sasNerd
Richann Watson, DataRich Consulting
Josh Horstman, Nested Loop Consulting
Charu Shankar, SAS Institute
HOW-163. Everything is Better with Friends: Using SAS in Python Applications with SASPy and Open-Source Tooling (Getting Started)
(No paper available)
Isaiah Lankham, Legacy Health
Matthew Slaughter, Kaiser Permanente Center for Health Research
HOW-198. Getting Started with the SGPLOT Procedure
[Additional Materials (ZIP Archive)]
Josh Horstman, Nested Loop Consulting
HOW-208. Share your code with SAS Packages – a Hands-on-Workshop
Bart Jablonski, yabwon
HOW-224. Open-Source Essentials HOW – R and RStudio
Wendy Christensen, University of Colorado Anschutz Medical Campus
HOW-225. SAS Users GIT Started! A HOW Introduction to GIT.
(No paper available)
Zeke Torres, Code629
Open Source
OS-143. Panel Discussion: Benefits, Challenges, and Opportunities with Open Source Software (OSS) Integration
Kirk Paul Lafler, sasNerd
Ryan Lafler, Premier Analytics Consulting, LLC
Joshua Cook, Andrews Research & Education Foundation
Anna Wade, Premier Analytics Consulting, LLC
Stephen Sloan, Accenture
OS-154. From Interactive Mapmaking to Beautiful Geospatial Visualizations: Harnessing the Power of Python and Google Earth Engine for Extracting, Analyzing, and Visualizing High Resolution Spatiotemporal Data
Ryan Lafler, Premier Analytics Consulting, LLC
Anna Wade, Premier Analytics Consulting, LLC
OS-159. SAS Log Parsing Made Easy with Python
Erin O’Dea, NORC at the University of Chicago
OS-165. A Dash of SAS , a Pinch of R: Cooking up Dashboards Using Two Very Different Programming Languages
Joshua Cook, Andrews Research & Education Foundation
OS-168. What’s black and white and sheds all over? The Python Pandas DataFrame, the Open-Source Data Structure Supplanting the SAS Data Set
Troy Martin Hughes, Datmesis Analytics
OS-184. From Data Access to Exploratory Data Analysis My Journey into the World of Python
Leon Davoody, student
OS-185. An Overview of the SASSY System
David Bosak, r-sassy.org
OS-201. How Do We Git There? Best Practices for using Git with SAS
Joe Matise, NORC
Pharma and Healthcare
PH-116. Another Glance at Good Programming Practice from the Perspective of FDA Reviewers
Hongbo Li, Amylyx Pharmaceuticals Inc.
PH-160. A SAS Macro for 30-Year Cardiovascular Risk Predication
Matt Zhou, Kaiser Permanente
Hui Zhou, Kaiser Permanente
Jaejin An, Kaiser Permanente
PH-173. How to Understand Therapeutic Area User Guide for Reactogenicity Events in Vaccine Studies
Yanwei Han, CSLSeqirus
PH-180. Demystifying the define.xml: Overcoming the challenges of CRT Package.
Yoganand Budumuru, IQVIA
PH-192. Navigating SAS(r) and CDISC Certification with Apprenticeship
Sarvar Khamidov, EDAClinical
PH-194. Quality Control – Defining an Acceptable Quality Standard without Achieving Perfection
Bill Coar, Axio, a Cytel Company
PH-206. Generation of AE (Adverse Events) summary tables by worst CTC Grade utilizing SAS
Ballari Sen, Bristol Myers Squibb
PH-218. Visualizing Insights, Empowering Discoveries: SAS Viya Unleashed in Life Science Analytics
Matt Becker, SAS
Professional Development
PD-106. Mining for SAS Gold
Thomas Mannigel, Self
PD-123. Developing and running an in-house SAS Users Group
Stephen Sloan, Accenture
PD-132. Effective Presentations: More than Just PowerPoint
Derek Morgan, Bristol Myers Squibb
PD-199. Adventures in Independent Consulting: Perspectives from Two Veteran Consultants Living the Dream
Josh Horstman, Nested Loop Consulting
Richann Watson, DataRich Consulting