The SAS® Studio Data Viewer returns incorrect results when you filter SingleStore tables


In SAS® Studio 2025.06 and later, filtering SingleStore tables in the SAS Studio Data Viewer with the Contains condition might result in an incorrect number of rows:

Filtering SingleStore tables in the SAS Studio Data Viewer with the Contains condition might result in an incorrect number of rows.

Workaround

To circumvent this issue, apply the Is equal to condition.

The "Is equal to" condition

 

Alternatively, you can use either of the following: