Executing a query might generate syntax errors after migrating a project created with SAS Enterprise Guide 3.x to SAS Enterprise Guide 4.1.0.471. The problem will most likely occur when there is a function in the value of the Column field in the Edit Filter Condition window of the Query Builder.

For example, a Column value similar to the following works in SAS Enterprise Guide 3.x:

However, after migrating the project to SAS Enterprise Guide 4.1, the WHERE clause will be incorrectly parsed as follows:

This results in syntax errors.

To circumvent the problem, follow these steps:

1. If you still have SAS Enterprise Guide 3 installed, open the project in SAS Enterprise Guide 3 and make note of the correct syntax of the affected filters.
2. In SAS Enterprise Guide 4.1, open the query; then click the Filter Data tab.
3. Select and delete (X icon) the incorrectly parsed filter/s.
4. Click the 'Add a New Filter' icon on the right.
5. Then select 'New Advanced Filter'.
6. Enter the correct syntax; for example,
   put(class.age,2.0) = '13'

SAS Enterprise Guide 4.1 will then generate the correct WHERE clause. For example,

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for Enterprise Guide 4.1 is available at: