Hello all,

I am quite new to stata and I need help with a simple question (I think), that I just can't figure out. I am attempting to add the values in the count variable, so that I end up with unique values on year. Count refers to the number of events I am analyzing. So 1 menas that it happened once, 0 that the event did not occur that year. My dataset looks like this:

count year
1 1990
1 1992
1 1992
1 1993
1 1994
1 1995
1 1995
1 1995
1 1995
1 1996
1 1996
1 1996
1 1997
1 1998
1 2000
1 2000
1 2001
1 2001
1 2007
0 2008
1 2008
0 2009
1 2011
1 2014
1 2014

I wish to sum the count for each year, so that the dataset will look like this:

count year
1 1990
2 1992
1 1993
1 1994
4 1995
3 1996
1 1997
1 1998
2 2000
2 2001
1 2007
1 2008
0 2009
1 2011
2 2014

I then wish to "fill in the gaps", so that my dataset looks like this:

1 1990
0 1991
2 1992
1 1993
1 1994
4 1995
3 1996
1 1997
1 1998
0 1999
2 2000
1 2001
0 2002
0 2003
0 2004
0 2005
0 2006
1 2007
1 2008
0 2009
0 2010
1 2011
0 2012
0 2013
2 2014

I need to expand the dataset as I am going to include more variables where there will be values for every year.

All help is appreciated!

Regards,
Madeleine