Filtering fails when a value contains a comma that uses the "In a list of values" filter in a SAS® Studio 5.2 query task


Inconsistent behavior occurs in SAS Studio 5.2 when filtering data sets that include string values with commas.

When using the "In a list of values" filter in queries, string values that contain commas (,) are incorrectly interpreted as multiple separate values instead of a single string. As a result, the filter fails to match the intended rows, as shown in the following images:

    String values containing commas (,)

Values are interpreted as multiple separate values instead of a single string.