Hi , I am working on a dataset where I am supposed to compare two variables to check if a phrase exists in one of the variables or not. I tried using index function and find function .Both the functions work if there a one-to-one match , I want SAS to tell even if there is that particular phrase in the variable .Ie , I want to check from my below example , variable A phrase is present in Variable b : Below is the example of what I want : a b INDEX Function Result Expected Result Left ICA Left ICA 1 Match Left Middle cere - M1 Left Middle cere - M1 1 Match Right Verte Right Verte,Right Verte, mid cervi 0 Match Right Middle cere - M1,Right Supra ICA Right Middle cere - M1 0 Match Midline Basilar trunk Midline Basilar trunk,Right Verte 0 Match Right Verte Left Verte 0 No Matching Data Left Middle cere - M1 Left Verte 0 No Matching Data Is there an other SAS function or method can I use? I hope I phrased my question correctly, Thanks In Advance !!!
... View more