Help with index function

knveraraju91 — Fri, 07 Aug 2020 06:48:36 GMT

Dear,

Please suggest in my code. I need to output only records containing word "Platelet'. I am getting both records. Thank you

output needed;

tran Platelet

data one;
input val $1-21;
datalines;
tran Plateletpheresis
tran Platelet
;

data two;
set one;
if index(val,'Platelet') >0;
run;

Re: Help with index function

andreas_lds — Fri, 07 Aug 2020 07:06:59 GMT

If you want to search for words, use the function findw or a regular expression.

data two;
set one;
if findw(val,'Platelet') >0;
run;