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
Parameter constraints for MLE modelDear forum guests! I need to introduce a range constraint for the sum on parameters in MLE model. T…
How to Add Deterministic Trend to Panel Data?Hello, I have a panel data with 115 countries and 20 years. I did unit root test in all my independ…
esttab, eststo and appendmodelsDear all, I am tabulating different dependent variables in consecutive rows (not consecutive columns…
Multilevel modelling: How to predict upper-level outcomes?Dear all I have the following problem that I hope to find help with: My data structure is as follo…
Looking for alternatives to outreg2Dear Statalist, I am trying to do some descriptives and to export the table to a word document. I u…
Subscribe to:
Post Comments (Atom)
0 Response to Summing dollar amount for each unique id for each year
Post a Comment