WUSS 2022 Conference Proceedings
San Francisco, California
September 14-16, 2022
Advanced Techniques
38. Application of Fuzzy Matching Techniques Using SAS Software – A Panel Discussion
Kirk Paul Lafler, sasNerd
Stephen Sloan, Accenture
40. Functions (and More!) on CALL!
Richann Watson, DataRich Consulting
Louise Hadden, Abt Associates Inc.
46. The Best Kept Secret of Custom Built Tasks Built in SAS® Studio!
Jennifer Rosson, Western Alliance Bank
48. Four Different Page Layouts on the Fly with Three Reports on a Page using the Output Delivery System
Derek Morgan, Bristol Myers Squibb
69. Calculating Cardinality Ratio in Two Steps
Ronald Fehd, Fragile-Free Software
79. GIS Challenges of Cataloging Catastrophes: Serving up GeoWaffles with a Side of Hash Tables to Conquer Big Data Point-in-Polygon Determination and Supplant SAS® PROC GINSIDE
Troy Hughes, Datmesis Analytics
87. What’s Your Favorite Color? Controlling the Appearance of a Graph
Richann Watson, DataRich Consulting
88. Have a Date with ISO®? Using PROC FCMP to Convert Dates to ISO 8601
Richann Watson, DataRich Consulting
97. Introduction To SCL Functions For Macro Programmers
Ronald Fehd, Fragile-Free Software
108. Getting Started with DATA Step Hash Objects
Josh Horstman, Nested Loop Consulting
111. Your Query’s No Good Here: PROC SQL Code That Doesn’t Work Outside of SAS
Jedediah Teres, MDRC
112. Let SAS do the work for you: Tips and tricks for turning SAS output into client-ready tables
Becky Lien, Professional Data Analysts
Sara Richter, Professional Data Analysts
Lily Dunk, Professional Data Analysts
118. Automating Reports Using Macros and Macro Variables
Ekaterina Roudneva, UC Davis
121. Using Dictionary Tables to Create Dynamic Programs
Jake Reeser, NORC
143. Creating a data dictionary using Base SAS®
Tasha Chapman, Oregon Department of Consumer and Business Services
144. An Introduction to SAS® Arrays
Lisa Mendez, Emerge Solutions Group
158. Cooking in SAS Viya
Charu Shankar, SAS Institute
Analytics & Statistics
47. Attribute Reduction for Continuous Dependent Variables in SAS®
Alec Zhixiao Lin, Southern California Edison
60. Customizable SAS Graphs for Bias Analysis
Natasha Oza, Roche Diagnostics Solution
Jesse Canchola, Roche Diagnostics Solution
74. Evaluating CO2 storage potential of SECARB Offshore Reservoirs and Saline Formations by Employing Data-driven Models with SAS® Viya software
Kodjo Botchway, Oklahoma State University
Rupom Bhattacherjee, Oklahoma State University
Xitong Hu, Oklahoma State University/Sam’s Club
Jack Pashin, Oklahoma State University
Goutam Chakraborty, Oklahoma State University
Prem Bikkina, Oklahoma State University
102. What’s your model really doing? Understanding human biases in Machine Learning.
Jim Box, SAS Institute
105. Story telling with SAS Visual Statistics
Jim Box, SAS Institute
Laura Watson, SAS Institute
155. Watching Our Gardens Grow using Social Network Analysis
(No paper available)
Miriam McGaugh, Oklahoma State University
Beginner’s Techniques
25. Enhancing Your Skillset with SAS® OnDemand for Academics (ODA) Software
(No paper available)
Kirk Paul Lafler, sasNerd
33. The Battle of the Titans (Part II): PROC TABULATE versus PROC REPORT
Kirk Paul Lafler, sasNerd
Joshua Horstman, Nested Loop Consulting
39. Data Access Made Easy Using SAS® Studio
Kirk Paul Lafler, sasNerd
Zheyuan Yu, MS Biostatistics
Shaonan Wang, Student
Nuoer Lu, Student
Daniel Qian, Student
Swallow Yan, US Education Without Borders
49. The Essentials of SAS® Dates and Times
Derek Morgan, Bristol Myers Squibb
52. PROC SORT (then and) NOW
Derek Morgan, Bristol Myers Squibb
59. A Survey of Some of the Most Useful SAS Functions
Ron Cody, SAS Instructor
67. True is not False: Evaluating Logical Expressions
Ronald Fehd, Fragile-Free Software
109. Using the Output Delivery System to Create and Customize Excel Workbooks
Josh Horstman, Nested Loop Consulting
139. Generating Simple Statistics with Base SAS Procedures
Jane Eslinger, SAS Institute
152. Using Git with Your SAS Projects
(No paper available)
Chris Hemedinger, SAS
163. Getting Started with the Output Delivery System
(No paper available)
Chevell Parker
Data Management & Administration
20. Putting the Meta into the Data: Managing Data Processing for a Large Scale CDC Surveillance Project with SAS®
Louise Hadden, Abt Associates Inc.
54. Explore Your Data and Avoid Surprises
Daniel Konkler, Independent Contractor
Gilbert Ramos, Valleywise Health
70. Did the load work?
Lisa Eckler, Lisa Eckler Consulting Inc.
71. Using SAS® Gplot Overlay to Effectively Visualize and Compare COVID-19-Sepsis versus Sepsis Post-hospital Discharge Locations Over Time
Xiao Qing Wanng, Michigan Medicine
Sarah Seelye, Veterans Affairs Center for Clinical Management Research, HSR&D Ann Arbor, MI
Brenda McGrath, OCHIN, Inc
Hallie Prescott, Michigan Medicine
Theodore Iwashyna, Michigan Medicine
Elizabeth Viglianti, Michigan Medicine
80. Calling for Backup When Your One-Alarm Becomes a Two-Alarm Fire: Developing SAS® Data-Driven Concurrent Processing Models through Control Tables and Dynamic Fuzzy Logic
Troy Hughes, Datmesis Analytics
84. Should I Wear Pants in the Portuguese Expanse? Automating Business Rules and Decision Rules Through Reusable Decision Table Data Structures that Leverage SAS Arrays
Troy Hughes, Datmesis Analytics
Louise Hadden, Abt Associates Inc.
e-Posters
26. Exploring the Skills Needed by the Data Scientist
Kirk Paul Lafler, sasNerd
77. From %let To %local; Methods, Use, And Scope Of Macro Variables In Sas Programming
Jayanth Iyengar, Data Systems Consultants LLC
81. Failure To EXIST: Why Testing Data Set Existence with the EXIST Function Is Inadequate for Serious Software Development in Asynchronous, Multiuser, and Parallel Processing Environments
Troy Hughes, Datmesis Analytics
113. Heatmaps for Hot Housing Markets SAS an ultimate tool for analyzing real estate data
Harshita Budumuru, Green Level High School
114. Analysis of Chemicals in Beauty Products and its Impact on Consumers
Chhavi Nijhawan, Student
116. Generate Complex SAS code from File
Paul Silver, NORC at University of Chicago
HOW
37. Macro Programming Essentials for New SAS Users
Kirk Paul Lafler, sasNerd
76. Understanding Administrative Healthcare Data sets using SAS programming tools.
Jayanth Iyengar, Data Systems Consultants LLC
92. Commit early, commit often! A gentle introduction to the joy of Git and GitHub
(No paper available)
Isaiah Lankham, University of California Office of the President
Matthew Slaughter, Kaiser Permanente Center for Health Research
99. SASJS the coolest SAS code tool since Proc Sort!
(No paper available)
Zeke Torres, Code629
103. ODS Document & Item Stores: A New Beginning
(No paper available)
Bill Coar, Axio, a Cytel Company
119. Simmering Data: Using Beautiful Soup and Python to scrape data from web pages
Joe Matise, NORC
124. Map It Out: Using SG Attribute Maps for Precise Control of PROC SGPLOT Output
Josh Horstman, Nested Loop Consulting
137. Proc Report Step by Step with Styles
(No paper available)
Jane Eslinger, SAS Institute
Open Source
61. Using LaTeX document class sugconf to write your paper
Ronald Fehd, Fragile-Free Software
83. Data-Driven Robotics: Leveraging SAS® and Python to Virtually Build LEGO MINDSTORMS Gear Trains for the EV3 Brick
Troy Hughes, Datmesis Analytics
93. Friends are better with Everything: Using PROC FCMP Python Objects in Base SAS
Matthew Slaughter, Kaiser Permanente Center for Health Research
Isaiah Lankham, University of California Office of the President
104. SAS and Open Source Playing Nicely Together
Jim Box, SAS Institute
Samiul Haque, SAS Institute
117. Unlocking the Web With Python and SAS: Shortcuts to accessing data using Python and SAS
Joe Matise, NORC
151. Data mining for the online retail industry: Customer segmentation and assessment of customers using RFM and k-means
Gowtham Varma Bhupathiraju, Oklahoma State University
153. Using Visual Studio Code for SAS Programming
(No paper available)
Chris Hemedinger, SAS
156. Making survey systems talk with analytics software: Comparing connections to SAS and SAS Viya
(No paper available)
Miriam McGaugh, Oklahoma State University
Pharma and Healthcare
43. Standardized, Customized or Both? Defining and Implementing (MedDRA) Queries in ADaM Data Sets
Richann Watson, DataRich Consulting
Karl Miller, IQVIA
44. Standardised MedDRA Queries (SMQs): Beyond the Basics; Weighing Your Options
Richann Watson, DataRich Consulting
Karl Miller, IQVIA
50. Time Since Last Dose: Anatomy of a SQL Query
Derek Morgan, Bristol Myers Squibb
63. Child Data Set: An Alternative Approach for Analysis of Occurrence and Occurrence of Special Interest
Lindsey Xie, Kite Pharma, Inc.
Richann Watson, DataRich Consulting
Jinlin Wang, Kite Pharma, Inc
Lauren Xiao, Kite Pharma, Inc.
89. Study of cause and effect in medical research via SAS Statistical package
Oleg Korovyanko, University of California, Davis
100. Cautionary Notes when Working with Interim Data
Bill Coar, Axio, a Cytel Company
101. Finding Your Latest Date
Bill Coar, Axio, a Cytel Company
110. Complex heatmaps in Statistical analysis of Biomarkers and cancer genomics – Yoganand Budumuru, IQVIA.
Yoganand Budumuru, IQVIA
120. The Functional Service Provider Model: A Comprehensive and Collaborative Solution
Jim Baker, K3-Innovations
David Polus, K3-Innovations
John Kurtz, K3-Innovations
134. TrackCHG: A SAS Macro to Colorize and Track Changes Between Data Transfers in Subject-Level Safety Listings
Inka Leprince, PharmaStat, LLC
Elizabeth Li, PharmaStat, LLC
Carl Chesbrough, PharmaStat, LLC
161. Learn the Basics About the Pharmaceutical Industry in 20 Minutes
Jim Box, SAS Institute
Matt Becker, SAS
162. Quick Jumpstart into Pharmaceutical SAS Programming
Jim Box, SAS Institute
Matt Becker, SAS
Professional Development
58. So You Want to be a Successful Statistical Programmer?: The Importance of People Skills
Carey Smoak, Retired
107. Adventures in Independent Consulting: Perspectives from Two Veteran Consultants Living the Dream
Josh Horstman, Nested Loop Consulting
Richann Watson, DataRich Consulting
122. A Statistical Programmer’s Growth Journey: It is More than Learning New Code
Janette Garner, Bristol Myers Squibb
164. Building a LinkedIn That Stands Out
(No paper available)
Missy Hannah, SAS
Programming
19. Form(at) or Function? A Celebratory Exploration of Encoding and Symbology
(No paper available)
Louise Hadden, Abt Associates Inc.
21. Designing and Implementing Reporting Meeting Federal Government Accessibility Standards with SAS®
(No paper available)
Louise Hadden, Abt Associates Inc.
22. SAS® PROC GEOCODE and PROC SGMAP: The Perfect Pairing for COVID-19 Analyses
(No paper available)
Louise Hadden, Abt Associates Inc.
24. Talking to Your Host Interacting with the Operating System and File System from SAS
Kurt Bremser, Retired
27. Essential Programming Techniques Every SAS® User Should Learn
Kirk Paul Lafler, sasNerd
28. Ten Rules for Better Charts, Figures and Visuals
Kirk Paul Lafler, sasNerd
41. What Kind of WHICH Do You CHOOSE to be?
Richann Watson, DataRich Consulting
Louise Hadden, Abt Associates Inc.
42. “Bored”-Room Buster Bingo – Create Bingo Cards Using SAS® ODS Graphics
Richann Watson, DataRich Consulting
Louise Hadden, Abt Associates Inc.
45. If its not broke, don’t fix it; existing code and the programmers’ dilemma
Jayanth Iyengar, Data Systems Consultants LLC
53. Best Practices for Efficiency and Code Optimization in SAS programming
Jayanth Iyengar, Data Systems Consultants LLC
55. SAS as a Tool in Data Curation: A Case Example with the Inter-university Consortium for Political and Social Research
Piotr Krzystek, ICPSR at the University of Michigan
64. A Configuration File Companion: testing and using environment variables and options; templates for startup-only options initstmt and termstmt
Ronald Fehd, Fragile-Free Software
65. An Autoexec Companion, Allocating Location Names during Startup
Ronald Fehd, Fragile-Free Software
115. SAS Log Parsing: SAS Logs without the slog
Drew Metz, NORC
145. Hash Tables Like You’ve Never Seen Them Before
Mathieu Gaoette, Prospective MG
146. Using SAS Formats
Tom Kari, Tom Kari Consulting
157. Five Secrets of the SQL Goddess
Charu Shankar, SAS Institute
159. A Brief Introduction to DS2
Mark Jordan, SAS Institute, Inc.
160. Fun with FILENAMEs
(No paper available)
Mark Jordan, SAS Institute, Inc.
165. Facilitating Complex String Manipulations Using SAS PRX Functions
John LaBore, SAS Institute