I'm having the same issue. The code below works on a computer in my environment with Excel 2010, but freezes SAS on a separate computer with Excel 2013. options noxwait noxsync xmin; filename sas2xl dde 'excel|system'; data _null_; length fid rc start stop time 8; fid = fopen('sas2xl','s'); if (fid le 0) then do; rc = system('start excel'); start = datetime(); stop = start+10; do while (fid le 0); fid = fopen('sas2xl','s'); time=datetime(); if (time ge stop) then fid = 1; end; end; rc=fclose(fid); run;
... View more