get matching name in a string of another clumn

sathya66 — Fri, 24 Dec 2021 09:55:05 GMT

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

Re: get matching name in a string of another clumn

kelxxx — Fri, 24 Dec 2021 10:04:10 GMT

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;

topic get matching name in a string of another clumn in SAS Programming

get matching name in a string of another clumn

Re: get matching name in a string of another clumn