How do I find whether email id contains first name?

[Shradha1]

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

[PhilC]

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().

[Shradha1]

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

[andreas_lds · Accepted solution]

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

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

[Shradha1]

This worked. Thanks a lot!!