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
Importing variable with special characters, strings and numbersDear Stata users, I am experiencing problems in importing a variable from a csv file. This variable…
xtpdyn marginsDear all, I've encountered a problem when implementing xtpdyn postestimation. Using this example: xt…
Gini coefficient in a LoopDear all, I need to compute the Gini coefficient over country and over waves. Therefore, I realized …
XSMLE dynamic SDM where beta is constrained to = 0Dear list members, I have a special request estimating a dynamic spatial durbin model. I would like…
Regression rich text file issueHello, I am attempting to transfer the regression to a rich text file. For some reason my regression…
Subscribe to:
Post Comments (Atom)
0 Response to Summing dollar amount for each unique id for each year
Post a Comment