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
putexcel string data valuesHi! I am working on survey data and want to export the survey year for each country to an excel list…
General Lasso ConfusionI ran a lasso regression on my data and it does not reach the r^2 that a regression of my own design…
Tracking the replacement of older CEOs with younger onesDear Statalist Members, I am working with CompustatExecucomp merged data. I need to create a dummy v…
matching equal observations spread across two different variablesHi all, I wish to match the observations of assignment with equal observations from serial. For exa…
teffects nnmatch, atet generates wrong matching variable?If I examine the average treatment effect on the treated using a matching estimator, only the treate…
Subscribe to:
Post Comments (Atom)
0 Response to Summing dollar amount for each unique id for each year
Post a Comment