st: on data transformation

[rado645-bg@yahoo.de]

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/