I have a list of keywords (175) in column A that I would like to search through column B (paragraph form sentences.) I've tried several different ways and keep getting errors. data want; set have; column_B_lc = lowcase(column_B); do i = 1 to countw(column_A); word = scan(column_A, i); if indexc(column_B_lc, ' ' || word || ' ') > 0 then do; output; leave; end; end; drop i word column_B_lc; /* Drop temporary variables used in the loop */ run; any tips/suggestions are welcome!
... View more