Hello,
Currently, I am writing my thesis, in which I have to calculate the moving median of the ROE of 48 firm classifications by Fama French (1997). The calculation is as follows:
"To compute a target industry ROE, we group all stocks into the same 48 industry
classifications as Fama and French [1997]. The industry target ROE is a moving median of past ROEs from all firms in the same industry. We use at least five years, and up to ten years, of past data to compute this median."
I already had a look at the last post: https://www.statalist.org/forums/for...for-industries
I used and then modified the code they used in the post because I already selected 5 years. However, I did not manage to get the code right, because I am getting an "if not found" error. Maybe someone knows how to get it right? It would be of great help.
This is the code I now have:
levelsof industry, local(industries)
levelsof Date, local(years)
gen moving_median_roe = .
foreach ind of local industries {
foreach y of local years {
replace moving_median_roe = `r(p50)' if industry == `ind' & Date == `y'
}
}
summ moving_median_roe
This is my data:
Related Posts with Stuck while calculating moving median
How to Calculating time difference between visits in a panel dataI hope this finds you well. I kindly need your help to calculate the time difference(Months, Years …
Issue with rename on a foreach loopHi I am trying to start a loop so that I can rename my variables. I tried using the same format I …
Dealing with a variable that has both numeric and categorical observationsHi everyone. I am new to this site so please bear with me. I am running a regression of property va…
Stochastic frontier panel estimationsDear all, Your assistance will be greatly appreciated! I am running a stochastic frontier model wi…
Stata 15 crashes when using unicode translateDear community, I am using Chinese panel data for 2012 and 2014 and I've been using the Code: uni…
Subscribe to:
Post Comments (Atom)
0 Response to Stuck while calculating moving median
Post a Comment