WHERE clause syntax in a query task might be altered during project migration possibly causing incorrect results in SAS Enterprise Guide. This will most likely occur when migrating to SAS Enterprise Guide 4.1 and for relatively complex WHERE clause syntax.

For example, suppose a query contained a WHERE clause similar to this one using the table SASHELP.CLASS in SAS Enterprise Guide 3.x:

If the project was migrated to SAS Enterprise Guide 4.1.x, the WHERE clause might be altered to this:

The above clause returns completely different results.

The only circumvention is to manually modify the resulting WHERE clause using steps similar to these:

1. Open the combine filters dialog.
2. In the second row, ctrl-select the first filter [CLASS.Name IN ("Alfred", "Alice")] in the first row and the last grouping icon in the row. This should be the grouping icon represented by ( ).
3. Click the Group button to group the two selected items.
4. In the newly formed third row, change the OR to AND, press OK and run the query.

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: