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

[Jaheuk]

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.

[MaxW]

Try dbms=excel with the file extension xlsx.

[RW9]

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]

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]

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;

[Andre · Accepted solution]

Jaheuk,

yes indeed,

start at

http://blogs.sas.com/content/sasdummy/2012/02/11/export-excel-methods/

and

http://support.sas.com/kb/43/802.html

Andre