Dear all,

This is my data.

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 gender int year float(low_percent med_percent high_percent)
"Female" 1980  49.02597 26.232723 24.741304
"Male"   1980  45.87258  23.72576 30.401657
"Female" 1985  44.01167 28.213015 27.775316
"Male"   1985  46.69176 23.381386 29.926855
"Female" 1990  39.99403  29.00476  31.00121
"Male"   1990  38.92542  27.57945 33.495136
"Female" 1995 37.315308  30.51445  32.17024
"Male"   1995 31.272797  35.79743 32.929775
"Female" 2000 34.850502  32.28494 32.864563
"Male"   2000  34.75787  33.39735  31.84478
"Female" 2005  29.35786 33.057816 37.584324
"Male"   2005  28.14591 35.789925 36.064167
"Female" 2010  28.05079  30.38641   41.5628
"Male"   2010 27.496714  34.87121 37.632076
end

I would like to know how can I generate a table that has gender clubbed (sum of male and female for low_percent, med-percent, high_percent)

So, my data will look something like:
year gender low med high
1980 total sum of low male +low female for 1980 ..and so on
1985 total
1990 total
1995 total
2000 total
2005 total
2010 total

I do not want to collapse, because when I collapse I lose other relevant important data.

Thank you for your help in advance.

Best