Usage Note 36204: Labels are truncated to 64 characters when you import Excel headers into the SAS® System or you use the DBLABEL option to write SAS labels to Excel
SAS labels can contain up to 256 characters. However, a label is 64 characters when you import Microsoft Excel headers into SAS or when you use the DBLABEL= option to write SAS labels to Excel.
The truncation occurs because of a limitation of the Microsoft JET and ACE engines, which SAS uses. These engines truncate header rows at 64 characters.
The only circumvention is to rename labels after you import them from Excel or export them to Excel.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 | |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 | |
| Windows Vista | 9.1 TS1M3 | |
*
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: | Usage Note |
| Priority: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> MS Excel
|
| Date Modified: | 2009-10-21 13:03:19 |
| Date Created: | 2009-06-11 09:44:44 |
