topic Re: Selecting a keyword from a column in SAS Programming

Selecting a keyword from a column

amanjot_42 — Wed, 29 Dec 2021 03:27:28 GMT

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

Re: Selecting a keyword from a column

whymath — Wed, 29 Dec 2021 03:35:38 GMT

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;

Re: Selecting a keyword from a column

andreas_lds — Wed, 29 Dec 2021 06:41:33 GMT

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

Re: Selecting a keyword from a column

amanjot_42 — Thu, 30 Dec 2021 19:38:44 GMT

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

Re: Selecting a keyword from a column

amanjot_42 — Thu, 30 Dec 2021 19:39:46 GMT

Thank you fr your response!

No, I had only two words.

Regards,

Amanjot