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
| 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 |
A fix for this issue for Enterprise Guide 4.1 is available at:
http://www.sas.com/techsup/download/hotfix/ent_guide41.html#018706| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2007-02-15 14:41:27 |
| Date Created: | 2006-10-04 13:34:32 |