Usage Note 33086: ODBC errors can occur when you use the ExcelCS engine to export SAS output to Excel
In the UNIX or Windows 64 environment, when you use the ExcelCS engine to export SAS output to Excel you can receive the following error:
ERROR: The ODBC table class has been opened for OUTPUT.
This table already exists, or there is a name conflict with
an existing object. This table will not be replaced.
This engine does not support the REPLACE option.
The error message will occur if the Excel file already exists and attempts to replace the Excel file, The error occurs despite the fact that the REPLACE option is specified in the EXPORT procedure.
The problem occurs when the name of the Excel file (.xls) is not specified or if the filename does not have the .xls extension in the OUTFILE= option, as shown in this example:
proc export data=sashelp.class dbms=excelcs
outfile="\\network-name\directory\my-file" replace;
port=8621;
server='your-server';
sheet='class';
run;
To resolve the problem, specify the name of the Excel file or the extension in the OUTFILE= option, as shown in this example:
proc export data=sashelp.class dbms=excelcs
outfile="\\network-name\directory\my-file.xls" replace;
port=8621;
server='your-server';
sheet='class';
run;
On Windows operating systems, the EXCEL engine repaces a default Excel file; however, the EXCELCS engine does not replace such a file.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to PC Files | 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | |
64-bit Enabled AIX | 9.1 TS1M3 SP4 | |
64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | |
HP-UX IPF | 9.1 TS1M3 SP4 | |
Linux | 9.1 TS1M3 SP4 | |
Linux on Itanium | 9.1 TS1M3 SP4 | |
Solaris for x64 | 9.1 TS1M3 SP4 | |
Tru64 UNIX | 9.1 TS1M3 SP4 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | |
Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | |
Microsoft® Windows® for x64 | 9.2 TS1M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
In the UNIX or Windows 64 bit environments, an ODBC error occurs when you use the ExcelCS engine to export SAS output to Excel when improper the OUTFILE parameter does not have the full Excel path.
Date Modified: | 2009-10-21 12:45:50 |
Date Created: | 2008-08-27 14:41:19 |