Too many values when tabulating foreign aid by country

[Daniel Strand]

Hey guys. I'm using AidDatas dataset on Chinese foreign aid. The dataset contains around 13.000 observations on donations/projects/investments in the 2000-2017 period. I would like to look at the total amount of donations (in USD) by country in the period. I guess what i want is to combine the total amount, in USD, of donations by country instead of having, for example, 200 single observations for a given country with each observation having it's own USD value.

I'm not sure if it's relevant but the variable for the donations in USD looks like this when using dataex:

clear
input double AmountConstantUSD2017
2015410.8121677
.
1000000
2663728.10772083
.
.
1000000
73992447.4366898
50000000
501868.162854889
.
.
.
7399244.74366898
2.500e+08
4000000
3000000
371410.238193509
148464.406297997
148464.406297997
1485898.06914626
29596978.9746759
30000000
5000000
60000000
.
1.000e+09
1.000e+09
405053533
65300000
35300000
7399244.74366898
.
.
30000
.
.
.
.
.
3.760e+08
38000000
28000000
.
175000
.
.
.
.
2000000
1.500e+08
50000000
.
36250000
2.200e+09
3.315e+08
.
3.000e+08
.
3.473e+08
166764178.032811
.
9600000
1.000e+08
73330000
18000000
14798489.4873379
.
.
.
5150000
.
.
3341498.92624091
4.600e+08
.
.
21430000
.
50000
84301667.153149
.
752790000
73992447.4366898
467840000
.
.
.
.
.
.
151548381.710071
1.750e+09
59180000
82871.5411290926
.
4000000
3036500
4500000
.
end

Feel free to ask clarifying questions and i'll answer them as good as i can.

[Nick Cox]

Several tabulation commands will give you totals (sometimes called sums) on request. One is tabstat (quite easy) and another is table (more complicated and more verstaile). If you tried tabulate, that does what it does, but is less versatile.