Date: Thu, 17 Dec 2009 18:10:50 -0500
Reply-To: Arthur Tabachneck <art297@NETSCAPE.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Arthur Tabachneck <art297@NETSCAPE.NET>
Subject: Re: help needed on DDE 'excel|system'
Tom,
The following SAS note might not be relevant, but it's worth a try:
http://support.sas.com/kb/32/672.html
In short, unless you're on 9.2, there are known problems that might be
overcome by placing a sleep data step after EVERY dde data step. I'd
suggest trying that and letting the list know if it helped.
Art
-------
On Thu, 17 Dec 2009 15:55:16 -0500, Tom Quin <tomquin99@GMAIL.COM> wrote:
>Thanks a lot for help.
>Excel can not be started by fopen function or put [open] command through
DDE
>excel|system.
>
>options noxwait noxsync;
>filename sas2xl dde 'excel|system';
>data _null_;
>
> fid = fopen('sas2xl','s');
> rc = fclose(fid);
>run;
>
>* now SAS becomes not responding;
>
>I tried openning an excel file by X command, and then close it thru DDE.
SAS
>also becomes Not Respoding:
>x '"C:\Program Files\Microsoft Office\Office11\excel.exe"';
>data _null_;
> x=sleep(6);
>run;
>filename cmds dde 'excel|system'; * up to now the code works good;
>data _null_;
> file cmds;
> put '[QUIT()]';
>run; * SAS becomes frozen;
>I guess SAS perhaps is waiting for a return code from DDE but never get it.
>Any idea ?
>
>Thanks again.
>
>On Thu, Dec 17, 2009 at 6:07 AM, Nathaniel Wooding <
>nathaniel.wooding@dom.com> wrote:
>
>> The problem may be that your code asks to associate the fileref with
>> something that does not exist. Have you tried
>>
>> data _null_;
>> file sas2xl;
>> put '[error(false)]';
>> put '[open("c:\mydir1\Myxls.xls")]';
>> filename sas2xl dde 'excel|system';
>> run;
>>
>>
>> -----Original Message-----
>> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Tom
>> Quin
>> Sent: Wednesday, December 16, 2009 8:37 PM
>> To: SAS-L@LISTSERV.UGA.EDU
>> Subject: Re: help needed on DDE 'excel|system'
>>
>> 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@gmail.com> wrote:
>>
>> > On 12/16/09, Tom Quin <tomquin99@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?
>> >
>> CONFIDENTIALITY NOTICE: This electronic message contains
>> information which may be legally confidential and or privileged and
>> does not in any case represent a firm ENERGY COMMODITY bid or offer
>> relating thereto which binds the sender without an additional
>> express written confirmation to that effect. The information is
>> intended solely for the individual or entity named above and access
>> by anyone else is unauthorized. If you are not the intended
>> recipient, any disclosure, copying, distribution, or use of the
>> contents of this information is prohibited and may be unlawful. If
>> you have received this electronic transmission in error, please
>> reply immediately to the sender that you have received the message
>> in error, and delete it. Thank you.
>>
| 
