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
utest - generating missing valuesHello, adding a squareterm of my independent variable I noticed an inverse curvlinear relationship.…
LD calculation by logit regressionHello, I would like to know how I can calculate the LD50, LD90 and LD 95 (lethal dose) for bioassay…
infix and infile commands not recognizing dictionaryI am trying to import fixed format datasets. For each month, I have a dataset and the corresponding …
How to use CPI or inflation indices to convert nominal prices with DAILY frequency?I'm working with some raw financial data from a local business covering about 4 years from 2015-2019…
mhtexpI am not being able to interpret the output of 'mhtexp' command. The following is what I have when I…
Subscribe to:
Post Comments (Atom)
0 Response to Summing dollar amount for each unique id for each year
Post a Comment