Date:         Wed, 16 Dec 2009 15:48:29 -0600
Reply-To:     "Data _null_;" <iebupdte@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Data _null_;" <iebupdte@GMAIL.COM>
Subject:      Re: help needed on DDE 'excel|system'
Comments: To: Tom Smith <tomquin99@gmail.com>
In-Reply-To:  <200912162115.nBGIQOl2007175@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

It looks like you are trying to do something like that described by Roper in
http://www2.sas.com/proceedings/sugi25/25/cc/25p097.pdf

I just tested the program and I works nicely to open EXCEL and wait
the least amount of time, before continuing.  Then you are ready to
DDE as you see fit.

On 12/16/09, Tom Smith <tomquin99@gmail.com> wrote:
> It seems that my system has problem with SAS DDE 'excel|system'.
>
> For example,
>
> filename sas2xl dde 'excel|system';
> data _null_;
>  fid = fopen('sas2xl','s');
>   rc = fclose(fid);
> run;
>
> SAS just keeps running till Not Responding. Any command/fuction that is
> put through it to Excel has the same problem.
>
> How should I error check my system/SAS to resolve the problem ?
> Thanks for any hint.
>