select the observation which has mobile in it

[Smitha9]

Hi, I have a dataset which is

ID       Name

1        fact mobile

2        stay  focus mobile

3        facial

4        free flow in the rest mobile

5       secured locate

6       focus in the center right angle mobile

I want to select all the ID's which has "mobile" word in the Name variable.

1     fact mobile

2     stay focus mobile

3     free flow in the rest mobile

4     focus in the center right angle mobile

thank you in advance.

[ballardw · Accepted solution]

data want;
   set have;
   where find(name,'mobile','i')>0;
run;

If it must exactly match the word and not allow "mobile" as part of a compound word then use FINDW.

[yaakov555]

where name contains 'mobile';

[andreas_lds]

---

@yaakov555 wrote:

where name contains 'mobile';

---

This won't match, if name is "Super Mobile Provider".

[ballardw]

---

@yaakov555 wrote:

where name contains 'mobile';

---

Did you try the code?:

[Smitha9]

yes it worked. thanks and I accepted as the solution.