topic Re: How do I find whether email id contains first name? in SAS Programming

How do I find whether email id contains first name?

Shradha1 — Mon, 21 Dec 2020 12:02:29 GMT

I have a column on first names and another on email ids. How do I check if email id contains the first name? I am Working on sas 9.4. I have used the FIND function but it returns 0 for all observations

Re: How do I find whether email id contains first name?

PhilC — Mon, 21 Dec 2020 13:07:29 GMT

Have you changed the case of your strings? Using UPCASE() or LOWCASE() helps for this. One would apply one of these function to both strings before using FIND().

Re: How do I find whether email id contains first name?

Shradha1 — Mon, 21 Dec 2020 13:33:26 GMT

Yes. Both the strings are in upper case, still the find function is giving the value as 0 for all observations, which shouldn't be the case, because there are many email IDs with first name present in them

Re: How do I find whether email id contains first name?

andreas_lds — Mon, 21 Dec 2020 13:35:43 GMT

You need to use trim around the second parameter of find, like

containsFirstname = find(eMail, trim(firstname)) > 0;

Re: How do I find whether email id contains first name?

Shradha1 — Mon, 21 Dec 2020 14:07:05 GMT

This worked. Thanks a lot!!