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
Related Posts with Group averages and assign them to a specific date
error statement r(1400) "initial values not feasible" when running xtlogitHi. I'm using Stata 15.1/MP and am running into an error that I've not seen before. The model is usi…
Working with Dates in Panel DataI'm trying to compute and incidence case based on test_1. So an incident case will be a positive tes…
Create stata time variableHi Stata Users, I have data in the form 01.01.2019 and want Stata to use it as time variable I tri…
Creating variable for other events in same region/yearHi everyone! I am dealing with a worldwide data set on conflict events with an unbalanced panel str…
CreatingBar GraphHello, I need to make a graph showing average expenditure for income quartiles, differing by househ…
Subscribe to:
Post Comments (Atom)
0 Response to Group averages and assign them to a specific date
Post a Comment