DDE not responding in SAS
in [SAS]
|
Prev: Macro Variable - Data _null_ statement - Help
Next: STATEMENT AND SYNTAX for robust standard errors in Zero inflated
From: Nathaniel Wooding on 22 Feb 2010 18:02 Cherub DDE is a windows feature so I would be surprised that it could be disabled on a windows computer. What error messages are you receiving and does Excel open? It may be that the "non-dde" computer either has a different version of Excel installed or that the path to it is different. Nat Wooding -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of cherub Sent: Monday, February 22, 2010 4:38 PM To: SAS-L(a)LISTSERV.UGA.EDU Subject: DDE not responding in SAS My SAS doesn't responding when I use DDE. The code I submitted is below options noxwait noxsync; x '"c:\program files\microsoft office\office11\excel.exe"'; /* Open spreadsheet to write to */ filename sas2xl dde 'excel|system'; data _null_; file sas2xl; put '[open("pathname")]'; I tried this code on another computer, it worked. I guess that this is because DDE can not be set up on this computer, so the problem exists in "filename sas2xl dde 'excel|system';" However, can anybody how to fix this error, this may not SAS problem? but Where I can start to debug this error? Thanks!!! 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.
From: Ya Huang on 22 Feb 2010 18:08 Interesting, I had the same issue today! Try Windows Task Manager 'CTRL+ALT+Del' and check if an Excel is already running. If so, kill it and it may work again. On Mon, 22 Feb 2010 13:38:11 -0800, cherub <cherub2life(a)YAHOO.COM> wrote: >My SAS doesn't responding when I use DDE. >? >The code I submitted is below >options noxwait noxsync; > >x '"c:\program files\microsoft office\office11\excel.exe"'; > >/* Open spreadsheet to write to */ > >filename sas2xl dde 'excel|system'; > >data _null_; >file sas2xl; >put '[open("pathname")]'; >? >I tried this code on another computer, it worked. I guess that this is because DDE can not be set up on this computer, so the problem exists in "filename sas2xl dde 'excel|system';" >? >However, can anybody how to fix this error, this may not SAS problem? but Where I can start to debug this error? >? >Thanks!!!
From: Lou on 22 Feb 2010 19:58 "cherub" <cherub2life(a)YAHOO.COM> wrote in message news:837216.67677.qm(a)web113403.mail.gq1.yahoo.com... > My SAS doesn't responding when I use DDE. > =A0 > The code I submitted is below > options noxwait noxsync; > > x '"c:\program files\microsoft office\office11\excel.exe"'; > > /* Open spreadsheet to write to */ > > filename sas2xl dde 'excel|system'; > > data _null_; > file sas2xl; > put '[open("pathname")]'; > =A0 > I tried this code on another computer, it worked. I guess that this is beca= > use DDE can not be set up on this computer, so the problem exists in "filen= > ame sas2xl dde 'excel|system';" > =A0 > However, can anybody how to fix this error, this may not SAS problem? but W= > here I can start to debug this error? > =A0 > Thanks!!!=0A=0A=0A Let's start with the simple stuff - did Excel open? On my computer, the Excel executable is located in directory C:\Program Files\Microsoft Office\Office12
From: Sudo Ku on 22 Feb 2010 19:54
=20 Hi Cherub: =20 I've occasionally run into excel not working with DDE in SAS. What I have h= ad to do was rebuild personal.xls or personal.wpt in word. =20 I have a technical bulliten somewhere but I just can't find it. I would sug= gest you look at how excel is working rather than SAS in your session. =20 I have found my problems were exacerbated when I had alot of macros in my p= ersonal file.=20 =20 Regards=2C =20 Kevin =20 > Date: Mon=2C 22 Feb 2010 13:38:11 -0800 > From: cherub2life(a)YAHOO.COM > Subject: DDE not responding in SAS > To: SAS-L(a)LISTSERV.UGA.EDU >=20 > My SAS doesn't responding when I use DDE. > =20 > The code I submitted is below > options noxwait noxsync=3B >=20 > x '"c:\program files\microsoft office\office11\excel.exe"'=3B >=20 > /* Open spreadsheet to write to */ >=20 > filename sas2xl dde 'excel|system'=3B >=20 > data _null_=3B > file sas2xl=3B > put '[open("pathname")]'=3B > =20 > I tried this code on another computer=2C it worked. I guess that this is = because DDE can not be set up on this computer=2C so the problem exists in = "filename sas2xl dde 'excel|system'=3B" > =20 > However=2C can anybody how to fix this error=2C this may not SAS problem?= but Where I can start to debug this error? > =20 > Thanks!!! >=20 >=20 >=20 Live connected with Hotmail on your phone. Learn more. =20 _________________________________________________________________ Introducing Windows=AE phone. http://go.microsoft.com/?linkid=3D9708122= |