how to investigate whether the values of a variable in a group are the same

[Jessica Guo]

I have an unbalanced panel data about mutual funds.
The variables are listed below:
yrm: the date variable,
wficn: the mutual fund identifier
crsp_fundno: the mutual fund share class identifier, one fund can have multiple share classes, one wficn can correspond to several crsp_fundno at each month
mgr_name: the name of a mutual fund manager or names of mutual fund managers; a mutual fund can be managed by a single manager, or be team managed

Theoretically, the value of mgr_name should be the same for different share classes (identified by crsp_fundno) of the same fund (wficn).
I want to investigate whether my data conforms to this theory.
How can I accomplish this task in stata? Thanks.

[Carlo Lazzaro]

Jessica:
as per FAQ, sharing an excerpt/example of your data via -dataex- could help those listers interested in replying to your query.

[Joseph Coveney]

the value of mgr_name should be the same for different share classes (identified by crsp_fundno) of the same fund (wficn). I want to investigate whether my data conforms to this theory.

If it's true over time, or at least over the interval covered by your dataset, then you can do something like the following.

contract wficn mgr_name
isid wficn

[Nick Cox]

https://www.stata.com/support/faqs/d...ions-in-group/ may help.