Filter does not work. What is going wrong?

[MB1]

Hello everyone,

With the help of instructions (http://support.sas.com/kb/40/338.html) I made a query to get a list with only duplicate values of a column. I put a filter on another column to only select those values that are greater than 0.

When I run it, the filter does not work. I do get values of 0...

What could I be doing wrong?

Thanks in advance!

[Reeza]

If using AND/OR it may not be resolving the way you expect. 

More likely it's a numerical precision issue and the number is 0.0001 or something. Try rounding the number and then filtering. 

[ScottBass]

Post the code that EG generated.  

See also https://github.com/scottbass/SAS/blob/master/Macro/get_dups.sas, it may give you some ideas.