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
Instrumental Variables and using xtivreg with squared termHi - I am using a panel dataset of US companies for the years 2000-19 (US Industrials - Worldscope).…
Coefficient of VariationDear all Statalist, Just an apparent easy question, even if I am having problems in computation: if…
conditional averagingHello all, this id small part of my data set. in my dataset, there are 18 villages. I want to averag…
Average of Top (x) RankedGood morning, Would appreciate some code that generates in the wanted var, the average for the mast…
Is there a way to know the number of unique values under a combination of variables?Dear Statalisters, I have a dataset which tracks individuals who work for different companies at dif…
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