Hi all, I have data that looks like the table below that I would like to join onto another table. Criteria1 Criteria2 Criteria3 (OR) Result X Y 1, 2, 3, 4, 5 "Hello" The intended process is to check for the following: Criteria1 matches AND Criteria2 matches AND one of the Criteria3 entries match when delimited by comma. eg. X and Y and 1, Result = "Hello" X and Y and 2, Result = "Hello" etc. Is there a way to do this in SAS? I have an idea below but it's not the prettiest. Any help would be appreciated! Currently, I have imported the criterion table in and am planning to manipulate the data to, 1. Delimit Criteria3 column based off comma into separate columns. 2. Create column joining all criteria, delimited Criteria3 columns and expected result, eg. Created_col1, X/Y/1/"Hello"; Created_col2, X/Y/2/"Hello"; etc. 3. Transpose data 4. Separate result so end data is Criteria Result X/Y/1 "Hello" X/Y/2 "Hello" etc 5. Use put( formula to join Result on
... View more