When you read a SAS table from PowerPivot for Excel 2013 via a SAS ODBC data source, the following error might occur in the PowerPivot for Excel Table Import Wizard:

This problem occurs if the SAS table contains at least one column with a label defined.

You can work around this problem by setting option=nolabel in the SAS server session.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	Base SAS	Microsoft® Windows® for 64-Bit Itanium-based Systems	9.4 TS1M1
		Microsoft® Windows® for x64	9.4 TS1M1
		Microsoft Windows 8 Enterprise 32-bit	9.4 TS1M1
		Microsoft Windows 8 Enterprise x64	9.4 TS1M1
		Microsoft Windows 8 Pro 32-bit	9.4 TS1M1
		Microsoft Windows 8 Pro x64	9.4 TS1M1
		Microsoft Windows 8.1 Enterprise 32-bit	9.4 TS1M1
		Microsoft Windows 8.1 Enterprise x64	9.4 TS1M1
		Microsoft Windows 8.1 Pro	9.4 TS1M1
		Microsoft Windows 8.1 Pro 32-bit	9.4 TS1M1
		Microsoft Windows Server 2008	9.4 TS1M1
		Microsoft Windows Server 2008 R2	9.4 TS1M1
		Microsoft Windows Server 2008 for x64	9.4 TS1M1
		Microsoft Windows Server 2012 Datacenter	9.4 TS1M1
		Microsoft Windows Server 2012 R2 Datacenter	9.4 TS1M1
		Microsoft Windows Server 2012 R2 Std	9.4 TS1M1
		Microsoft Windows Server 2012 Std	9.4 TS1M1
		Windows 7 Enterprise 32 bit	9.4 TS1M1
		Windows 7 Enterprise x64	9.4 TS1M1
		Windows 7 Home Premium 32 bit	9.4 TS1M1
		Windows 7 Home Premium x64	9.4 TS1M1
		Windows 7 Professional 32 bit	9.4 TS1M1
		Windows 7 Professional x64	9.4 TS1M1
		Windows 7 Ultimate 32 bit	9.4 TS1M1
		Windows 7 Ultimate x64	9.4 TS1M1

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

---

This error occurs when you read a SAS table that contains labeled columns from PowerPivot for Excel using a SAS ODBC data source.

Type:	Problem Note
Priority:	medium

Date Modified:	2014-06-24 15:23:57
Date Created:	2014-06-18 08:36:55