Hi everyone, I have two tables. Table 1 looks like this : cat dog lion hamster bear guinea pig And table 2 looks like this : my dog is stupid that cat likes my dog fat hamster bear are dangerous lions are dangerous lions eat antelopes I like cats and lions giraffes are cute What I'd like as a result is to have a count of table 1 words occurences in table 2. To make myself clear, something like this : words of table 1 occurrences in table 2 cat 2 dog 2 lion 3 hamster 1 bear 1 guinea pig 0 You will notice that plural forms of words, like "lions" for instance, are counted. In fact, we're looking for the chain of character "lion" in table 2, not the exact word. I've been trying to split the strings in table 2 into words with the scan function, and running some proc freq and merges, but I'm not going anywhere. Don't hesitate to ask any question. English is not my mother language so maybe I'm not being very clear.
... View more