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
Year and Month fixed effectsHi, I would like to run a regression with year month fixed effects. My data consists of year and mo…
Panel GARCH Model?Dear all, I am attempting to estimate a panel EGARCH-M model in STATA, as of yet I have had no luck…
How to correct the alignment of outputI am doing data cleaning and the output is hard to clean because of how it is coming out. For some t…
cmp multivariate probitHi, I am running a multivariate probit model using the cmp function on 4 binary dependent variables…
Boxplot in complex design surveyDear Statalist users: I have a data set with weight syntax as below, How can I run a box plot with …
Subscribe to:
Post Comments (Atom)
0 Response to Summing dollar amount for each unique id for each year
Post a Comment