I am not sure whether I understand your question totally. data word;
input word1 : $20. word2 : $20.;
cards;
ns ma
ma xd
;
run;
data have;
input search_term $20.;
cards;
nssdsma
asdansasa
smadshxdwe
sduso
;
run;
proc sql;
create table want as
select distinct search_term
from have,word
where search_term contains strip(word1) and search_term contains strip(word2)
;
quit;
Ksharp
... View more
