BookmarkSubscribeRSS Feed
Ravikumarkummari
Quartz | Level 8

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

3 REPLIES 3
Reeza
Super User

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

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


sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 2196 views
  • 0 likes
  • 3 in conversation