topic Re: SAS 9.4 is getting freezed when using DDE in SAS Programming

SAS 9.4 is getting freezed when using DDE

Masetty143 — Wed, 08 May 2019 15:01:12 GMT

Hi Team,

When I am invoking Excel from SAS using DDE facility. SAS 9.4 is getting hanged, I have only SAS 9.4. Previously when I use 9.3 it was workig well.

Kindly help in this regard.

Thanks,

Madhav.

Re: SAS 9.4 is getting freezed when using DDE

ballardw — Wed, 08 May 2019 15:36:07 GMT

Has anything at all other than your SAS version changed?

The version of Excel can make a difference depending on what you are doing as the file type may need to be updated to match.

You should at least show the attempted code.

Note that there are other programs that interfere with DDE because the address or communication spaces are not protected and others access them causing DDE to fail.

I know that Cisco Jabber is one program that will interfere with DDE. If you have Jabber running or installed as a service you have to KILL the process, not just close any active window but use Task Manager and kill the process, before DDE will work.

Since DDE is not actively supported it may be time to consider completely replacing the approach as anything using DDE will get more and more fragile as time goes no.

Re: SAS 9.4 is getting freezed when using DDE

Masetty143 — Thu, 09 May 2019 05:44:35 GMT

Thanks for your reply.

1. Previously I was using Excel 2007 now it is Excel 2016.

Please find the code I have used.

%let xls=P:\SBIM MIS\Regular MI\Sameday\6pm\Dataset\Insurance\CBMS SME FX DEAL- (effective fr 13 May).xlsx;
%let xls1=P:\SBIM MIS\Regular MI\Sameday\6pm\Dataset\Insurance\CBMS SME FX DEAL- (effective fr 13 May)_v1.xls;
%let pswd_1=Branch;

FILENAME xls DDE 'excel|system';
DATA _null_;
FILE xls;
PUT '[open("'&xls'")]';
RUN;

Re: SAS 9.4 is getting freezed when using DDE

Masetty143 — Fri, 10 May 2019 06:43:50 GMT

Otherwise if you have any alternative, please suggest the same.