When filtering on large numeric values that are 16 digits or more, SAS Enterprise Guide might change the values unexpectedly. Specifically, if you are building a basic filter in either the query builder or the Filter and Sort task, SAS Enterprise Guide changes these values to scientific notation. For example, t1.num = 6007850117101335 becomes t1.num = 6.00785011710134E+15.

As a result, the query does not return a result even though the actual value exists. This problem occurs only if you are creating a basic filter. An advanced filter works as expected. In addition, if the values are 15 or fewer digits, the filter is also correct.

The workaround is to create an advanced filter.