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
showing different confidence levels for IRF & positive versus negative shocks (VAR analysis)Hi all I have two basic questions for a VAR analysis: 1- I am estimating a var and plotting the orth…
Create a variables based on consecutive years of observationDear Stata Users, Please, help me to resolve the following issue. Below is the sample of data that I…
Creating a dummy variable for each observation separatelyHello, I have a nummeric variable which is represented in % and I need to recode this variable. To …
Weighted t testIs it possible to ttest a variable weighted by another variable in the dataset? So, to ttest the wei…
Aggregating Data under serveral conditionsHej Statalist, I have a problem, as I want to aggregate my panel data under certrain conditions. I …
Subscribe to:
Post Comments (Atom)
0 Response to Group averages and assign them to a specific date
Post a Comment