Desktop productivity for business analysts and programmers

Export multiple datasets into excel with different sheets

Reply
Frequent Contributor
Posts: 111

Export multiple datasets into excel with different sheets

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

Super User
Posts: 10,130

Re: Export multiple datasets into excel with different sheets

Posted in reply to Ravikumarkummari

Get rid of 'replace'  ?

Super User
Posts: 20,236

Re: Export multiple datasets into excel with different sheets

Posted in reply to Ravikumarkummari

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

Super User
Posts: 10,130

Re: Export multiple datasets into excel with different sheets

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


Ask a Question
Discussion stats
  • 3 replies
  • 162 views
  • 0 likes
  • 3 in conversation