Hi all,

I am working with panel data from a household survey. For each household (nohhold), multiple observations have been made in each year (for different members of the household). Eqin (income) is only reported for the head of the household but I want this value to be extended to each of the household members, since my research focuses on spouses. Is there an easy way to do this? So, to give all observations of eqin for nohhold 106 in 2008 the value of 6841.481?

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input double nohhold float(year eqin)
106 2007         .
106 2007         .
106 2007         .
106 2007         .
106 2007         .
106 2007         .
106 2007         .
106 2007         .
106 2008  6481.481
106 2008          .
106 2008          .
106 2008          .
106 2009          .
106 2009  7711.111
106 2009          .
106 2009          .
106 2010          .
106 2010          .
106 2010          .
106 2010          .
106 2011          .
106 2011  8888.889
106 2011          .
106 2011          .
106 2012          .
106 2012  8888.889
106 2012          .
106 2012          .
106 2013         .
106 2013          .
106 2013          .
106 2013  8888.889
106 2014          .
106 2014          .
106 2014  8888.889
106 2014          .
106 2015  9796.296
106 2015          .
106 2015          .
106 2015          .
106 2016          .
106 2016          .
106 2016  8888.889
106 2016          .
106 2017  11111.11
106 2017          .
106 2017          .
106 2017          .
318 2007         .
318 2007         .
318 2007         .
318 2007         .
318 2007         .
318 2007         .
end