Desktop productivity for business analysts and programmers

Filter does not work. What is going wrong?

Reply
New Contributor MB1
New Contributor
Posts: 4

Filter does not work. What is going wrong?

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!

Grand Advisor
Posts: 17,297

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

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. 

Super Contributor
Posts: 374

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

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.

Ask a Question
Discussion stats
  • 2 replies
  • 268 views
  • 0 likes
  • 3 in conversation