Hi,

I am trying to make average of the median EPS that have been forecasted 90 days before the earnings announcement date.
These are the variables that I have:
storage display value
variable name type format label variable label
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
statpers long %d I/B/E/S Statistical Period (SAS Format)
median_eps double %12.0g Median Estimate
fpedats long %d Forecast Period End Date (SAS Format)
actual double %12.0g Actual Value, from the Detail Actuals File
announce_date long %d Announce date of the Actual, from the Detail Actuals File
cusip str8 %8s CUSIP/SEDOL


Per company I would like to make a variable predicted_EPS and actual_EPS. The actual EPS that I have right now is the same for each announcement date of each company. I think what I essentially want is to have one announcement date every year for each company and that I have the average of the median_eps that fall within the interval of 90 days prior to the earnings announcement date. Does anyone know how to achieve such a thing?

Kind regards,
Sarah