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.
> >
>
|
|
0
|
|
|
|
Reply
|
tomquin99 (72)
|
12/16/2009 10:54:16 PM |
|