I am interested in creating subsets from the appended dataset using uniquely identified ID. An example of dataset is below
clear
input
long ID str100 org_name int year
1234456 "Helping Hand" 1
1200081 "Caring Foundation" 1
1200081 "Caring Foundation" 2
9089081 "Save Children" 1
9089081 "Save Children" 2
9089081 "Save Children" 3
4532901 "Planet Earth" 2
end
I am interested in creating a subset of organizations that participated in more than 1 year. For example, ID 1200081 "Caring Foundation" participated in two years. So, I want to create a subset of these types of organizations and save it as a new dataset. Similarly, 9089081 "Save Children" participated in three years, hence save as another dataset. I am not interested in organizations that just participated in a particular year example 1234456 "Helping Hand" or 4532901 "Planet Earth" since they only participated in one year and hence not recurring.
Thanks for help!
Related Posts with Creating subsets from appended database
intra class correlationHello to everybody, I'll try to do for the first time the calculation of intra class correlation bet…
converting annual to quarty in Statahello , I have yearly(from 1996 to 2020) dataset of uncertainty trade, I want to change them to quar…
Instrumental VariableHey everyone, I have the following equation: y=aX1+bX2+cX3+dX4+e I am instrumenting Z1 for X1 and…
checking linearity with lack of fit testHello, I'm running a linearity check (analitical data), and I'd like to run lack of fit test after l…
Function of the variable(s) in i() of a -reshape- especially when groupedI'm trying to understand how to interpret the i(varlist) in reshape when it is a grouped variable cr…
Subscribe to:
Post Comments (Atom)
0 Response to Creating subsets from appended database
Post a Comment