Hi Kurt, Many thanks for your explanation. I resolved my question by your and Reeza's reply in another post "How to convert XML files to XLS (Excel 2003)?". All files saved by tagsets excel.xp can be convered to XLS now. However, the next step after converting XML to XLS, I would like to import to SAS back with code: Proc Import datafile="xxx.xls" out=test dbms=excel replace; mixed=yes; guessingrows=100; sheet="sheet1"; run; Per other posts in SAS communities, guessingrows option seems not work for XLS file, so after that I converted XML to XLSX and tried to import it with mixed=yes again. It works, BUT some floats will not displayed what I want. Is there any suggestion to keep the format of floats without another complicated statement? because there're many XLSX files need to be imported. Or, is there suitable code to convert XML to CSV? maybe change the file format num in red as the following code: put " oXL.ActiveWorkBook.SaveAs Left(aFile, Len(aFile) - 4) & "".xls"",-4143"; JC
... View more