Hi Everyone I'm quite new to SAS - I've been a SQL user most of my life and only trying SAS out now. Excuse my ignorance on some of the questions. I have 1 table (Table1)in SAS that has 1 distinct variable with around 1000 observations (each observation is a single word) and I have another table (Table2) that has a 1 string variable which is not distinct (with around 10 million observations). I would like to take EACH of the 1000 obs in Table1 and recursively search for them in strings in Table2 then save them in Table3 when its a match. example: Table1 These Are the Words and strings that might appear in table1 Table2 this variable may contain distinct strings but may also have words that are duplicated a number of times in Table1 so regardless of that I need to use all the help I might get from you to help me find the words Please help in any way that you can help me with these I thank you for any help you might give to find var from table1 So in the above Table1 - i want to pick up each word then search for it in table2. Where it is found, I'd like to have output like this: Table3 Table1Var Table2String These can help me with these Are are The to use all the help The to help me find the words but may also have words words words and . strings this variable may contain distinct strings That that That of that I need Might I might get from you Might I thank you for any help you might Appear . in duplicated a number of times in in Please help in Table1 Table1 so regardless Table1 give to find var from table1 I hope the above makes sense. Thank you.
... View more
