Hello,

I would like to summarise a table, I have data for EU-NUTS2 regions by year by fund type (while in some fund types some years and some regions are missing). How should I proceed to have total of fund for each region by each year. I am pasting a snapshot by using dataex

input str4 nuts2_id str5 fund int year annual_expenditure
"BE10" "ERDF" 1990 3253
"BE10" "ERDF" 1991 31593
"BE10" "ERDF" 1992 23647
"BE10" "ERDF" 1993 9622
"BE10" "ERDF" 1994 18910
"BE10" "ERDF" 1995 13264
"BE10" "ERDF" 1996 4101
"BE10" "ERDF" 1997 10670
"BE10" "ERDF" 1998 11977
"BE10" "ERDF" 2002 0
"BE21" "ERDF" 1989 753634
"BE21" "ERDF" 1990 1590907
"BE21" "ERDF" 1991 3608025
"BE21" "ERDF" 1992 6815178
"BE21" "ERDF" 1993 3392391
"BE21" "ERDF" 1994 5864555
"BE21" "ERDF" 1995 597074
"BE21" "ERDF" 1996 629762
"BE21" "ERDF" 1997 1671753
"BE21" "ERDF" 1998 262856
"BE21" "ERDF" 2002 0
"BE22" "ERDF" 1989 1341401
"BE22" "ERDF" 1990 4502026
"BE22" "ERDF" 1991 6521048
"BE22" "ERDF" 1992 6699896
"BE22" "ERDF" 1993 8697280
"BE22" "ERDF" 1994 11877239
"BE22" "ERDF" 1995 8722705
"BE22" "ERDF" 1996 985270
"BE22" "ERDF" 1997 2151941
"BE22" "ERDF" 1998 111245
"BE22" "ERDF" 2002 0
"BE23" "ERDF" 1990 1754
"BE23" "ERDF" 1991 392162
"BE23" "ERDF" 1992 455768
"BE23" "ERDF" 1993 210828
"BE23" "ERDF" 1994 270693
"BE23" "ERDF" 1995 33450
"BE23" "ERDF" 1996 35716
"BE23" "ERDF" 1997 102466
"BE23" "ERDF" 1998 176026
"BE23" "ERDF" 2002 0
"BE24" "ERDF" 1990 244986
"BE24" "ERDF" 1991 762547
"BE24" "ERDF" 1992 866147
"BE24" "ERDF" 1993 1345935
"BE24" "ERDF" 1994 1480979
"BE24" "ERDF" 1995 551903
"BE24" "ERDF" 1996 112150
"BE24" "ERDF" 1997 304207
"BE24" "ERDF" 1998 428599
"BE24" "ERDF" 2002 0
"BE25" "ERDF" 1990 1451
"BE25" "ERDF" 1991 324456
"BE25" "ERDF" 1992 377080
"BE25" "ERDF" 1993 174428
"BE25" "ERDF" 1994 223958
"BE25" "ERDF" 1995 27675
"BE25" "ERDF" 1996 29549
"BE25" "ERDF" 1997 84775
"BE25" "ERDF" 1998 145635
"BE25" "ERDF" 2002 0
"BE31" "ERDF" 1990 456
"BE31" "ERDF" 1991 132392
"BE31" "ERDF" 1992 286518
"BE31" "ERDF" 1993 255236
"BE31" "ERDF" 1994 107850
"BE31" "ERDF" 1995 27873
"BE31" "ERDF" 1996 43043
"BE31" "ERDF" 1997 66005
"BE31" "ERDF" 1998 93955
"BE31" "ERDF" 2002 0
"BE31" "ERDF" 2003 0
"BE32" "ERDF" 1989 2063378
"BE32" "ERDF" 1990 2867188
"BE32" "ERDF" 1991 7188924
"BE32" "ERDF" 1992 16106577
"BE32" "ERDF" 1993 13644659
"BE32" "ERDF" 1994 8045528
"BE32" "ERDF" 1995 1762908
"BE32" "ERDF" 1996 867356
"BE32" "ERDF" 1997 2390226
"BE32" "ERDF" 1998 4775608
"BE32" "ERDF" 2000 0
"BE32" "ERDF" 2002 0
"BE32" "ERDF" 2003 0
"BE33" "ERDF" 1989 2291164
"BE33" "ERDF" 1990 3993413
"BE33" "ERDF" 1991 7886798
"BE33" "ERDF" 1992 15171084
"BE33" "ERDF" 1993 9166192
"BE33" "ERDF" 1994 10059128
"BE33" "ERDF" 1995 3677274
"BE33" "ERDF" 1996 581948
"BE33" "ERDF" 1997 1580130
"BE33" "ERDF" 1998 3790119
"BE33" "ERDF" 1999 0
"BE33" "ERDF" 2000 0
"BE33" "ERDF" 2002 0
"BE33" "ERDF" 2003 0
end
[/CODE]


Any help would be appreciated.

Thank you.