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!
0 Response to Creating subsets from appended database
Post a Comment