BookmarkSubscribeRSS Feed
Kuzmenkov
Calcite | Level 5
Hi,

im working with SAS Add-In for creation and composite the PowerPoint presentation, based on my SAS data. I have approximatly hundred of presentation for product, department and etc division. Difference between presentation it's just filter for data table. Hundred times i must to do the next steps:
1. Open presentation.
2. Find 2D Bar Chart and click "Property"
3. On "Property" window select "Data" tab
4. on "Data" tab (middle of window) click "Change..."
5. Change the data filter, save it and refresh presentation.

I think it's not "better" way for creating a equialent presentations.
Has the any VBA code example for my issue? Or what VBA class i must tu use for data filter changing?
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi:
You might consider populating your PowerPoint presentation from a Stored Process (SP) -- if, for example, you used BY group processing or some SAS/Graph process that created multiple graphs usually PowerPoint puts each graph and each table on a separate slide.

Your data filters could become input parameters to the SP -- so you'd select them one time -- when you go to run the SP -- and then you could have code which would use those data filters and return the results -- with the graphs already filtered -- to your PowerPoint session.

Someone who knows SAS should be able to see what task you're doing in PPT with the Add-in and then replicate that task, with code, as a Stored Process.

You probably could do this with VBA and some kind of custom script that was a layer on top of the Add-in results, but personally, I'd try the Stored Process route first.

cynthia

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 1 reply
  • 640 views
  • 0 likes
  • 2 in conversation