topic Re: Titles in Powerpoint in Developers

Titles in Powerpoint

deleted_user — Wed, 03 Sep 2008 14:16:28 GMT

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"
GPATH="&path"
PATH="&path";
title1 font=arial j=CENTER h = 2.5pct c = bib
"My Title";

code to generate grapg - eg proc gchart

quit;
ODS LISTING CLOSE;
ODS HTML CLOSE;

Re: Titles in Powerpoint

Cynthia_sas — Wed, 03 Sep 2008 16:46:41 GMT

Hi:
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.

cynthia

Re: Titles in Powerpoint

GraphGuy — Tue, 06 Jul 2010 14:38:50 GMT

I'm a couple of years late on this one, but maybe this info will be useful to people searching for info on similar questions...

dev=java and dev=activex do not support "gtitles" (titles as part of the graph) - I think in most situations, EG and STPs default to activex or java (or one of their variants).

Therefore, do everything you can to make sure you're using dev=gif or dev=png, and then also make sure you're using "gtitles" rather than "nogtitles" (gif and png support both gtitles and nogtitles).