Problem Note 36127: Table names that have more than 26 characters might cause an exception when running a task in the SAS® Add-In for Microsoft Office
 |  |  |  |  |
In the SAS Add-In for Microsoft Office, when running a task with a table name that has more than 26 characters, you might see the following exception:
"Task name" completed with errors
When you view the log associated with the task error, you will see the following error message:
ERROR 65-58: Name '_TEMP_MYDATA_27CHARLONGXXXXXXXXXXX' is too long for a SAS name in this context.
You might also see the following error message when applying a filter opening a table with a long name in a pivot table:
"Table name" encountered error(s) while opening the results.
If your table name has more than 26 characters, this problem can occur when you apply a filter to the data before running your task or opening the table into a pivot table. When you apply the filter, the SAS Add-in creates a temporary table that adds _TEMP_ to the beginning of the name. In doing so, the resulting table name exceeds the maximum allowed length for SAS tables, which results in the error.
As a workaround, shorten your table name so that it has fewer than 26 characters.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Windows Vista | 2.1 | 4.2 | 9.2 TS2M0 | |
| Windows Millennium Edition (Me) | 2.1 | |||||
| Microsoft Windows XP Professional | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2008 | 2.1 | |||||
| Microsoft Windows Server 2003 Standard Edition | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Microsoft Windows NT Workstation | 2.1 | |||||
| Microsoft Windows 2000 Professional | 2.1 | |||||
| Microsoft Windows 2000 Server | 2.1 | |||||
| Microsoft Windows 2000 Datacenter Server | 2.1 | |||||
| Microsoft Windows 2000 Advanced Server | 2.1 | |||||
| Microsoft Windows 95/98 | 2.1 | |||||