topic Re: Filter does not exclude the data in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-does-not-exclude-the-data/m-p/761626#M39317 Most likely it's user error and you applied the filter incorrectly or it has a format applied and you're seeing the formatted values not the true values. Sun, 15 Aug 2021 00:16:41 GMT Reeza 2021-08-15T00:16:41Z Filter does not exclude the data https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-does-not-exclude-the-data/m-p/761558#M39312 <P>I have a dataset and I would like to filter it by setting a lower limit value of an interval variable. While I am pretty sure this variable has values lower than the threshold. But the filter function does not exclude any data....Any idea why could this happen?</P> Sat, 14 Aug 2021 07:01:03 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-does-not-exclude-the-data/m-p/761558#M39312 ycenycute 2021-08-14T07:01:03Z Re: Filter does not exclude the data https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-does-not-exclude-the-data/m-p/761562#M39314 <P>How do you filter (Filter and Sort, Query Builder or user written code)?</P> <P>Anyway, please post the code that was sent to the server.</P> Sat, 14 Aug 2021 08:26:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-does-not-exclude-the-data/m-p/761562#M39314 Kurt_Bremser 2021-08-14T08:26:15Z Re: Filter does not exclude the data https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-does-not-exclude-the-data/m-p/761626#M39317 Most likely it's user error and you applied the filter incorrectly or it has a format applied and you're seeing the formatted values not the true values. Sun, 15 Aug 2021 00:16:41 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-does-not-exclude-the-data/m-p/761626#M39317 Reeza 2021-08-15T00:16:41Z Re: Filter does not exclude the data https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-does-not-exclude-the-data/m-p/761679#M39318 <P>I figured it out that I need to specify user-specified in the variable window even though I have changed the default method to user-specified....</P> Sun, 15 Aug 2021 13:43:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-does-not-exclude-the-data/m-p/761679#M39318 ycenycute 2021-08-15T13:43:44Z