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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.