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
How can I transform the data structure?Dear all, How can i transform the data structure below Code: * Example generated by -dataex-. For m…
Fixed effects panel regression with robust standard error- which code to use?Hi, I'm using the following code to perform fixed effects panel regression Code: areg y x1 x2 i.ye…
error ) required r(100);Dear all, The code below gives me the error Code: ) required ; Code: twoway (line RM_RF Year), yt…
Direct Standardisation- two in-built Stata methods, different resultsWhile doing analysis recently, I came across a peculiar problem. For reproducibility, the two .dta f…
Generating a Variable Conditional on Many Variable that are not Dummy VariablesHi everyone, I have this dataset that contains information on the relationship of each household mem…
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