Problem Note 58698: The Query Builder in SAS® Enterprise Guide® might return incorrect output
 |  |  |  |  |
If the Query Builder uses the In a list operator but the Match case option is not enabled, SAS Enterprise Guide might return incorrect output.
To correct this issue, manually edit the SAS code generated by the Query Builder to add a set of parentheses around the filter code and execute the PROC SQL step.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 |
| Microsoft Windows 8 Enterprise 32-bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Enterprise x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Pro 32-bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Pro x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Enterprise x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Pro 32-bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Pro x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 10 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 R2 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 for x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 Datacenter | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Std | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 Std | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Enterprise 32 bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Enterprise x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Home Premium 32 bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Home Premium x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Professional 32 bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Professional x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Ultimate 32 bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Ultimate x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M3 | ||
A fix for this issue for SAS Enterprise Guide 7.12 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y39.html#58698| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-08-29 10:07:37 |
| Date Created: | 2016-07-29 10:41:20 |