It looks like you are trying to do something like that described by Roper in
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 <email@example.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);
> 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.