The SAS Output Delivery System and reporting techniques

WIN7, SAS9.3: proc export with dbms=XLSX

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

WIN7, SAS9.3: proc export with dbms=XLSX

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.


Accepted Solutions
Solution
‎04-15-2014 06:02 AM
Super Contributor
Posts: 273

Re: WIN7, SAS9.3: proc export with dbms=XLSX


All Replies
New Contributor
Posts: 4

Re: WIN7, SAS9.3: proc export with dbms=XLSX

Try dbms=excel with the file extension xlsx.

Super User
Super User
Posts: 7,720

Re: WIN7, SAS9.3: proc export with dbms=XLSX

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 :smileyshockedSmiley Happy

Frequent Contributor
Posts: 89

Re: WIN7, SAS9.3: proc export with dbms=XLSX

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.

Super User
Super User
Posts: 7,720

Re: WIN7, SAS9.3: proc export with dbms=XLSX

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;

Solution
‎04-15-2014 06:02 AM
Super Contributor
Posts: 273

Re: WIN7, SAS9.3: proc export with dbms=XLSX

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

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