Date:         Wed, 14 Jan 2009 09:38:55 -0600
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: Excel editable graphs with SAS
In-Reply-To:  <200901141410.n0EBl99l028829@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

I agree with Gerhard; we do several projects that require this, and DDE is
the easiest way.

If you cannot do DDE, then you can produce a static file with data, and then
write a short VBA macro in Excel to create the graph from the data you
produce.  This shouldn't be difficult even if you don't know VBA, as you can
just record a macro from creating the graph the first time, and then reuse
that macro.

-Joe

On Wed, Jan 14, 2009 at 8:10 AM, Gerhard Hellriegel <
gerhard.hellriegel@t-online.de> wrote:

> I'm not aware that it is possible to edit graphs with EXCEL!? Do you mean
> that EXCEL graphs, produced from table-areas? In that case, you could
> create a template with data and the attached graphs. Maybe it is possible
> to create that graphs via commands, in that case that might also be
> possible from SAS, but I think it is easier to create them from EXCEL.
> After that you create a DDE connection for the data areas and send the new
> data from SAS to EXCEL via DDE. The graphs should adapt to that new (or
> changed) data.
>
> Other graphs (GIF, JPG, PNG, ...) are static in EXCEL. I don't think that
> EXCEL has a graphic editor to manipulate GIFs or JPGs.
>
> Gerhard
>
>
>
>
>
>
>
> On Wed, 14 Jan 2009 10:58:55 +0100, Erwan LE DU <dotker@GMAIL.COM> wrote:
>
> >Hi everyone,
> >
> >Does anyone know whether it is possible to create editable Excel graphs
> from
> >SAS, ie not an image file.
> >
> >Thanks,
> >
> >Erwan
>