SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 43948: A filter string that contains the IN operator might fail after migration from the SAS® Add-In 2.1 for Microsoft Office

DetailsHotfixAboutRate It

If you create a filter in the SAS Add-In 2.1 for Microsoft Office that uses the IN operator, and you typed the values into the field, the string of filter values might change after you migrate your spreadsheet to 4.2 or 4.3. This change to the filter means that no data is returned when you refresh. This problem only occurs when you manually type the values into the field and the values are character strings.

For example, say that you manually enter the following values using one of these two formats:

U.S.A., GERMANY
'U.S.A.', 'GERMANY'

In version 2.1, the filter string appears like following:

COUNTRY IN ('U.S.A.', 'GERMANY')

After you migrate your spreadsheet to, for example, 4.3, the filter is changed so that the entire string appears within quotation marks:

COUNTRY IN ('U.S.A., GERMANY')
COUNTRY IN ('''U.S.A.'',''GERMANY''')

When this change occurs, the filter can no longer find any matching values and no results are returned when you refresh.

To circumvent this issue, edit your filter and select the ellipse icon to remove the incorrect values, then select the correct values to rebuild the filter. The other option is to modify the values manually in the Advanced Filter Builder window.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Add-in for Microsoft OfficeWindows Vista for x644.25.19.2 TS2M29.3 TS1M0
Windows Vista4.25.19.2 TS2M29.3 TS1M0
Windows 7 Ultimate x644.25.19.2 TS2M29.3 TS1M0
Windows 7 Ultimate 32 bit4.25.19.2 TS2M29.3 TS1M0
Windows 7 Professional x644.25.19.2 TS2M29.3 TS1M0
Windows 7 Professional 32 bit4.25.19.2 TS2M29.3 TS1M0
Windows 7 Home Premium x644.25.19.2 TS2M29.3 TS1M0
Windows 7 Home Premium 32 bit4.25.19.2 TS2M29.3 TS1M0
Windows 7 Enterprise x644.25.19.2 TS2M29.3 TS1M0
Windows 7 Enterprise 32 bit4.25.19.2 TS2M29.3 TS1M0
Microsoft Windows XP Professional4.25.19.2 TS2M29.3 TS1M0
Microsoft Windows Server 2008 for x644.25.19.2 TS2M29.3 TS1M0
Microsoft Windows Server 20084.25.19.2 TS2M29.3 TS1M0
Microsoft Windows Server 2003 for x644.25.19.2 TS2M29.3 TS1M0
Microsoft Windows Server 2003 Standard Edition4.25.19.2 TS2M29.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition4.25.19.2 TS2M29.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition4.25.19.2 TS2M29.3 TS1M0
Microsoft® Windows® for x644.25.19.2 TS2M29.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.