st: How to generate a variable which is different for each cell

[Peter Peter <pebiko85@yahoo.de>]

Hi Statalisters, 

I have a question which is hard for me to explain, so I will just show you:

Company    Estdate   Estyear    Analyst   Forecast  MEAN  Innovative
AA             Feb, 2.    1984         x             0,68
AA             Sep, 14.  1984         y             0,5
AA             Oct, 15.   1984         z             0,46
AA             Nov, 28.   1984         a             0,76
AA             Nov, 28.   1984         zy           0,54              

I want to generate a dummy variable which becomes 1 if the individual forecast 
is above the mean forecast of all analysts or else 0. 

The commands are:
 
bysort Company Estyear (Estdate): egen MEAN = mean (estdate) 
gen Innovative = 1 if Forecast > MEAN 

So this is pretty simple. But now the mean forecast should only be based on 
forecasts issued 90 days prior. I so far  considered all the forecasts. So each 
Analyst should have his own Mean forecast. How do I solve this Problem? 


Thanks in Advance, 

Peter Biegler



*
*   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/