clear
input str20 NAME TIME VALUE
A 2008 4
A 2009 2
A 2010 5
B 2008 11
B 2009 23
B 2010 43
end
sort NAME TIME
gen temp=VALUE[_n+3]
list
replace VALUE=temp
list
drop temp
. clear
. input str20 NAME TIME VALUE
NAME TIME VALUE
1. A 2008 4
2. A 2009 2
3. A 2010 5
4. B 2008 11
5. B 2009 23
6. B 2010 43
7. end
. sort NAME TIME
.
. gen temp=VALUE[_n+3]
(3 missing values generated)
. list
+----------------------------+
| NAME TIME VALUE temp |
|----------------------------|
1. | A 2008 4 11 |
2. | A 2009 2 23 |
3. | A 2010 5 43 |
4. | B 2008 11 . |
5. | B 2009 23 . |
|----------------------------|
6. | B 2010 43 . |
+----------------------------+
. replace VALUE=temp
(6 real changes made, 3 to missing)
. list
+----------------------------+
| NAME TIME VALUE temp |
|----------------------------|
1. | A 2008 11 11 |
2. | A 2009 23 23 |
3. | A 2010 43 43 |
4. | B 2008 . . |
5. | B 2009 . . |
|----------------------------|
6. | B 2010 . . |
+----------------------------+
.
.
end of do-file
.
|