BookmarkSubscribeRSS Feed
Fluorite | Level 6

I have bee asked to Auto Fill a MS PowerPoint presentation that today takes the data from a SAS Proc Print or SAS output to MS Excel and is then inserted into the target slide.  There are no SAS generated Charts, Graphs or Tables on any slide in the presentation, only data.  I know that I can modify a slide to have  "Some text &var_one some text &var_two" in the headers and footers of the slide but I need to add data to a large number of variables on the slide.  

The Ideal target is to have a SAS Stored process run the code and refresh the data on the customer' s desk.  I have bot found a good example of that yet.


The attached file is just a snip of the whole slide. I have added outline to the textbox containing the areas showing where the data needs to go.


Super User
Change your current process to output straight to the PowerPoint file using ODS.

Or export your data to Excel and have linked files, ie your PPTX is linked to the source Excel file that will then be updated automatically via SAS.

Fluorite | Level 6


     Thank you for the response.  I would love to change everything to just ODS and walk away from the mess.  Currently I out put the data to Excel and someone else cuts and pastes to Powerpoint.  So, that being said I have yet to fins an example of ODS hat looks close to what I need to do and I do not know how, yet to link Powerpoint to Excel. But now I have something else to go and look up.

Thank you. 

Super User
Have you tried basic proc report with ODS PPTX? It does depend on how complex your tables are and if they get too complex I'd definitely use the embed from Excel option. Basically when you paste the table/graph from Excel into PowerPoint there's an option to link/embed instead of just paste and you want to make sure you use that option when building your report.


Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.


Register now!

5 Steps to Your First Analytics Project Using SAS

For SAS newbies, this video is a great way to get started. James Harroun walks through the process using SAS Studio for SAS OnDemand for Academics, but the same steps apply to any analytics project.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 2 in conversation