Hi,   I have an issue when using DDE.   What is happening is I make a copy of my EXCEL master file (example.xls) using SAS, I then open this copied EXCEL file using SAS, then simply close it. That's it, howerver the master EXCEL file (i.e. the one I copied) for reason is locked and when I open it, its says "Read Only" at the top until I close my entire EXCEL process. I'm not sure why this is happening. Below is my code.     %let inpath=C:\; %let infile=example; %let extension=xls; %sysexec copy "&inpath.\&infile..&extension." "%sysfunc(getoption(work))\&sysuserid._&infile..&extension."; ** Get EXCEL commands; filename cmdexcel DDE 'EXCEL|SYSTEM'; data _null_; ** Open EXCEL command; fid = fopen('CMDEXCEL', 'S'); if (fid=0) then do; ** Open EXCEL; rc = system("Start Excel"); start = datetime(); stop = start + 10; ** 10sec limit; end; do while (fid eq 0); fid = fopen('CMDEXCEL', 'S'); time = datetime(); if time ge stop then fid = -1; end; if fid lt 0 then put 'ERR' "OR: Excel failed to open (within time limit)."; run; data _null_; ** Open file **; call system ("'%sysfunc(getoption(work))\&sysuserid._&infile..&extension.', 0, true"); x = sleep(1); run; filename cmdexcel clear; filename cmdexcel DDE 'EXCEL|SYSTEM'; ** Close EXCEL file; data _null_; file cmdexcel; x=sleep(3); put '[error(false)]'; put '[CLOSE(false)]'; run; filename cmdexcel clear; %sysexec del "%sysfunc(getoption(work))\&sysuserid._&infile..&extension."; All I need is to ensure the master EXCEL file does not lock and does in fact close (well it technically should never open because I use a copied file).    Running SAS 9.4 on windows.   Thanks ... View more

Hi, I am trying to use the PROC SQL pass through facility to import a .XML file. Below is an example of something I use for EXCEL files, is there a .XML equivalent?   proc sql noprint; connect to excel (path = "\\MyArea\My_File.xls"); create table contents as select * from connection to excel (select * from [Contents$]); disconnect from excel; quit; The above code would pick up the tab called "Contents" and create a SAS data set call Contents.   Thanks ... View more