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
Help needed: Extracting data from different rowsHi all, I need some help in extracting data from a column. I am trying to find a way to do so witho…
Proportions variableI am working with panel data and am trying to create a new proportional variable defined as the numb…
OLS Regression with lagsHey! I am writing my bachelor thesis, studying the relationship between monetary policy and housing…
Mediation suregDear all, I am running the follwing STATA code from the example from this website: https://stats.id…
Epidemiology analysisplease helm me with this case I dont know the syntax the data is on the attachment Estimate regress…
Subscribe to:
Post Comments (Atom)
0 Response to Creating subsets from appended database
Post a Comment