Problem Note 18313: Missing data might occur when importing Microsoft Excel files into SAS®
Enterprise Guide®
Rows or columns of data might be missing after importing Microsoft Excel
data into SAS Enterprise Guide. To attempt to circumvent the problem,
use the following steps to change a registry setting:
- Select Start ► Run. Enter the command Regedit and click OK.
- Expand HKEY_LOCAL_MACHINE.
- Expand to Software\Microsoft\Jet\4.0\Engines.
- Select Excel.
- Right-click on TypeGuessRows and choose Modify.
- Change the value to 0 (Zero).
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft Windows XP Professional | 4.1 | 4.2 | 9.1 TS1M3 SP1 | 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.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2006-10-11 07:31:04 |
| Date Created: | 2006-08-21 15:07:40 |
