Problem Note 18739: Certain column names cause query syntax errors in SAS Enterprise Guide
Certain column names cause query syntax errors in SAS Enterprise Guide.
The problem will most likely occur when two or more column names are
very similar. For example, column names 'my var'n and 'my var name'n
will cause a message similar to the following when the columns are added
to the query or filter:
Error: Column '''my var''n name'n could not be found in the
table/view identified with the correlation name table_name.
To circumvent the problem, use column names that are more unique.
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: | medium |
Date Modified: | 2006-10-17 16:31:03 |
Date Created: | 2006-10-10 11:46:59 |