I would like to take the value of revenue at firm_age 5 and place it back to firm_age 0 in a new column.
Any ideas?
| year | firmid | firmage | Revenue | Wanted |
| 2001 | 10 | 0 | 1500000 | 3600000 |
| 2002 | 10 | 1 | 140000 | 0 |
| 2003 | 10 | 2 | 3000000 | 0 |
| 2004 | 10 | 3 | 3100000 | 0 |
| 2005 | 10 | 4 | 3450000 | 0 |
| 2006 | 10 | 5 | 3600000 | 0 |
| 2005 | 44 | 6 | 4000000 | 0 |
0 Response to Create new column which takes value in year 5 back to year 0 (panel data)
Post a Comment