The following sample shows you how to read an Excel file with a worksheet that contains quotation marks. Note the double and single quotation mark on the sheet name in addition to the quotation mark in the sheet name itself. The double quotation marks are on the outside and the single quotation marks are on the inside.

PROC IMPORT OUT= test
            DATAFILE= "C:\sastest\quoter1.xlsx"
            DBMS=EXCEL REPLACE;
     SHEET="'q2'12'" ;
     GETNAMES=yes;
    RUN;

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS/ACCESS Interface to PC Files	Microsoft® Windows® for 64-Bit Itanium-based Systems	9.2 TS2M3
		Microsoft Windows Server 2003 Datacenter 64-bit Edition	9.2 TS2M3
		Microsoft Windows Server 2003 Enterprise 64-bit Edition	9.2 TS2M3
		Microsoft Windows XP 64-bit Edition	9.2 TS2M3
		Microsoft® Windows® for x64	9.2 TS2M3
		Microsoft Windows Server 2003 Datacenter Edition	9.2 TS2M3
		Microsoft Windows Server 2003 Enterprise Edition	9.2 TS2M3
		Microsoft Windows Server 2003 Standard Edition	9.2 TS2M3
		Microsoft Windows Server 2003 for x64	9.2 TS2M3
		Microsoft Windows Server 2008	9.2 TS2M3
		Microsoft Windows Server 2008 for x64	9.2 TS2M3
		Microsoft Windows XP Professional	9.2 TS2M3
		Windows 7 Enterprise 32 bit	9.2 TS2M3
		Windows 7 Enterprise x64	9.2 TS2M3
		Windows 7 Home Premium 32 bit	9.2 TS2M3
		Windows 7 Home Premium x64	9.2 TS2M3
		Windows 7 Professional 32 bit	9.2 TS2M3
		Windows 7 Professional x64	9.2 TS2M3
		Windows 7 Ultimate 32 bit	9.2 TS2M3
		Windows 7 Ultimate x64	9.2 TS2M3
		Windows Vista	9.2 TS2M3
		Windows Vista for x64	9.2 TS2M3

* 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.

---

A short sample that shows how to read an Excel file that contains quotation marks in the worksheet name

Type:	Usage Note
Priority:

Date Modified:	2012-10-16 12:58:37
Date Created:	2012-09-18 11:14:02