08-17-2017 02:34 AM
I am using sas enterprise guide 5.1 version with MS Office-2010.
I want to export two datasets into excel with 2 different sheets, I tried proc export
proc export data=dataset1 outfile="filename.xlsx"
proc export data=dataset2 outfile="filename.xlsx"
After this i am keeping this file in zip file and sending automailer.
ods package(Accounts) open nopf;
ods package(Accounts) add file="filaname.xls";
ods package(Accounts) publish archive
But in mail only the second sheets appears, is there any solution of exporting two sheets in excel.
In this dbms=excel and excelcs are not working.
Any help would be greatly appreciated
08-17-2017 11:12 AM
I don't believe DBMS=XLSX supported multisheet excel workbooks until the latter versions. You need to include your SAS version, not EG.