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
Showing a different mean in tabstat I tabulated in my data type of error cases by the number of children. After using sum and N along w…
Create variable using expansion factorDear all, I would like to ask you a question. In a database I have identified a group of people, who…
error: depvar may not be a factor variableHey everybody, I want to run a regression with binary variables but I am getting this error: depvar…
Converting Date-Month-Year (string) to yearDear Stata Members I have an issue which I know is the most answered questions in this form, I tried…
Generate two new variables in Stata representing the change in net-pay and the change in well-being between june and octoberHi, I'm new to Stata how can I show the above statement in Stata? I would really appreciate any advi…
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