SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 38876: Differences between importing data in SAS® Enterprise Guide® 4.1 versus SAS Enterprise Guide 4.2

DetailsHotfixAboutRate It

To resolve some issues with the Import Data task in SAS Enterprise Guide 4.1, the workflow of the Import Data task was changed in SAS Enterprise Guide 4.2.

Specifically, in version 4.2, the Import Data task requires a local copy of the data, and the software copies the entire file to the local machine before importing. By contrast, in version 4.1, the Import Data task examines the entire source file, but, by default, only the first 25 records are used to determine field sizes and types.

As a consequence of this change in version 4.2, you must ensure that the local machine has sufficient storage available to download the file; otherwise, there might be problems using the Import Data task. You might also experience slower performance when importing a file from a server to a local machine over a WAN.

If the location used to store the temporary files on the client machine is too small to hold a file downloaded for the Import Task, a hot fix has been created to allow users to edit the SEGuide.exe.config file and change the location of where the files are stored.

Select the Hot Fix tab in this note to access the hot fix for this issue. After the hot fix has been applied, you can change the temporary directory path using the directions below:

Navigate to the directory in which SAS Enterprise Guide is installed. By default, this directory is C:\Program Files\SAS 9.2\EnterpriseGuide\4.2.

Note: Make a backup copy of SEGuide.exe.config before you begin editing it.

Edit the SEGuide.exe.config file. Remove the comment tags from the example Environment section by deleting the <!-- tag from the beginning of the section and the --> tag from the end of the section. The section should appear as follows:

<Environment>
	<Variables>
		<add name="EGTMP" value="c:\aatemp\egtemp" />
		<add name="TEMP" value="c:\aatemp\temp" />
		<add name="TMP" value="c:\aatemp\tmp" />
	</Variables>
</Environment>

To change the default temporary directory, edit the value for each variable that you want to change, and replace c:\aatemp\egtemp with the directory path that you want to use.

Save your changes to the SEGuide.exe.config file. You must close and restart SAS Enterprise Guide for the changes to take effect.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Enterprise GuideMicrosoft® Windows® for x644.24.39.2 TS2M09.2 TS2M3
Microsoft Windows Server 2003 Datacenter Edition4.24.39.2 TS2M09.2 TS2M3
Microsoft Windows Server 2003 Enterprise Edition4.24.39.2 TS2M09.2 TS2M3
Microsoft Windows Server 2003 Standard Edition4.24.39.2 TS2M09.2 TS2M3
Microsoft Windows XP Professional4.24.39.2 TS2M09.2 TS2M3
Windows Vista4.24.39.2 TS2M09.2 TS2M3
* 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.