Dear colleagues,
I am trying to group observations based on their (possibly indirect) connections . For example, imagine workers may have worked at different branches and the following is their working history (not time sensitive).
Code:
clear
input personid branchid
1 1
2 1
1 2
3 2
3 3
4 3
5 4
6 4
end
The goal is to generate a new variable (group) that yields the following.
personid branchid group
1 1 1
2 1 1
1 2 1
3 2 1
3 3 1
4 3 1
5 4 2
6 4 2
The logic is that personal 1 is directly connected to person 2 (they both worked at branch office 1) and also to person 3 (they both worked at branch office 2), and indirectly connected to person 4 (because 3 and 4 both worked at branch office 3), hence persons 1-4 shall all belong to the same group. Similarly for person 5 and 6 as another group. Any comments on how to code and generate the group would be greatly appreciated!
Thanks.
Hua
Related Posts with Group observations with indirect tie.
How to show persistence using panel dataDear stata users and experts, My data is firm year panel data, i.e., I have observations at firm le…
Non-convergence in IV PoissonDear Statalisters, I am using the IV Poisson model: Code: ivpoisson gmm dependent variable covari…
range of quartilesDear colleagues, I have created 4 quartiles of a variable (age) that goes form 18 to 89. What is the…
vce2way works in Stata 15.1 but not in 16Dear All, I find that (ssc install) -vce2way- command works in Stata 15.1 but not in Stata 16 in the…
Label VariablesHello, I have a stata file named "survey.dta" which contains the following labelled data: ident…
Subscribe to:
Post Comments (Atom)
0 Response to Group observations with indirect tie.
Post a Comment