topic Re: find variable in another variable in SAS Studio

find variable in another variable

leela214 — Mon, 05 Mar 2018 21:15:41 GMT

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!

Re: find variable in another variable

Astounding — Mon, 05 Mar 2018 21:35:47 GMT

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.

Re: find variable in another variable

leela214 — Tue, 06 Mar 2018 01:31:06 GMT

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!