How to filter dataset values by values in another table

[kz_]

What I want to do is filter one table by the values in another. Something like: 

data want; 

     set have; 

     where variable_i >= othertable[variable_i, column_name];

run; 

Variable_i exists in both tables and has 10 different values. The problem is that the filter value should be different for each of those values, and I don't want to hard code anything. 

Maybe it's because I'm too used to R, where this would be so easy. 

[Reeza · Accepted solution]

Merge the two tables and then look up the value.
Load the second table into a temporary array and look up the values in the array.
Use SQL which is also a merge.

If you want specific examples you'll need to provide example data.

[kz_]

Thank you. I was hoping there was a less annoying way, like creating a macrovariable vector. 

[Reeza]

Can't say without specifics