=========================================================================
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"

Hi All,

I'm trolling for thoughts on automating the export of graphs produced by SAS
to PowerPoint.

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
http://support.microsoft.com/support/kb/articles/q215/6/01.asp?FR=0, which
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,