请教各位老师同学,每个id的var2仅得到一个观测值(即2004年的观测值),stata上如何操作,能将缺漏部分补充为,与已得到的var2相等的值呢?
非常感谢
数据示例如下:
| 原始 |
| 补充后 |
| year | id | var2 |
| year | id | var2 |
| 2004 | 1 | 2480 |
| 2004 | 1 | 2480 |
| 2002 | 1 | . |
| 2002 | 1 | 2480 |
| 2003 | 1 | . |
| 2003 | 1 | 2480 |
| 2003 | 2 | 2400 |
| 2003 | 2 | 2400 |
| 2004 | 3 | 3840 |
| 2004 | 3 | 3840 |
| 2002 | 3 | . |
| 2002 | 3 | 3840 |
| 2003 | 3 | . |
| 2003 | 3 | 3840 |
| 2004 | 3 | . |
| 2004 | 3 | 3840 |
| 2005 | 3 | . |
| 2005 | 3 | 3840 |
| 2006 | 3 | . |
| 2006 | 3 | 3840 |
| 2004 | 4 | 4800 |
| 2004 | 4 | 4800 |
| 2002 | 4 | . |
| 2002 | 4 | 4800 |
| 2004 | 5 | 4560 |
| 2004 | 5 | 4560 |
| 2005 | 5 | . |
| 2005 | 5 | 4560 |
| 2006 | 5 | . |
| 2006 | 5 | 4560 |
| 2004 | 6 | 3000 |
| 2004 | 6 | 3000 |
| 2001 | 6 | . |
| 2001 | 6 | 3000 |
| 2002 | 6 | . |
| 2002 | 6 | 3000 |
| 2005 | 6 | . |
| 2005 | 6 | 3000 |
| 2004 | 7 | 7200 |
| 2004 | 7 | 7200 |
| 2005 | 7 | . |
| 2005 | 7 | 7200 |
| 2004 | 8 | 7200 |
| 2004 | 8 | 5600 |
| 2004 | 9 | 2700 |
| 2004 | 9 | 2700 |
| 2005 | 9 | . |
| 2005 | 9 | 2700 |
| 2002 | 9 | . |
| 2002 | 9 | 2700 |