help needed on DDE 'excel|system'
in [SAS]
|
From: Savian on 17 Dec 2009 23:17 On Dec 16, 6:36 pm, tomqui...(a)GMAIL.COM (Tom Quin) 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_; <iebup...(a)gmail.com> wrote: > > On 12/16/09, Tom Quin <tomqui...(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?- Hide quoted text - > > - Show quoted text - Why are you using DDE at all? I have been following this thread and I still don't know why people use DDE, I really don't. 1. It is deprecated. 2. It is slow. 3. It locks Excel, the PC, and the file. 4. It lacks flexibility and support of newer areas. 5. There are better ways to do things that are actually easier. DDE is like CPM. Great in its time but there are far better technologies available. I still don't get why SAS programmers still use DDE. However, I am open (this is not an incrimination just confusion on my part). Why are people using DDE? Alan http://www.savian.net
From: Tom Quin on 18 Dec 2009 09:46 Nat & Arthur, If SAS is communicating thru DDE Excel|system, it will freeze(Not Responding), no matter we open an Excel workbook in advance or not. So the next step of Sleep will not be reached. I will publish the solution on the list if I resolve the problem. Thanks a lot for help. On Thu, Dec 17, 2009 at 10:02 PM, Nathaniel Wooding < nathaniel.wooding(a)dom.com> wrote: > Tom > > > > My usual approach is to launch Excel using an X command and as in the > example that I believe that I sent you, I include the file to be opened a= t > that time. I am not certain whether you can refer to the =93system=94 unt= il you > have a workbook loaded. I would first try increasing the length of your > sleep session. > > > > Nat > > > > *From:* Tom Quin [mailto:tomquin99(a)gmail.com] > *Sent:* Thursday, December 17, 2009 3:55 PM > *To:* Nathaniel Wooding (Services - 6) > *Cc:* SAS-L(a)LISTSERV.UGA.EDU > > *Subject:* Re: help needed on DDE 'excel|system' > > > > 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 =3D fopen('sas2xl','s'); > rc =3D 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=3Dsleep(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(a)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(a)LISTSERV.UGA.EDU] On Behalf Of Tom > Quin > Sent: Wednesday, December 16, 2009 8:37 PM > To: SAS-L(a)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(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? > > > > 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. > > > > *CONFIDENTIALITY NOTICE:* This electronic message contains information > which may be legally confidential and or privileged and does not in any c= ase > represent a firm ENERGY COMMODITY bid or offer relating thereto which bin= ds > 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 ha= ve > received this electronic transmission in error, please reply immediately = to > the sender that you have received the message in error, and delete it. Th= ank > you. >
From: Arthur Tabachneck on 18 Dec 2009 11:12
On Thu, 17 Dec 2009 20:17:56 -0800, Savian <savian.net(a)GMAIL.COM> wrote: Alan, You've encouraged my cynical response: 1. because SAS/Access for PC Files is only provided as an extra-cost addon 2. because it allows one to write and run excel and word macros from SAS 3. because it can add otherwise missing challenges/excitment when needed during a boring day 4. because otherwise those skills might get lost and not be available if needed someday Art ------ >Why are you using DDE at all? I have been following this thread and I >still don't know why people use DDE, I really don't. > >1. It is deprecated. >2. It is slow. >3. It locks Excel, the PC, and the file. >4. It lacks flexibility and support of newer areas. >5. There are better ways to do things that are actually easier. > >DDE is like CPM. Great in its time but there are far better >technologies available. > >I still don't get why SAS programmers still use DDE. However, I am >open (this is not an incrimination just confusion on my part). Why are >people using DDE? > >Alan >http://www.savian.net |