topic How to filter dataset values by values in another table in SAS Programming

How to filter dataset values by values in another table

kz_ — Mon, 13 Sep 2021 20:42:37 GMT

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.

Re: How to filter dataset values by values in another table

Reeza — Mon, 13 Sep 2021 21:06:45 GMT

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.

Re: How to filter dataset values by values in another table

kz_ — Fri, 17 Sep 2021 19:31:46 GMT

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

Re: How to filter dataset values by values in another table

Reeza — Fri, 17 Sep 2021 19:41:10 GMT

Can't say without specifics