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!
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.
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 email@example.com for substitution information or to request a refund. If classes are canceled due to low enrollment, the registrant will receive a full refund.
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
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
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.
- 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
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
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
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.
- 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
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.