09-09-2016 06:06 AM
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!
09-09-2016 06:11 AM
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.
09-09-2016 08:16 AM
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.