find variable in another variable

[leela214]

I would like to find siteid in the site_affected. If it's in the list then I can do something afterward. However, I was not able to use the find, index function to achieve this.

I have tried

if index(site_affected, siteid) gt 0 then do;

date = 01/JAN/1990;

date2 = 02/JAN/2990;

end;

siteid               site_affected

1071                1059; 1061; 1100; 1105; 1190; 1003; 1017; 1022; 1063; 1071; 1144

date and dates are empty from the code.

Will appreciate any input!

[Astounding · Accepted solution]

Assuming that both variables are character, you should be able to make a small change:

if index(site_affected, strip(siteid)) gt 0 then do;

That will remove extra blanks that might be part of SITEID, making the longer-version-with-blanks appear is though it as not part of SITE_AFFECTED.

There are other possibilities using FINDW, but based on what you posted it looks like this simpler version should be fine.

[leela214]

Thank you so much! It work. I tried using the option, 't' -trim in other function too, but didn't work too. I'm glad you were able to solve my question!