Export multiple datasets into excel with different sheets

[Ravikumarkummari]

Hi all,

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"
dbms=xlsx

replace;
sheet="salaries";
run;

proc export data=dataset2 outfile="filename.xlsx"
dbms=xlsx

replace;
sheet="department";
run;

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
properties(archive_name="Accounts.zip"
archive_path="/SAS/BIU/INPUT");
ods package(Accounts) 
close;

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

[Ksharp]

Get rid of 'replace'  ?

[Reeza]

I don't believe DBMS=XLSX supported multisheet excel workbooks until the latter versions. You need to include your SAS version, not EG. 

[Ksharp]

As @Rezza pointed out, try other engine.
DBMS=excel 
DBMS=xls