Problem Note 40447: Query with computed columns might generate syntax errors after project migration to SAS® Enterprise Guide® 4.2
 |  |  |  |  |
A project that contains a query that has a computed column that is used in a filter might cause a syntax error when you run the query after project migration. This problem will most likely occur if the default name for computed columns (Calculated1) is used in the query filter.
To circumvent the problem, before migrating to SAS Enterprise Guide 4.2, rename the computed column to something other than the default name, and then use the column in the query filter.
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® for x64 | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista for x64 | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
A fix for this issue for SAS Enterprise Guide 4.22 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A53.html#40447A fix for this issue for SAS Enterprise Guide 4.305 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C44.html#40447A fix for this issue for SAS Enterprise Guide 4.3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D18.html#40447| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2010-08-05 11:25:26 |
| Date Created: | 2010-07-26 13:03:27 |