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
Get rid of 'replace' ?
I don't believe DBMS=XLSX supported multisheet excel workbooks until the latter versions. You need to include your SAS version, not EG.
As @Rezza pointed out, try other engine. DBMS=excel DBMS=xls
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.