How can I extract the specific "word" all the time? Indexw is only retrieving sometimes
data original_data;
infile datalines delimiter=',';
input txt $40. ;
datalines;
166,181,410,333
166,358
166,181,105
358
166,181,250,105
181,
105,166
;
run;
data new_data;
set original_data;
indexw_166 = indexw(txt, '166');
indexw_181 = indexw(txt, '181');
indexw_358 = indexw(txt, '358');
run;
proc print data=new_data;run;
... View more
