Problem Note 47088: Filtering on a summarized character variable in the SAS® Enterprise Guide® Query Builder might result in a syntax error
If a numeric function, such as COUNT or COUNT DISTINCT, is used to summarize a character variable in the SAS Enterprise Guide Query Builder, and that variable is then used in a filter, the query could result in the following syntax error:
ERROR: Expression using equals (=) has components that are of different data types.
This error occurs because the Enclose values in quotes option is selected by default when the filter is being built. To resolve the problem, deselect this option.
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2008 for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows XP Professional | 4.2 | | 9.2 TS2M0 | |
| Windows Vista | 4.2 | | 9.2 TS2M0 | |
| Windows Vista for x64 | 4.2 | | 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: | low |
| Date Modified: | 2012-07-30 16:17:23 |
| Date Created: | 2012-07-27 16:17:16 |
