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.

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.
>

I do not find a solution to the problem in this paper.

The problem is that, I think, SAS can not successfully send commands to
Excel throught filename DDE  'excel|system'.

I am not clear where the bug is, Windows, Office Excel, or SAS.

Thanks for responding.

On Wed, Dec 16, 2009 at 4:48 PM, Data _null_; <iebupdte@gmail.com> wrote:

> 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.
> >
>