37842 - A single or double quotation mark in data might cause the Import Data task to incorrectly import the data in SAS® Enterprise Guide®

Problem Note 37842: A single or double quotation mark in data might cause the Import Data task to incorrectly import the data in SAS® Enterprise Guide®

The Import Data task might incorrectly import a text data file if any variable value begins with a single or double quotation mark.

You can circumvent this problem in either of the three following ways:

Remove the quotation mark from the data before importing it with SAS Enterprise Guide.
Open the data using Excel, and then import the resulting Excel file using SAS Enterprise Guide.
If the data resides in a location known by the SAS server that is used by SAS Enterprise Guide, use the IMPORT procedure.

Click the Hot Fix tab in this note to access the hot fix to address the problem with single quotation marks.

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	SAS Enterprise Guide	Microsoft® Windows® for x64	4.2	4.22	9.2 TS2M0	9.2 TS2M0
		Microsoft Windows Server 2003 Enterprise Edition	4.2	4.22	9.2 TS2M0	9.2 TS2M0
		Microsoft Windows Server 2003 Standard Edition	4.2	4.22	9.2 TS2M0	9.2 TS2M0
		Microsoft Windows XP Professional	4.2	4.22	9.2 TS2M0	9.2 TS2M0
		Windows Vista	4.2	4.22	9.2 TS2M0	9.2 TS2M0
		Microsoft Windows Server 2003 Datacenter Edition	4.2	4.22	9.2 TS2M0	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.

A fix for this issue for SAS Enterprise Guide 4.22 is available at:

Type:	Problem Note
Priority:	high

Date Modified:	2009-11-30 14:53:15
Date Created:	2009-11-16 12:15:35