I have a data set that is in this format:
year data1 data2 ...
01 .56 ...
01 .34
01 .76
... ...
02
02
...
03
....
09
And I have some more data set that is much smaller:
_year _data1 ...
01 1222
02 2634
03 ....
04
05
06
07
08
09
What is a good way to merge the two data sets so that all the data for each "_year" is matched up with the corresponding "year" in the first data set? The catch is that I want a lag in the years such that "_year=05" matches to "year=06".
Thanks for the help!
year data1 data2 ...
01 .56 ...
01 .34
01 .76
... ...
02
02
...
03
....
09
And I have some more data set that is much smaller:
_year _data1 ...
01 1222
02 2634
03 ....
04
05
06
07
08
09
What is a good way to merge the two data sets so that all the data for each "_year" is matched up with the corresponding "year" in the first data set? The catch is that I want a lag in the years such that "_year=05" matches to "year=06".
Thanks for the help!