Hi all, I have a coding problem. Basically, I want to add more rows and change Data A to Data B. That is, for each code A and B, I want to have observations for 2004, 2005, ..., 2011. In Code=B, new rows before the first year in Data A should include the first year's value, while new rows after the last year in Data A should include the first year's value. Could you help me how to make a code for the transformation from Data A to Data B? Thank you! (Data A) Code value year A 10 2005 B 8 2005 B 8 2006 B 9 2007 B 10 2008 B 10 2009 B 11 2010 (Data B) Code value year A 10 2004 A 10 2005 A 10 2006 A 10 2007 A 10 2008 A 10 2009 A 10 2010 A 10 2011 B 8 2004 B 8 2005 B 8 2006 B 9 2007 B 10 2008 B 10 2009 B 11 2010 B 11 2011
... View more