BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Does any one know how to output the results of a SAS graph or a summary tables to a power point file in a particular page?

I know this might be asking a bit much but any assistance with this would be really appreciated.

Cheers
DW
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi!
If you have the Business Intelligence Platform installed, the SAS Add-in for Microsoft Office places a pull-down menu on the PowerPoint toolbar, so you can run SAS Task and/or Stored Processes from inside Powerpoint and return the results directly to PPT.

If you do NOT have the BI Platform installed, then there are several of options and they differ depending on whether you are talking about Graphic output or tabular output (summary tables).

For Graphic output, you can have SAS/Graph create just an image file for you (creating a graphics stream file) or you can use ODS to create the image file -and- an HTML file that contains the HTML tag needed to display the image file from within a browser. This tech support paper has lots of information about these two techniques:
http://support.sas.com/techsup/technote/ts674/ts674.html

For tabular output, you also have several choices -- create an HTML file with ODS for your tabular report output and then open that HTML file with HTML. Or, you can send your report to HTML, open the HTML file with Excel and then from Excel, go to Powerpoint (I know this seems like a convoluted path -- but Powerpoint is notorious for not importing HTML the way you want it to). Or if you have created summary data sets, you could use DDE or ODBC or OLE/DB or VBA to get the data into a PowerPoint table (but, of course, this involves -other- technologies) as described here: http://www2.sas.com/proceedings/sugi30/006-30.pdf
http://www2.sas.com/proceedings/sugi30/045-30.pdf

Another totally different approach (which I think works best if your summary table is the right size to fit on one slide) is to turn your tabular output into a "picture" using PROC GPRINT, as described here: http://support.sas.com/ctx/samples/index.jsp?sxf=s&browse=graph&PROCS=gprint

Bottom line: without the BI platform it is at least a 2 step process to get your graph or tabular results into Powerpoint.

If you have more specific questions about any of these techniques, your best bet is to contact Tech Support.
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!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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