Problem Note 37612: The SAS® System can only import and export 255 variables when you access a Microsoft Excel 2007 file
SAS can only import and export 255 variables when you access an Excel 2007 file.
The problem occurs because the Microsoft Access Connectivity Engine that SAS uses to read these files can only use 255 variables at a time.
To circumvent this problem when you import a file, you can save the Excel file as a text file and import it into SAS.
When you export, split the variables across multiple sheets in the same workbook with the Variable255 program, which is available from the Full Code tab in SAS Sample 36904, "Exporting more than 255 variables from the SAS® System to a Microsoft Excel workbook".
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | |
| Microsoft Windows XP Professional | 9.2 TS2M0 | |
| Windows Vista | 9.2 TS2M0 | |
*
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.
SAS can only import the first 255 variables with the IMPORT procedure and can export only 255 variables with the EXPORT procedure when you access Excel 2007 files. This problem occurs because of limits with the Microsoft Access Connectivity Engine (ACE).
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> MS Excel
|
| Date Modified: | 2009-10-29 11:56:09 |
| Date Created: | 2009-10-27 11:16:44 |
