topic Find a specific text in the randomly? in SAS Programming

Find a specific text in the randomly?

ybz12003 — Fri, 31 Jan 2020 20:22:42 GMT

Hi experts,

I have a challenge situation here. I would like to looking for a text with 'Health Center' in one of my variables. However, it comes with different formats and different places. I am curious, if there is a way to find them. Thanks!

For example,

1. Health Center

2. health center

3. Health center

4. Health State Center

5. State health center

6. Health Department Center

7. Department health center

Re: Find a specific text in the randomly?

novinosrin — Fri, 31 Jan 2020 20:39:42 GMT

Do you mean this?

data have;
input test $40.;
cards;
1. Health Center
2. health center
3. Health center
4. Health State Center
5. State health center
6. Health Department Center
7. Department health center
;

data want;
set have;
where findw(test,'health center',' ','i');
run;

Re: Find a specific text in the randomly?

ybz12003 — Fri, 31 Jan 2020 20:43:37 GMT

No, I would like to find all the seven answers even though there are one word in-between 'Health Center' or in front of it.

Re: Find a specific text in the randomly?

novinosrin — Fri, 31 Jan 2020 20:51:23 GMT

I would assume you wanna match text that basically should have both words.

How about

where findw(test,'health',' ','i') and findw(test,'center',' ','i');

/*or making sure health precedes center*/

where findw(test,'center',' ','i')>findw(test,'health',' ','i');

Re: Find a specific text in the randomly?

ybz12003 — Fri, 31 Jan 2020 21:35:18 GMT

Thanks, that's what I want!