Hi:
If you have the SAS Enterprise Intelligence Platform (also known as the BI Platform) and you have the SAS Add-in for Microsoft Office, then one of the methods to "automate" the analytic tasks and wizards is to develop SAS Stored Processes. And, in your case, if the stored process was coded to create a dataset and then create a report, you could run the stored process in either Excel or PPT and the results would automatically populate a workbook or a presentation.
There are 2 ways to develop stored processes -- one is to take an EG process flow and create the stored process from a whole process flow, (or you could create a stored process from just one task in a project); alternately, you could export EG code and then selectively create your stored process by manipulating the code. Most folks, however, use the first method -- they create their stored process from an EG project. Then when they deploy the stored process, any user with the appropriate access can run the stored process.
If you build the stored process with parameters, then you can go a step further and have Person #1 run the stored process in Excel and get the report run for Region #1 and you could have Person #2 run the same stored process in PPT and get the report run for the same region or for different region(s).
If you don't know about SAS stored processes, then I highly recommend these papers:
http://www2.sas.com/proceedings/sugi30/135-30.pdf (talks about creating an SP)
http://www.scsug.org/SCSUGProceedings/2005/Davidson_SAS%20ETL%20Studio%20-%20108.pdf (shows the same stored process running in several client applications)
http://analytics.ncsu.edu/sesug/2008/CS-054.pdf
http://www.lexjansen.com/pharmasug/2009/hw/hw06.pdf
cynthia