Usage Note 33257: A warning might be returned when you read a Microsoft Excel worksheet with a DATA step or with the IMPORT procedure
The following warning might be returned when you read an Excel worksheet by submitting a LIBNAME statement that uses the Excel engine along with a DATA step or the IMPORT procedure:
WARNING: Failed to scan text length or time type for column <Column_name>.
The data set is created successfully. However, a character-length field might not have the appropriate length.
To prevent the warning and to read in the data properly, edit the Windows Registry key TypeGuessRows and change the default value for the number of rows that should be evaluated to determine the data type and character value length from the default setting to 0 (zero).
If you are running SAS 9.1.3 or SAS® 9.2 (TS1M0), you must edit the Windows Registry key TypeGuessRows as follows:
- Select Start ► Run.
- In the Run dialog box, type regedit and click OK.
- In the Registry Editor, select HKEY_LOCAL_MACHINE ► SOFTWARE ► Microsoft ► Jet ► 4.0 ► Engines ► Excel.
- In the right pane, double-click TypeGuessRows.
- In the Edit DWORD Value dialog box that appears, select the Decimal radio button under the Base category.
- Enter 0 in the Value data field.
- Click OK and exit the Registry Editor.
Note: The range of valid values for the TypeGuessRows key is 0–16. However, if the value is 0, the number of rows that will be scanned is 16384. If this file is large, this might cause a minor slowdown in performance.
If you are running SAS® 9.2 (TS2M0) or later, you must edit the Windows Registry key TypeGuessRows as follows:
- Select Start ► Run.
- In the Run dialog box, type regedit and click OK.
- In the Registry Editor, select HKEY_LOCAL_MACHINE ► SOFTWARE ► Microsoft ► Office ► 12.0 ► Access Connectivity Engine ► Engines.
- Double-click the Excel node.
- In the right pane, double-click TypeGuessRows.
- In the Edit DWORD Value dialog box that appears, select the Decimal radio button under the Base category.
- Enter 0 in the Value data field.
- Click OK and exit the Registry Editor.
Note: The range of valid values for the TypeGuessRows key is 0–16. However, if the value is 0, the number of rows that will be scanned is 16384. If this file is large, this might cause a minor slowdown in performance.
Warning: Always back up the Windows Registry before you make any registry changes. For assistance, see Windows Help, Microsoft documentation, or the Microsoft Windows Web site. SAS is not responsible when you edit the Windows Registry. Changes in the Windows Registry can render your system unusable and require that you reinstall the operating system.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | |
Microsoft® Windows® for x64 | 9.2 TS1M0 | |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | |
Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | |
Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | |
Microsoft Windows XP Professional | 9.2 TS1M0 | |
Windows Vista | 9.2 TS1M0 | |
Windows Vista for x64 | 9.2 TS1M0 | |
*
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.
Date Modified: | 2008-09-18 10:14:45 |
Date Created: | 2008-09-11 10:29:28 |