CEOs transitions

[Marc Pascual]

Good morning,

I'm trying to create a variable to see if the transition of a company's CEO is Male to Female or another type of transition.
I have data on the Gender of the CEOs, their ID, the company's ID and the year, but I don't know how to classify per company and year who is their CEO to be able to determine what the transition (if any) is.

Thanks!

[William Lisowski]

Descriptions of data are well-meant but insufficient to help those who want to help you. Even the best descriptions of data are no substitute for an actual example of the data. There are many ways your data might be organized that are consistent with your description, and each would require a somewhat different approach. In order to get a helpful response, you need to show some example data.

Be sure to use the dataex command to do this. If you are running version 17, 16 or a fully updated version 15.1 or 14.2, dataex is already part of your official Stata installation. If not, run ssc install dataex to get it. Either way, run help dataex and read the simple instructions for using it. dataex will save you time; it is easier and quicker than typing out tables. It includes complete information about aspects of the data that are often critical to answering your question but cannot be seen from tabular displays or screenshots. It also makes it possible for those who want to help you to create a faithful representation of your example to try out their code, which in turn makes it more likely that their answer will actually work in your data.

When asking for help with code, always show example data. When showing example data, always use the dataex command.

Added in edit: this is a duplicate post (likely a problem with Statalist, since both posts have the same time) and similar advice was given earlier on the other post, to which followup should be posted.

https://www.statalist.org/forums/for...os-transitions