topic Re: WIN7, SAS9.3: proc export with dbms=XLSX in ODS and Base Reporting

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

Jaheuk — Thu, 10 Apr 2014 14:30:49 GMT

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 ??!!

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

MaxW — Thu, 10 Apr 2014 14:44:25 GMT

Try dbms=excel with the file extension xlsx.

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

RW9 — Thu, 10 Apr 2014 14:48:48 GMT

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:)

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

Jaheuk — Tue, 15 Apr 2014 09:43:13 GMT

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

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

RW9 — Tue, 15 Apr 2014 09:59:41 GMT

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;

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

Andre — Tue, 15 Apr 2014 10:02:58 GMT

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