The creation of complex PowerPoint presentations as part of a monthly production process can be a highly time consuming and downright painful process. My team has been tasked with creating 13 PowerPoints every month each containing approximately 50 graphs and 8 tables. That is over 650 pieces of output!

When I first started on this project, the team was several years into this production process and very far from any form of automation. The process involved copying and pasting those 650 pieces of output every single month. It took hours upon hours, and just absolutely had to be changed. Think of all the great things we could produce if we could get those hours upon hours back!

So, with the help of management, we were able to get the SAS Add -In for Microsoft Office and revolutionize our process. The paper associated with this post includes detailed instructions on how the manual process was converted into a series of stored processes which were used with the Add-In to help automate our process.