04-10-2014 10:30 AM
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 ??!!
04-10-2014 10:48 AM
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;
proc export data=yyy outfile="s:\temp\rob\temp.xls";
Anyways, more reason to come over to the darkside (the tagsets side that is :smileyshocked
04-15-2014 05:43 AM
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
04-15-2014 05:59 AM
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;
proc export data=sashelp.gas outfile="s:\temp\rob\temp.xls";