Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | rado645-bg@yahoo.de |
To | statalist@hsphsun2.harvard.edu |
Subject | st: on data transformation |
Date | Wed, 20 Jul 2011 20:41:32 +0100 (BST) |
Dear all, I would like to ask for help with data transformation. I have data on objects x1, x2,x3 that are observed over time (weeks). I have variables var1 and var2 for each objects and also variable indicating the year of observation. In addition, a variable "event" indicates the time period when an event has occurred. The columns of the panel data set look as follows: x week var1 var2 year event x1 2006w2 var1 var2 2006 x1 2006w3 var1 var2 2006 x1 2006w4 var1 var2 2006 x1 2007w7 var1 var2 2007 x1 2007w8 var1 var2 2007 x1 2007w9 var1 var2 2007 x1 2007w10 var1 var2 2007 1 x2 2008w2 var1 var2 2008 x2 2008w3 var1 var2 2008 x2 2008w4 var1 var2 2008 x2 2009w9 var1 var2 2009 x2 2009w8 var1 var2 2009 x2 2009w9 var1 var2 2009 x2 2009w10 var1 var2 2009 1 I have many variables x that differ in number of weeks and years. I need however to keep the year when the event has happened and dropped any previous years. Given my data set, is this possible to be done in Stata? Many thanks in advance. KR, Rado * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/