Problem Note 18553: Import Data task might fail to read all Microsoft Excel rows using SAS® Enterprise Guide®
 |  |  |  |  |
Certain Microsoft Excel files might not import properly in SAS Enterprise Guide. In some cases rows of data can be missing, and in some cases the number of rows is increased. This can occur when the data contains LF and CR characters. In some cases the problem occurs because one or more columns have missing values for the first eight or more rows.
To circumvent the problem, apply the latest hotfix for the version of SAS Enterprise Guide you are using, then change the following registry setting:
Start ► Run ► Regedit ►
HKEY LOCAL MACHINE\Software\Microsoft\Jet\4.0\Engines\Excel
then change TypeGuessRows from 8 to 0 (zero).
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 Enterprise Guide | Microsoft Windows XP Professional | 4.1 | 9.1 TS1M3 SP1 | ||
| Microsoft Windows 2000 Professional | 4.1 | 9.1 TS1M3 SP1 | ||||
A fix for this issue for Enterprise Guide 4.1 is available at:
http://www.sas.com/techsup/download/hotfix/ent_guide41.html#018553| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2006-10-18 15:13:28 |
| Date Created: | 2006-09-19 13:36:27 |