Problem Note 18706: Query might cause syntax errors after project migration in SAS®
Enterprise Guide®
After migrating a project from SAS Enterprise Guide 2.x or 3.x to 4.1,
queries might cause syntax errors. This particular problem will most
likely occur when the query contains computed columns that use
aggregation functions such as AVG, SUM, etc. The errors occur because
the function is not parsed correctly. This results in misplaced quotes
and consequently generates syntax errors.
To circumvent the problem, edit the computed column and remove the
invalid quotes from the expression.
Select the Hot Fix tab in this note to access the hot fix for this issue.
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: | high |
| Date Modified: | 2007-02-15 14:41:27 |
| Date Created: | 2006-10-04 13:34:32 |
