Problem Note 42616: Prompts used in a query filter for "In a List" or "Between" might not resolve correctly in SAS® Enterprise Guide®
Certain queries might generate incorrect results after project migration, or even when created as a new project. This problem can occur when the filter uses multiple prompts with the operator In a List or Between.
Also, when using date columns based on SAS data sets or DBMS data such as from Oracle, In filters might result in similar problems with the same workaround as noted below.
For example, the following code snippet can be generated using the Query Builder in SAS Enterprise Guide 4.1:
WHERE CLASS.Age IN
(
&max_age,
&min_age
);
|
However, after project migration to SAS Enterprise Guide 4.2 or 4.3, the code snippet is changed to the following and will most likely generate incorrect results:
WHERE %_eg_WhereParam( CLASS.Age, max_age, IN, TYPE=N, MAX=min_age );
|
To circumvent the problem, edit the filter and deselect Generate filter for a prompt value (only applies to prompt types), and then click Add to add the prompts to the filter for In a list.
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Windows Vista | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 |
| Windows Vista for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft® Windows® for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 |
*
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: | 2011-03-30 11:38:23 |
| Date Created: | 2011-03-07 12:15:12 |