Paper 97

How to Create a Spreadsheet-driven Batch Job Using R and SASSY

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

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

Authors	Abstract
David Bosak	It is very common to use spreadsheets to drive batch jobs in SAS. The spreadsheets allow you to easily control which programs are run, and in what order. They also provide a centralized place to store titles, footnotes, and other information used in the programs. Is it possible to create a similar system in R? Yes! This paper will demonstrate how to do it using a typical spreadsheet layout, and reports written with the SASSY set of R packages.

David Bosak

It is very common to use spreadsheets to drive batch jobs in SAS. The spreadsheets allow you to easily control which programs are run, and in what order. They also provide a centralized place to store titles, footnotes, and other information used in the programs. Is it possible to create a similar system in R? Yes! This paper will demonstrate how to do it using a typical spreadsheet layout, and reports written with the SASSY set of R packages.