Paper 95

Automate in a Dash with SAS- Time-Saving Techniques for Building Quality Improvement Dashboards

September 23, 2025: 10:00 AM - 10:30 AM

Visualizations and Reporting (VR), Executive Dining Room #2

Authors	Abstract
Shavonne Standifer	Building programs that leverage the analytic and reporting powers of SAS® reduce the time to solution for critical tasks. This paper discusses, through example, how Base SAS® tools, such as FILENAME, MACROS, and ODS combined with the “built in scheduler” housed in SAS® Enterprise Guide can be used to automate the process between raw data to dashboard view quickly and efficiently. This paper is divided into two main parts. In the first part, we discuss how to use scripting language to bring data from a file location into the SAS® environment, how to build programs that clean and subset the data, and how to transform the process with a MACRO. In the conclusion, we will discuss how to use SAS procedures and the ODS to transform the resulting data into a quality improvement dashboard view that can be set to automatically run and send to team members at a scheduled time.

Shavonne Standifer

Building programs that leverage the analytic and reporting powers of SAS® reduce the time to solution for critical tasks. This paper discusses, through example, how Base SAS® tools, such as FILENAME, MACROS, and ODS combined with the “built in scheduler” housed in SAS® Enterprise Guide can be used to automate the process between raw data to dashboard view quickly and efficiently. This paper is divided into two main parts. In the first part, we discuss how to use scripting language to bring data from a file location into the SAS® environment, how to build programs that clean and subset the data, and how to transform the process with a MACRO. In the conclusion, we will discuss how to use SAS procedures and the ODS to transform the resulting data into a quality improvement dashboard view that can be set to automatically run and send to team members at a scheduled time.