I believe XLSX actually uses XML while XLS is another format. So just changing the extension leaves the XML and excel warns that something funny is going on.
An all sas solution would probably be to read the XML into a sas dataset then export the sas dataset to excel using a libname with excel engine or just a proc export step.
There is code that will search a folder (or a drive for that matter) for a certain file type (xml) then all you need to do is loop through all the files that are returned through the dataset creation and export phases.
To get you started here is some code I use to search a specific folder and exclude files with a tiff extension from the output:
%let folder = U:\Test; /*Folder you are looking in*/
Data txt_file (keep=file_name file row );
length file_name file $20 ;
rc = filename("dir","&folder");
d = dopen("dir");
n = dnum(d);
do i = 1 to n;
file_name = dread(d,i);
file = scan(file_name,1,".",'R');
row + 1;
if indexw(file_name,"Tiff")>0 then ;
else output;
end;
run;
Here is the beginning of the macro code that uses the output from above:
%macro test;
proc sql noprint;
select count(*) into: cnt
from txt_file
;
quit;
%do i = 1 %to &cnt;
proc sql noprint;
select strip(file_name), strip(file) into :fn, :f
from txt_file
where row = &i
;
quit;
data _null_;
date = strip(put(date(),weekdate.));
time = strip(put(time(),timeampm.));
call symput('date',date);
call symput('time',time);
run;
%put ***************************;
%put Date: &date;
%put Time: &time;
%put &i of %sysfunc(strip(&cnt)) : &fn ;
%put ***************************;
/*PUT YOUR XML TO SAS HERE*/
/*PUT YOUR SAS TO XLS HERE*/
%mend test;
Hope this gets you going in the right direction!
EJ
