Problem Note 19827: PROC IMPORT cannot use RANGE option when EXCEL spreadsheet has special
Character in Sheet name
The use of special characters such as ", $ or # as part of an Excel
sheet name causes problems with the MS Jet when used with the RANGE
statement. The following code will produce a Warning/Error similar to
the one shown:
PROC IMPORT DATAFILE= "scenario2.xls" DBMS=EXCEL OUT=mydata REPLACE;
SHEET="'Scenario2$'";
RANGE='A13:D113';
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;
WARNING: SHEET name will be ignored if conflict occurs with
RANGE name specified
ERROR: File _IMEX_.'Scenario2$A13:D113'n.DATA does not exist.
A workaround is to change the sheet name not to contain a special
character or to use the RANGE statement without the SHEET statement if
the range name is available, such as RANGE='sheet_name$A1:C7'n;
Operating System and Release Information
SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows XP Professional | 9.2 | | | 9.2 TS1M0 |
Microsoft Windows Server 2003 Standard Edition | 9.2 | | | 9.2 TS1M0 |
Windows Vista | 9.2 | | | 9.2 TS1M0 |
Microsoft Windows Server 2003 Enterprise Edition | 9.2 | | | 9.2 TS1M0 |
Microsoft Windows Server 2003 Datacenter Edition | 9.2 | | | 9.2 TS1M0 |
Microsoft Windows 2000 Advanced Server | 9.2 | | | 9.2 TS1M0 |
Microsoft Windows 2000 Datacenter Server | 9.2 | | | 9.2 TS1M0 |
Microsoft Windows 2000 Professional | 9.2 | | | 9.2 TS1M0 |
Microsoft Windows 2000 Server | 9.2 | | | 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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2008-03-06 14:31:16 |
Date Created: | 2007-03-23 09:03:01 |