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;
... View more
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.
... View more
