Prev: Screening factors for logistic regression
Next: Trend matching
From: "Data _null_;" on 16 Dec 2009 16:48
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(a)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.
>
From: Tom Quin on 16 Dec 2009 17:54
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(a)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(a)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.
> >
>
From: "Data _null_;" on 16 Dec 2009 18:31
On 12/16/09, Tom Quin <tomquin99(a)gmail.com> wrote:
> The problem is that, I think, SAS can not successfully send commands to
> Excel throught filename DDE 'excel|system'.

No, SAS can send commands to EXCEL through DDE but your program is not
doing that.

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

The bug is in your program.

What are you trying to do?
From: Tom Quin on 16 Dec 2009 20:36
Let me say the problem is that dde 'excel|system' does not work on my
computer. In my last example, fopen('sas2xl','s') does not work, causing SAS
not responding. Another example,
filename sas2xl dde 'excel|system';
data _null_;
file sas2xl;
put '[error(false)]';
put '[open("c:\mydir1\Myxls.xls")]';
run;

also makes SAS not responding.

I can use x command to start an excel file or x 'start Excel' to start
excel.

Why excel|system can not function on my computer?



On Wed, Dec 16, 2009 at 6:31 PM, Data _null_; <iebupdte(a)gmail.com> wrote:

> On 12/16/09, Tom Quin <tomquin99(a)gmail.com> wrote:
> > The problem is that, I think, SAS can not successfully send commands to
> > Excel throught filename DDE 'excel|system'.
>
> No, SAS can send commands to EXCEL through DDE but your program is not
> doing that.
>
> > I am not clear where the bug is, Windows, Office Excel, or SAS.
>
> The bug is in your program.
>
> What are you trying to do?
>
From: Arthur Tabachneck on 16 Dec 2009 20:48
Tom,

The following link probably doesn't add much more than the one that
data_null_ provided earlier, but it does point out that one can get the
exact message you got if sas isn't put to sleep waiting until Excel has a
chance to respond:

http://www.lexjansen.com/wuss/2007/ApplicationsDevelopment/APP_SmithC_Import
ingExcelFiles.pdf
or, in short form: http://xrl.us/bgkf8j

HTH,
Art
---------
On Wed, 16 Dec 2009 20:36:40 -0500, Tom Quin <tomquin99(a)GMAIL.COM> wrote:

>Let me say the problem is that dde 'excel|system' does not work on my
>computer. In my last example, fopen('sas2xl','s') does not work, causing
SAS
>not responding. Another example,
>filename sas2xl dde 'excel|system';
>data _null_;
>file sas2xl;
>put '[error(false)]';
>put '[open("c:\mydir1\Myxls.xls")]';
>run;
>
>also makes SAS not responding.
>
>I can use x command to start an excel file or x 'start Excel' to start
>excel.
>
>Why excel|system can not function on my computer?
>
>
>
>On Wed, Dec 16, 2009 at 6:31 PM, Data _null_; <iebupdte(a)gmail.com> wrote:
>
>> On 12/16/09, Tom Quin <tomquin99(a)gmail.com> wrote:
>> > The problem is that, I think, SAS can not successfully send commands to
>> > Excel throught filename DDE 'excel|system'.
>>
>> No, SAS can send commands to EXCEL through DDE but your program is not
>> doing that.
>>
>> > I am not clear where the bug is, Windows, Office Excel, or SAS.
>>
>> The bug is in your program.
>>
>> What are you trying to do?
>>
 |  Next  |  Last
Pages: 1 2 3
Prev: Screening factors for logistic regression
Next: Trend matching