Hi there,

I am new to STATA and I am currently struggling to find a solution for what I would say is a simple problem.

My dataset is composed by information about thousands of twitter users following some brands. I have around 20 brands. All users are divided in 2 categories of followers (A and B).

I would like to create a new variable with the number of followers in category A, for every brand.

For example, if 20 followers of Coca Cola are in category A, I would like that in every row of these users I see the variable with a value of 20.

Thank you!