Hi
I am working with a panel data set with c300 firms from years 2008 to 2014, with several firm-level variables such as sales, cash flow etc
I would like to rank firms by their sales in 2010 and then sort firms into categories (large and small) based on the value of sales in the year 2010. ie. if the firm's value for sales is in the top half/third/quartile in the year 2010, it takes the value one (large), and zero otherwise (small).
In short, I'm looking to identify large firms by looking at the top quartile/third/half of sales in 2010, and classify remaining firms as small.
Any questions or if something isn't clear, please ask, and thanks in advance,
Paul
Related Posts with Ranking/categorizing firms based on the value of a variable in a specific year
tobit test for homoskedasticityFrom what i understand, conventional OLS heteroskedasticity tests can't be applied for Tobit regress…
collapsing the expanded rows keeping only oneHi I have expanded my data making 11 rows for some reasons as below. Now, I just want to keep one ro…
ml command for logit panel dataHi All: I am new to ml command. Before writing a more complicated code, I am testing the code on lo…
coding and generating variables CEO-TMT sociodemographic similarity, CEO-TMT shared experience and faultlinesHello everyone, I'm a student and I'm currently having some issues with coding and generating the v…
Year Dummies for a durationHello, I have data which is as below. ISO_O is the country, StartYear and EndYear are the years of …
Subscribe to:
Post Comments (Atom)
0 Response to Ranking/categorizing firms based on the value of a variable in a specific year
Post a Comment