Upcoming Classes 2021/2022

WUSS Online Classes 2021/2022 – UPCOMING CLASSES

In lieu of an annual conference, WUSS is offering an extensive menu of online training classes throughout 2021 and early 2022. Our classes are taught by seasoned industry experts and are a tremendous value at just $125 per class. All classes are held from 10am to 2pm PT (1pm to 5pm ET).

Scholarships: Click here for information about scholarships that are available to help make these classes accessible to everyone!

But wait, there’s more! Every class attendee is automatically entered in a drawing for a complimentary registration for the in-person WUSS 2022 conference in Burlingame, California. You’ll receive one entry per class. The more classes you take, the greater your chance of winning!

Register Now

Registration is NOW OPEN for all classes! Please click on each class title for a detailed description of the course and information about the instructors.

Date Course Title (click for description) Instructor(s)
Jan 25 Custom Excel Reports Using PROC REPORT and the ODS Excel Destination Kirk Paul Lafler
Jan 27 SAS Essentials (or How I Learned to Stop Worrying and Love Code) Part 3 Tasha Chapman
Feb 1 Take Advantage of Public Use Datasets (PUFs) to Learn SAS® Analytical, Graphical and Reporting Techniques, Analytic and Data Management Tools, and Explore Specialized Techniques Louise Hadden
Feb 8 Hands-On Data-Driven Design: Developing More Flexible, Reusable, Configurable SAS Software Troy Martin Hughes
Feb 11 Favorite FunKey Functions: Functions for Your Programming Toolbox Richann Watson
Feb 16 Basic Python Analytics: Do Common SAS Things in Python-Pandas Russ Lavery
Feb 18 Essentials of Statistical Graphics Procedures Sanjay Matange
Feb 25 Getting the Most Out of the Graph Template Language Dan Heath

Refund Policy: Refunds are only available upon request received up to 3 business days prior to the start of the class. Any refunds will deduct $25 per attendee per class for losses due to credit card processing and online registration charges. However, attendee substitutions are free at any time. Contact Western Users of SAS Software at registrar@wuss.org for substitution information or to request a refund. If classes are canceled due to low enrollment, the registrant will receive a full refund.

Course Descriptions

Custom Excel Reports Using PROC REPORT and the ODS Excel Destination

Kirk Paul Lafler
Tuesday, January 25, 2022, 10:00am-2:00pm Pacific Time

SAS® users everywhere turn to the REPORT procedure to customize and satisfy their reporting needs as they create and deliver quality “custom” detail and summary reports, and specialized output for management, end users, and customers. This popular course explores an assortment of techniques to create custom spreadsheets, reports and specialized output using PROC REPORT and the powerful ODS Excel destination. Attendees learn how to create detail and summary spreadsheets, reports and output using PROC REPORT; acquire useful Output Delivery System (ODS) skills; combine PROC REPORT and the powerful ODS Excel destination to produce quick and formatted detail and summary Excel workbook results; customize output and results with SAS-supplied styles; compute subtotals and totals at the end of a report using a COMPUTE Block; calculate percentages; produce statistics for analysis variables; apply conditional logic to control summary output rows; add background images; build custom autofilter drill-down (interactive) reports and Excel workbooks; and add traffic lighting scenarios to Excel workbooks.

SAS Essentials (or How I Learned to Stop Worrying and Love Code) Part 3

Tasha Chapman
Thursday, January 27, 2022, 10:00am-2:00pm Pacific Time

SAS Essentials is an instructor-led course that provides a thorough introduction to the basics of SAS programming including DATA steps, PROC steps, and the Output Delivery System. In this class we focus entirely on coding, providing a fundamental education in how SAS thinks and unlocking the power to use the incredible versatility of SAS code. Whether you’re entirely new to SAS, new to coding, or just want to brush up on the fundamentals, this class is for you.

Part 3: Introduction to intermediate topics (or How Green Was My SAS Code)

With the fundamentals under our belt, this course will show you tips and techniques for improving your SAS code exponentially with a brief introduction to tools like SQL, Arrays, Macros, and much more.

Take Advantage of Public Use Datasets (PUFs) to Learn SAS® Analytical, Graphical and Reporting Techniques, Analytic and Data Management Tools, and Explore Specialized Techniques

Louise Hadden
Tuesday, February 1, 2022, 10:00am-2:00pm Pacific Time

Interest in data sources useful for demonstrating statistical, graphical and reporting techniques has increased with the exponential growth of interest and activity in the fields of Data Science, Machine Learning, and Natural Language Processing. Thus, freely available and reliable banks of data have become highly sought after. This tutorial will introduce three high quality and robust data sources for analytic work suitable for journal submissions, and explore in depth public use data sets and BASE SAS tools that can be used to analyze and graphically represent measures and trends. These data sets include USAID’s Demographic and Health Surveys which include health survey data from Afghanistan to Zimbabwe; the Centers for Medicare and Medicaid Services’ Care Compare Tool (data.medicare.gov and data.cms.gov) focusing on nursing homes; and CDC’s National Health and Nutrition Examination Survey (NHANES) which will demonstrate how to work with a complex sampling design. Exploration of the NHANES survey will also include the use of National Cancer Institute (NCI) macros to analyze usual daily intake. The tutorial will prepare attendees to construct an analysis plan (AP) and standard operating procedures (SOPs) for researching, analyzing and documenting PUFs. SAS tools used will be standard statistical and reporting tools available in BASE SAS, as well as geographic tools including PROC GEOCODE.

Hands-On Data-Driven Design: Developing More Flexible, Reusable, Configurable SAS Software

Troy Martin Hughes
Tuesday, February 8, 2022, 10:00am-2:00pm Pacific Time

Attend and receive a FREE copy of the author’s 600-page book, SAS® Data-Driven Development: From Abstract Design to Dynamic Functionality, Second Edition, released in 2021. Students will receive the physical book in advance of this virtual training, which includes all course scenarios and code. Sample code will also be provided electronically so students can run all programs in real-time using SAS Display Manager, SAS Enterprise Guide, or SAS OnDemand for Academics.

This HANDS-ON workshop installs the student as the new SAS consultant within Scranton, Pennsylvania’s most infamous paper supply company — charged with improving software functionality and performance through data-driven software design. Navigate office intrigue and antics to gather software requirements, analyze hardcoded legacy SAS programs, and refactor (improve) software through data-driven design principles and methods. Help Jim, Dwight, Phyllis, and Stanley sell more paper through higher quality data-driven software!

Data-driven design describes software in which configuration items, business rules, data validation rules, data models, data dictionaries, report style, and other dynamic elements are maintained in external data structures — NOT in underlying code. Benefits include increased software flexibility, reusability, maintainability, modularity, readability, interoperability, extensibility, and configurability. In other words, data-driven design improves your software quality.

Topics include:

  • Compare undesirable hardcoded design with preferred data-driven design, and demonstrate the methods to help SAS practitioners refactor from the former to the latter
  • Build reusable procedures, functions, and call routines (subroutines) using SAS macros and PROC FCMP (the SAS function compiler)
  • Demonstrate built-in and user-defined data structures (including parameters, macro lists, arrays, hash objects, control tables, configuration files, data sets, Excel spreadsheets, CSV files, and CSS files)
  • Use SAS components that support data-driven development (including CALL EXECUTE, CNTLIN option in PROC FORMAT, SYSPARM option, SAS dictionary tables, and CSSSTYLE option in PROC REPORT)
  • Ingest positional flat files, CSV files, SAS data sets, and other transactional files, and dynamically identify altered or invalid file format/structure through prescriptive data dictionaries
  • Create color-coded, “traffic light” quality control reports that automatically identify bad data while standardizing good data
  • Configure the style (e.g., format, font, color scheme, graphics) of data products using user-defined SAS formats and CSS files
  • Learn how user-defined configuration files can facilitate software flexibility, by enabling different users to achieve dynamic functionality based on user-specified preferences that can be saved, modified, and shared with other users
  • Understand how master data management (MDM) can support data structures that are leveraged by SAS, Python, and other languages/applications simultaneously

Favorite FunKey Functions: Functions for Your Programming Toolbox

Richann Watson
Friday, February 11, 2022, 10:00am-2:00pm Pacific Time

Functions are an invaluable part of the programmer’s toolbox. While some functions are extremely popular, for good reason, there are some that could be considered hidden gems. This training will highlight less commonly used functions, such as the PRXCHANGE and PRXPARSE functions, which are essential for efficient string manipulation. Another example is the COALESCE(C) function, which can facilitate the population of missing values based on parameters, and more. This course will illustrate through examples these and more FunKey functions. Additionally, this course will explore the utility of writing functions with the FCMP procedure, which combines the reusability of macro processing with the power of functions, and learn to enhance SAS reporting with user-written style functions. The course is designed for everybody of all skill levels.

Basic Python Analytics: Do Common SAS Things in Python-Pandas

Russ Lavery
Wednesday, February 16, 2022, 10:00am-2:00pm Pacific Time

This seminar is intended to teach people how to do, in Python/Pandas, the things they routinely do in SAS.

This seminar will focus on: reading data into a data frame (a Python/Pandas name for a data set) , appending data frames, merging data frames, sub-setting data frames (e.g., find names & emails of all the customers from CA), plotting and different techniques for grouping/reporting (similar to a Proc SQL or a Proc Freq ). It will, lightly, cover the meaning of an object, class and a namespace.

Python is an object oriented language, with over 80 commonly used objects, and is conceptually very different from SAS. Python was not really designed – it grew from users adding new features. Python is very condensed and one python statement can execute several steps (and hidden loops). Unlike most of the talks on Youtube (where the presenter just reads the code he has typed) this will focus on the the internal steps and loops that the one line of code causes to execute. Understanding the internals is needed for debugging mistakes.

Python is a very big program and this seminar is going to focus on one part of Python – Pandas. Pandas is the Python module that access a table of data (think SAS dataset or Excel sheet). It will not cover Python as a web page tool. A lot of work can be done in Pandas – if the data is relatively clean and if the programmer makes few mistakes. If a programmer starts making mistakes, or the data is dirty, an understanding of Python itself is needed and is beyond the scope of this introductory seminar.

Essentials of Statistical Graphics Procedures

Sanjay Matange
Friday, February 18, 2022, 10:00am-2:00pm Pacific Time

The SAS Statistical Graphics (SG) Procedures help you create modern statistical graphs that are frequently used across many domains for visualization of data. In this half-day course, we will cover the key features of the SGPLOT, SGPANEL and SGSCATTER procedures. We will also build specific examples from the Health and Life Sciences domains such as the Forest Plot, Adverse Event Timelines, Survival Plot, Panel of LFT Shift from Baseline and more.

Course outline:

  • Brief overview of ODS Graphics.
  • Single cell graphs using the SGPLOT procedure.
  • Classification panels using the SGPANEL procedure.
  • Scatter plot panels using the SGSCATTER procedure.
  • Review of key SAS 9.4 features.

Prerequisites: This course is suitable for users with all levels of SAS programming knowledge.

Getting the Most Out of the Graph Template Language

Dan Heath
Friday, February 25, 2022, 10:00am-2:00pm Pacific Time

In this course, we will cover the fundamental concepts of the Graph Template Language (GTL), as well as advanced techniques that can be useful for certain types of displays. We will also spend some time discussing the ODS Graphics system and best practices on when to favor the use of GTL versus the SG procedures.

Meet the Instructors

Tasha Chapman has been using SAS since 2003 and an active member of the SAS User Community since 2006. Throughout her career she has championed continuing education and professional development, presented trainings and workshops at professional conferences across the country, sat as an executive committee member on nationally recognized associations, and founded two organizations dedicated to educating colleagues about research, data, and statistics. She was the chair of the Western Users of SAS Software Conference and Educational Forum in 2017.

Tasha received a Master’s Degree in Psychology, with an emphasis on personality assessment and psychometrics from the University of California, Riverside. Since 2005 she has worked for the State of Oregon as a lead research analyst providing data and policy analysis for Oregon OSHA, the Oregon Child Welfare Program, and the Oregon Health Authority. She lives in Salem, Oregon with her two adorable kids, Nadia and Atlas.

Louise Hadden has been using, and loving, SAS since the days of punch cards and computers the size of a not-so-tiny house. She spends most of her time in support of health policy analytics at Abt Associates Inc., and loves a good SAS reporting challenge. She is also the girl with the SAS tattoo!
Dan Heath is a principal systems developer at SAS Institute. A SAS user for more than 27 years, Dan specializes in SAS/GRAPH software, ODS Graphics, and related graphing technologies. Dan has been a speaker at a number of regional and local users’ group meetings, including SAS Global Forum, PharmaSUG, and WUSS. He received a BS degree in computer science from North Carolina State University.
Troy Martin Hughes has been a SAS practitioner for more than 20 years, has managed SAS projects in support of federal, state, and local government initiatives, and is a SAS Certified Advanced Programmer, SAS Certified Base Programmer, SAS Certified Clinical Trials Programmer, and SAS Professional V8. He has given more than 100 presentations, trainings, and hands-on workshops at SAS conferences, including at SAS Global Forum, SAS Analytics Experience, WUSS, SCSUG, SESUG, MWSUG, PharmaSUG, BASAS, and BASUG. He has authored two groundbreaking books that model software design and development best practices:

  • SAS® Data-Driven Development: From Abstract Design to Dynamic Functionality, Second Edition (2021)
  • SAS® Data Analytic Development: Dimensions of Software Quality (2016)

Troy has an MBA in information systems management as well as other credentials, including: PMP, PMI-RMP, PMI-PBA, PMI-ACP, SSCP, CISSP, CSSLP, Network+, Security+, CySA+, CASP+, CISA, CGEIT, CISM, CRISC, ITIL Foundation, CSM, CSD, A-CSD, CSPO, CSP, CSP-SM, CSP-PO, and SAFe Government Practitioner (SGF). He is a US Navy veteran with two tours of duty in Afghanistan.

Kirk Paul Lafler is an entrepreneur, consultant, programmer and educator, and has been a SAS user since 1979. Kirk is a lecturer and adjunct professor at San Diego State University; an advisor and adjunct professor at the University of California San Diego Extension; and teaches dozens of SAS, SQL, Excel, R and Python courses, seminars, workshops, and webinars to users around the world. As the author of several books including PROC SQL: Beyond the Basics Using SAS, Third Edition (SAS Press. 2019) along with hundreds of papers and articles on a variety of SAS topics; Kirk has been selected as an Invited speaker, educator, keynote and section leader at SAS conferences and meetings worldwide; and is the recipient of 25 “Best” contributed paper, hands-on workshop (HOW), and poster awards.
Russ Lavery is a frequent and multiple-award winning presenter at SAS and other programming conferences. He has been the technical reviewer for five books by SAS press and has lectured all over the U.S. in Europe and in Asia.
Sanjay Matange is an expert in the field of data visualization using SAS graphics software including the SG procedures and GTL. Sanjay worked at SAS for 29 years where he was responsible for the development of ODS Graphics. Sanjay is co-author of four patents and the author of four SAS Press books. Sanjay was also the main author of Graphically Speaking SAS blog for 8 years.
Richann Watson is an independent statistical programmer and CDISC consultant based in Ohio. She has been using SAS since 1996 with most of her experience being in the life sciences industry. She specializes in analyzing clinical trial data and implementing CDISC standards. Additionally, she is a member of the CDISC ADaM team and various sub-teams.

Richann loves to code and is an active participant and leader in the SAS User Group community. She has presented numerous papers, posters, and training seminars at SAS Global Forum, PharmaSUG, and various regional and local SAS user group meetings. Richann holds a bachelor’s degree in mathematics and computer science from Northern Kentucky University and master’s degree in statistics from Miami University.