get matching name in a string of another clumn

[sathya66]

All,

I’m trying to see if a word existing in a string (name anywhere in namepart).  Tried a few options but I can only seem to get it to work when its an exact match (like the SAM record), 

see below

name	namepart
SAM	SAM
zil	zil_sss
olivia	yyyy
paul	PAUL_SS

[kelxxx · Accepted solution]

You can try 

data test;
input name $ namepart $;
cards;
SAM SAM
zil zil_sss
olivia yyyy
paul PAUL_SS
;
run;
data test2;
set test;
innamepart=count(namepart,name,'it');
run;