Problem Note 20921: Mixed column type might convert character values to numeric when importing data into SAS® Enterprise Guide®
 |  |  |  |
The Import Data task might convert character values to missing numeric values when importing data into SAS Enterprise Guide. This can occur regardless of the setting for 'Maximum number of rows to scan as a preview when importing data' under Tools => Options => Data => Performance.
To circumvent the problem, in the Import Data task, change the Type field in Column Properties to Character.
Another circumvention is to make a change within the Microsoft Windows registry. From the registry, go to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text\ImportMixedTypes
Change
the value for ImportMixedTypes to 'Text'. This will set the column type to text
if there are any character values in the column. Note that this is a permanent
change and will apply to all text file importation until ImportMixedTypes is set
back to 'Majority Type'.
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 | 4.2 | 9.1 TS1M3 SP1 | 9.2 TS2M0 |
| Type: | Problem Note |
| Priority: | high |
| Topic: | Common Programming Tasks ==> Reading and Writing External Data |
| Date Modified: | 2007-11-19 12:14:38 |
| Date Created: | 2007-09-10 13:21:58 |