BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Jaheuk
Obsidian | Level 7

previous in sas9.2 doing two PROC exports with different SHEET names in the same physical xls did work . . . now in WIN7, sas9.3 the second proc export totally overrides the first one ??!!

H.

1 ACCEPTED SOLUTION
5 REPLIES 5
MaxW
Calcite | Level 5

Try dbms=excel with the file extension xlsx.

RW9
Diamond | Level 26 RW9
Diamond | Level 26

Are you sure, I have just exported two datasets to the same file and it worked fine.  Have your removed the replace option?


proc export data=xxx outfile="s:\temp\rob\temp.xls" replace;
  sheet="First";
run;
proc export data=yyy outfile="s:\temp\rob\temp.xls";
  sheet="Second";
run;

Anyways, more reason to come over to the darkside (the tagsets side that is :smileyshocked:)

Jaheuk
Obsidian | Level 7

hi guys,

it always worked (XP, 9.2, office2003) but since we have SAS9.3 and Office 2010 on a WIN7 machine:  we have to use

LIBNAME XLS PCFILES path="\....

I think things are changes with this way of working

H.

RW9
Diamond | Level 26 RW9
Diamond | Level 26

I would perhaps check your setup as I am using 9.3 on Win7 with Excel 2013 and the code works fine for me.  Its the same code I used on 9.2 with Vista and Office 2007.  As far as I am aware there is no change in operation on that. 

Are you using EG or some other SAS product, am assuming you have SAS/ACCESS licensed?  Otherwise I don't see why it wouldn't work.

---

proc export data=sashelp.cars outfile="s:\temp\rob\temp.xls" replace;

  sheet="First";

run;

proc export data=sashelp.gas outfile="s:\temp\rob\temp.xls";

  sheet="Second";

run;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 2590 views
  • 0 likes
  • 4 in conversation