topic Re: Filter does not work. What is going wrong? in SAS Enterprise Guide

Filter does not work. What is going wrong?

MB1 — Fri, 09 Sep 2016 10:06:07 GMT

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!

Re: Filter does not work. What is going wrong?

Reeza — Fri, 09 Sep 2016 10:11:14 GMT

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.

Re: Filter does not work. What is going wrong?

ScottBass — Fri, 09 Sep 2016 12:16:56 GMT

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.