Date: Thu, 18 Jul 2002 11:14:28 -0400
Reply-To: Quentin McMullen <QuentinMcMullen@WESTAT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Quentin McMullen <QuentinMcMullen@WESTAT.COM>
Subject: automating SAS graph export to PowerPoint
Content-Type: text/plain; charset="iso-8859-1"
I'm trolling for thoughts on automating the export of graphs produced by SAS
Currently I use SAS to produce graphs as cgm files. Then I (manually) open
a powerpoint presentation and insert the images. (Thanks to Bill Droogendyk
for saving me a few clicks by pointing me toward
will insert a cgm and automatically resize it to fill the slide).
I'm wondering if folks have been successful in automating this process from
within SAS? I would think this should be doable via DDE or OLE, but I
haven't played much with either.
I imagine the steps would be:
1. Create cgm files.
2. Open PowerPoint.
3. Open new presentation.
4. Insert Blank Slide.
5. Insert CGM file.
6. Resize image to fit slide.
[repeat steps 4-6 for as many slides as specified]
7. Save presentation as xxx.ppt.
8. Close PowerPoint.
So the whole process would be controlled from within SAS. Have people been
able to create such a system?
Thanks for any thoughts,