topic Re: select the observation which has mobile in it in New SAS User

select the observation which has mobile in it

Smitha9 — Mon, 15 Aug 2022 21:29:16 GMT

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 — Mon, 15 Aug 2022 21:47:11 GMT

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 — Mon, 15 Aug 2022 21:52:49 GMT

where name contains 'mobile';

andreas_lds — Tue, 16 Aug 2022 05:14:21 GMT

@yaakov555 wrote:

where name contains 'mobile';

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

ballardw — Tue, 16 Aug 2022 14:11:56 GMT

@yaakov555 wrote:

where name contains 'mobile';

Did you try the code?:

Smitha9 — Tue, 16 Aug 2022 15:09:54 GMT

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