Displaying 1 result from an estimated 1 matches for "of_inpreviousyear".
2009 Oct 21
1
re ferring to data of previous rows
...2 2005 1
2 2006 0
2 2007 1
3 2003 1
3 2004 1
3 2005 1
3 2006 0
3 2007 0
Now I want to add the column "offspring in the previous year - yes/no(1-0)"
the output now should look like this:
Id year of of_inPreviousYear
1 2003 1 NA
1 2004 0 1
1 2005 1 0
1 2006 1 1
1 2007 0 1
2 2003 0 NA
2 2004 1 0
2 2005 1 1
2 2006 0 1
2 2007 1 0
3 2003 1 NA
3 2004 1 1
3 2005 1 1
3 2006 0 1
3 2007 0 0
any idea how I could program that?
than...