How to filter data using keywords

[Wali Ullah]

Hi everyone,

I am a novice user of STATA. I have collected execucomp data on excel, where manager data is available according to their titles and company name. Out of all the managers listed, I only want to work with the CEOs, so only the datapoints with the the titles "CEO" or "executive" or "Chief Executive Officer" would suffice for me. Can anyone help me out with the appropriate codes to filter out data with keywords?

Thanks a lot!

Wali

[Clyde Schechter]

keep if strpos(title, "CEO") | strpos(title, "executive") | strpos(title, "Chief Executive Officer")

[Justin Niakamal]

Clyde Schechter is there an advantage of using

keep if strpos(title, "CEO")

to

keep if regexm(title, "CEO")

or is it a matter of preference?

[Clyde Schechter]

I think it's a matter of preference. My preference for -strpos()- arises just because I find regular expressions pretty complicated to write, so I tend to avoid them when there is a reasonable alternative.

Also, if this command is being applied to a very large data set and is also deep inside a loop with a very large number of iterations, I imagine that -strpos()- executes faster than -regexm()-, and the difference could be noticeable.

[Wali Ullah]

Thanks! They were very helpful!