Importing a text file in SAS Enterprise Guide might result in an
incomplete SAS table. This can occur if the data contains garbage
characters. In some cases, even HEX characters, such as '00'x might
cause a similar problem of missing rows of data. In other cases, an EOF
marker might have been entered by mistake in one or more of the column
values.

To attempt to work around the problem, open the text file in Microsoft
Notepad and then try one of these methods:

1. If garbage characters appear at the end of the rows of data,
   unselect Word Wrap, and then save the text file to a new text
   file (.txt). Now use SAS Enterprise Guide to import the new .txt
   file. You will likely need to choose the Columns tab in the
   Import Data task and make sure to choose the last 'bad' column
   and select the option for it to not be included in the table
   results.

2. Select File => Save the data. Then import into SAS Enterprise Guide.

3. If one of the two methods above does not work around the issue, and
   the data is less than 65,000 rows, use Microsoft Excel to import
   the text file, convert it to a .xls file, and then use SAS Enterprise
   Guide to import the new .xls file.

In some cases, the only work around is to use a text editor to try and
find the offending characters, for example, '00'x or '01'x, and remove
or replace them before importing the data.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for Enterprise Guide 4.1 is available at: