Problem Note 57804: In SAS® Enterprise Guide®, modifying the Edit Data and Filter window for any task might cause a syntax error
 |  |  |  |
Making any change in the Edit Data and Filter window, or simply re-accessing the Edit Data and Filter window for any task might result in a syntax error similar to the following:
42 FROM WORK.TEST as T
43 WHERE x > 07/31/2015 10:10:10
__
22
76
ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=,
AND, EQ, EQT, EXCEPT, GE, GET, GROUP, GT, GTT, HAVING, INTERSECT, LE, LET, LT, LTT, NE, NET,
NOT, OR, ORDER, OUTER, UNION, USING, ^, ^=, |,
||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
Typically, this problem occurs when the filter is on a date, time, or datetime value.
The only way to fix the problem is to delete the task and add the task again with the new filter in the Edit Data and Filter window.
To avoid the issue, use the Query Builder to filter the data instead of the task's Edit Data and Filter window.
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.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 |
| Microsoft Windows 8 Enterprise x64 | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro 32-bit | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 10 | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Datacenter | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 7.11 | 7.13 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-03-14 11:04:18 |
| Date Created: | 2016-03-07 10:16:52 |