Do you want to create custom reports, spreadsheets and dashboards using PROC Report and ODS?   Western Users of SAS Software presents Custom Reports, Spreadsheets, and Dashboards Using PROC REPORT with Kirk Paul Lafler Wednesday, April 10  |  10am - 2pm Pacific   Attendees of this popular virtual course learn how to create detail and summary reports, spreadsheets, dashboards, and specialized output using PROC REPORT, ODS EXCEL, and Statistical Graphics; acquire useful ODS and Statistical Graphics skills; combine PROC REPORT and the powerful ODS PDF, HTML, and Excel destinations to produce quick and formatted reports, spreadsheets, dashboards, and specialized results; customize output and results with SAS-supplied styles; compute subtotals and totals at the end of a report using COMPUTE Blocks; calculate percentages; produce statistics for analysis variables; apply conditional logic to control summary output rows; add background images, logos, and watermarks; build custom autofilter techniques to subset (or filter) reports and Excel workbooks; freeze row and column headers for frame-of-reference vantage points (viewing) while scrolling in Excel workbooks; add traffic lighting scenarios; and build custom (n-rows x n-columns) dashboards with ease.   Learn more at https://www.wuss.org/wuss-2024-virtual-classes/ ... View more

Looking to learn a little bit more about SAS Macros?   Western Users of SAS Software presents From %MACRO to %MEND: Getting Started with SAS Macro Language Basics with Josh Horstman Part 1 - Tuesday, February 27, 2024  |  10am - 2pm Pacific Part 2 - Wednesday, February 28, 2024  |  10am - 2pm Pacific   This two-part virtual seminar is designed for the SAS programmer who is new to the Macro Language. We will start with the basics and cover the fundamentals necessary to start applying SAS macros in your programs. Part 1 covers how the Macro Language works, what the Macro Symbol Table is and how to store values in it, how the SAS System uses Macro Variables, calling and executing macros, using macro parameters, and other key Macro Language concepts.  Building on the foundational concepts of the first part, Part 2 covers how to control your SAS programs with macros, the use of key SAS Macro Language statements, interfacing with data values in the macro language, macro functions, macro language arithmetic, and other fundamental macro language concepts.    Learn more at https://www.wuss.org/wuss-2024-virtual-classes/   ... View more

Want to learn a little bit more about PROC SQL?   Western Users of SAS Software presents The Complete Guide to PROC SQL: Mastering Essentials and Unlocking Advanced Techniques with Tasha Chapman Part 1 - Tuesday, March 12, 2024  |  10am - 2pm Pacific Part 2 - Thursday, March 14, 2024  |  10am - 2pm Pacific   This virtual course is appropriate for beginners who have never used SQL as well as intermediate level users who would like to strengthen their existing skills. The course will cover the basic syntax of SQL to develop a firm understanding of how the language is used, and then move to more advanced topics. With engaging activities and exercises, there will be plenty of opportunities to practice what you’ve learned both in and out of the classroom.  This class is split into two parts. While each part can be taken individually, it is strongly recommended that both parts be taken together.   Learn more at https://www.wuss.org/wuss-2024-virtual-classes/ ... View more

Western Users of SAS Software is offering a three-part instructor-led series of virtual classes this summer teaching the fundamentals of SAS.   These classes can be taken individually or as part of a package.  Become a SAS expert in just 3 easy lessons!   SAS Essentials I - DATA Steps and Data Manipulation July 18  |  $150/person ($25/students) SAS Essentials I focuses on DATA step programming. Together we'll walk through the fundamental building blocks of a SAS program with a deep dive into data manipulation, including SAS libraries, conditional processing, functions, and more.    SAS Essentials II - PROC Steps and Basic Reporting August 1  |  $150/person ($25/students) SAS Essentials II will feature a showcase of the most common reporting procedures, including MEANS, FREQ, PRINT, TABULATE, and REPORT. We'll also walk through the Output Delivery System and how it can be used to build professional reports the easy way.   SAS Essentials III - Intro to Intermediate Topics August 15  |  $150/person ($25/students) With the fundamentals under our belt, SAS Essentials III 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.   Find out more at https://www.wuss.org/sas-essentials-2023/       ... View more

I have a dataset with the following variables:   Inspection ID Date Employer ID Count of violations There are five years worth of data, one row per inspection, and an employer can have multiple inspections.   The question is: How many times did the same employer receive three or more violations (not necessarily in the same inspection) within a one-year period?   In other words, for every inspection record in the original dataset, I also need to count back to any inspections within the previous year (12 months/365 days) of the date of that original inspection and count the sum total of violations.   Thoughts on how to do this?  SAS code or Proc SQL are preferred, but I'll work with anything you can come up with...  I was thinking maybe a correlated subquery, but my initial attempt at the code didn't work and I kinda broke my brain. 🙂   ... View more