str50 year str27 state str29 district long regno str110 donortype str109 double amount
"2009-2010" "New york" "A & N Island" 240020003 "Institutional donors" 1738584
"2009-2010" "New york" "A & N Island" 240020003 "Institutional donors" 206663
"2010-2011" New york "A & N Island" 240020003 "Institutional donors" 293930
"2010-2011" "New york" "A & N Island" 240020003 "Institutional donors" 1692164
"2019-2020" "New york" "A & N Island" 240020003 "Institutional donors" 38579
"2019-2020" "New york" "A & N Island" 240020003 "Institutional donors" 988067
I am interested in adding "amount" together for the same "regno" (unique value) for each year. I am hoping to generate new dataset which has summed amount for each regno for each year.
Thanks so much in advance!
Related Posts with Summing dollar amount for each unique id for each year
Manually calculating IV standard errors and getting STATA to use them in the regression tableI found the following script from one of the other threads to be helpful in calculating IV standard …
How to shorten multiple line of codes relevant?In my data, I have a numeric number called year which have value from 2 to 22, I want to replace thi…
Two-Step System GMM with xtabond2 commandDear Stata Experts, I am dealing with a dynamic panel model in which the sample size is 100 firms a…
list if conditionsI used the following code to list the observations in a variable if the binary "check" is 0. But in …
Why many commands do not work?Hello dear stata community I am kind of new to stata but I have been facing issues with many command…
Subscribe to:
Post Comments (Atom)
0 Response to Summing dollar amount for each unique id for each year
Post a Comment