Problem Note 18140: Queries might cause errors after migrating a SAS® Enterprise Guide®
project
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:
put(class.age,2.0) = '13'
However, after migrating the project to SAS Enterprise Guide 4.1, the
WHERE clause will be incorrectly parsed as follows:
WHERE CLASS.Age .Age,2.) = '13';
This results in syntax errors.
To circumvent the problem, follow these steps:
- 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.
- In SAS Enterprise Guide 4.1, open the query; then click the
Filter Data tab.
- Select and delete (X icon) the incorrectly parsed filter/s.
- Click the 'Add a New Filter' icon on the right.
- Then select 'New Advanced Filter'.
- 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,
WHERE put(class.age,2.0) = '13'
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: | 2006-10-11 07:24:07 |
| Date Created: | 2006-07-22 11:43:43 |
