Selecting a keyword from a column

[amanjot_42]

Hello everyone!

I have this dataset with me:

Executive_Name   Executive_Role                                                 New_Variable

Arnold                    president & CEO                                                           0

Tracy                     executive vp & chief operating officer                            0

Victor                     vp & chief finance officer                                               1 

Hunter                   vp, general counsel & secretary                                    0

Joseph                  Chief Financial Officer and Senior Vice President        1

I am trying to come up with a new_variable taking the value 1 if the column relating to the executive roles contains the words either 'finance' or 'financial', and 0 otherwise. Can you please help in this regard?

Regards,

Aman

[whymath · Accepted solution]

data have;
  input Executive_Name$ Executive_Role&$128. ;
  cards;
Arnold president & CEO
Tracy  executive vp & chief operating officer
Victor  vp & chief finance officer
Hunter  vp, general counsel & secretary
Joseph  Chief Financial Officer and Senior Vice President
;
run;

data want;
  set have;
  if find(Executive_Role,'finance','i') or find(Executive_Role,'financial','i') then new_variable=1;
  else new_variable=0;
run;

[amanjot_42]

Thank you very much!
It worked really well!
Regards,
Aman

[andreas_lds]

Do you have just the two words, or are there maybe more for other flags?

[amanjot_42]

Thank you fr your response!

No, I had only two words.

Regards,

Amanjot