WUSS 2022 Conference Proceedings

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