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
graph box plot with 6 variables and two groupsHey STATA I have tried (now for a couple of hours) to make an graph hbox with different variables 1…
Help to recall Mata function inside postfile commandHi there, I am trying to run at least 10,000 replications of my code with a Mata function inside us…
Why dummy variable is not correct?Dear Stata users, I am trying to create two dummy variables respecting a few conditions, but for so…
Macros and loopsDear All, I have a couple of problems with macro and loops (they migh be correlated anyway): First…
Random slope and cross-level interactionDear All, I am testing the curvilinear relationship between cInfComp (level-1 variable) and NPD. I a…
Subscribe to:
Post Comments (Atom)
0 Response to Creating subsets from appended database
Post a Comment