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
Exporting results of Ttests with Unequal variancesI have a bunch of variables and I want to conduct a 2-group mean comparison test with unequal varian…
byable problemI have a program pf that folks at Stata help me write to compute variations on probit and I just tri…
ONE QUESTION about GSEMDear stata users in GSEM , Is it logically correct to have such a model in general? Array …
Converting Weekly Data to Monthly DataI have weekly data that is issued say every Friday (different data sets have different issuance date…
changing string to floatHi all, greetings! I have a variable named "pcgdp" stored as string. Observations are numeric values…
Subscribe to:
Post Comments (Atom)
0 Response to Creating subsets from appended database
Post a Comment