Date: Tue, 11 Jan 2011 18:32:55 -0500
Reply-To: Lorne Klassen <lk1@ROGERS.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Lorne Klassen <lk1@ROGERS.COM>
Subject: Re: Proc Export difference between dbms=xls and dbms=excel
Content-Type: text/plain; charset=ISO-8859-1
And as for your error message under 9.1, apparently it's because you can't
use the SHEET statement under 9.1 with DBMS=XLS until you apply a Hotfix.
From SAS website:
In SAS 9.1, multiple sheets are not allowed in workbooks in SAS® 9.1.
After you have applied Hot Fix E9PF06 to your system, the XLS engine
enables you to use the SHEET= option in the EXPORT procedure. However this
option does not enable you to write multiple sheets to the same workbook.
If you don't need to export multiple sheets to the same workbook, applying
the Hotfix should be sufficient.
But if you need to export multiple sheets to the same workbook, it won't
work under 9.1.
One solution is to use 9.2 everywhere.
If this is not feasible you can use automatic macro vars SYSVER and
SYSSCPL to determine what environment you are running in and then generate
the appropriate DBMS setting:
64-bit and 9.2: Use DBMS=XLS
32-bit and 9.2: Use DBMS=XLS
32-bit and 9.1: Use DBMS=EXCEL2003
For the last one I don't recommend DBMS=EXCEL because if it's the first
time you are creating the workbook then it might create it in Excel 2007
format. Then if you later try to add a sheet with DBMS=XLS, it will fail
because DBMS=XLS is not compatible with Excel 2007.