I am running a stored process via SAS Microsoft Add Ins in Powerpoint that generates about 50 slides, each containing a graph with a title.
The graphs appear fine in Powerpoint, but the title has become separate from the graph (which is not the case in the gif file generated) and appears to have the default powerpoint font, which is way too large.
An example of the code is given below.
When I run the stored process from Excel or Word, something similar happens.
Is there a way of keeping the title as part of the graph, as with the gif file generated?
Thanks for your help.
goptions reset=all device=gif;
ODS LISTING CLOSE;
ODS HTML CLOSE;
ODS HTML BODY="Body_file.html"
title1 font=arial j=CENTER h = 2.5pct c = bib
When you use the SAS Add-in to Office with Powerpoint as part of the BI Platform, Powerpoint will only "accept" SAS Report XML results from the stored process. Even if you have ODS HTML in your code, or you do an override for the &_ODSDEST reserved variable, when the results come back, SAS detects that the client application is PowerPoint and your results are turned into SASReport XML. I believe that your device of GIF will probably be changed to the device driver that is used for PowerPoint (probably PNG or ACTIVEX or JAVA driver -- I'm not sure).
There are some regular ODS options that can be used for non-stored process SAS/Graph and ODS jobs: they are the ODS USEGOPT statement and the GTITLE option on the ODS statement. However, I am not sure that either of those abilities are used by the SASReport XML that PowerPoint receives.
This is probably a question for Tech Support -- as they can look at your complete code and your PowerPoint settings and if they cannot help you get the title into the SAS/Graph image, then they can help you change the CSS style that is used with the Add-in and PowerPoint to make the title the size you want.
Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer.