Hello stata masters, I have a data set on a board of directors with individual board members, I have added the ROA of the firms of these board members as a variable. And made a variable of gender diversity by calculating the amount of females divided by the board size. However now the gender diversity of the firm is mentioned per every director, how can i make it that i can only have the gender diversity per firm in a new data set or do research with only one observation per firm. Thank you in advance and sorry if the question is actually really easy but I could not find it anywhere.