Hi All, Sometimes there are some ways to get the same goal, I Will show you other way to get It. You can use a new library to Excel file with LIBNAME MyExcel XLSX "path\name.xlsx"; Then if you have a dataset named "Wombat", you only must to do a data step DATA MyExcel.Wombat; SET Work.Wombat; RUN; And you can append all sheets that you need with only a data step. If you any ods in excel, you could merge all in an only Excel file with Excel libraries Finally you must disconnect all Excel file with. LIBNAME MyExcel CLEAR;
... View more