Problem Note 31045: "Filter syntax is invalid" error when creating a compound filter using the IN and AND operators on file-based data
 |  |  |  |
If you open a file-based table in the SAS® Add-In for Microsoft Office and attempt to apply a compound filter using both the IN and AND operators, you might receive the following error message:
Filter syntax is invalid
When we filter data that is opened via the file system, we use the Local Data Provider to open this data. The Local Data Provider is unable to handle the filter that is generated by the SAS Add-in for Microsoft Office and returns this error.
For example, if you enter the following filter in the filter expression window, you would receive the error:
Age IN (12,13,14) AND Height = 56.3
However, the problem might be circumvented by typing out the full expression in Advanced Edit window. To do that, clear out any filter specified in the Filter description window, and select the Advanced Edit button. In the expression window, type in the full filter without using the IN operator as follows:
(Age=12 AND Height=56.3) OR (Age=13 AND Height=56.3) OR (Age=14 AND Height=56.3)
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 2.1 | 4.2 | 9.2 TS2M0 | |
| Microsoft Windows 95/98 | 2.1 | |||||
| Microsoft Windows 2000 Advanced Server | 2.1 | |||||
| Microsoft Windows 2000 Datacenter Server | 2.1 | |||||
| Microsoft Windows 2000 Server | 2.1 | |||||
| Microsoft Windows 2000 Professional | 2.1 | |||||
| Microsoft Windows NT Workstation | 2.1 | |||||
| Microsoft Windows Server 2003 Datacenter Edition | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Microsoft Windows XP Professional | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Windows Millennium Edition (Me) | 2.1 | |||||
| Windows Vista | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2010-11-16 09:56:35 |
| Date Created: | 2008-01-28 13:34:27 |