OR Filter between two Categories

dekeyrelc · Posted 04-28-2022 12:38 PM

I have data where a row can document a "Item Added" or and "Item Removed" or both an "Item Added" and "Item Removed". I would like to have a control that return all rows where the "Item" is in Either the "Item Added" or "Item Removed" field. Is it possible to add logic to a control? Or create a new category that will return both "Items" when one is both added and another removed?

mkeintz · Posted 04-28-2022 01:11 PM

@dekeyrelc wrote:

...

I would like to have a control that return all rows where the "Item" is in Either the "Item Added" or "Item Removed" field. Is it possible to add logic to a control?

Answer: Yes.

But you would need to show a sample of your data, in the form of a working data step, to receive a more helpful response.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

OR Filter between two Categories

Re: OR Filter between two Categories

SAS Innovate 2025: Call for Content