Hi All, I have two sasdatasets , one has column ID which has 8 digit number. The second dataset has a text field in which it has ID from the first dataset any where placed in the text field. I need a column in the second dataset which says "exists" if the ID exists in the first dataset. Example : First Dataset : 12345678 Second data set text Value: **Request #12345678-Corporate Membership In the text field the ID value can be anywhere in the text. Basically for every ID in the first dataset it has to loop through all records in the second dataset and put a flag exists in that row where it matches in the second dataset. Thanks In Advance, Vani.
... View more