Follow @ballardw's advice, join the two tables with a CONTAINS operation :
proc sql;
create table found as
select a.searchterm, b.comment
from searchtermdataset as a cross join surveydataset as b
where upcase(b.comment) contains upcase(a.searchterm);
quit;
If that doesn't work, please tell us why. Stay away from macro programming, it's inefficient and not required here.
... View more