Hi,
I am a newbie with STATA and working with it for my thesis. So, I have a dataset of companies from 2000-2019 with their information such as (industry codes, debt, equity, assets, etc.).
Now, I have grouped the companies based on the SIC codes to find out the number of companies in each industry.
I am having a problem in 2 areas:
1. I want to find the mean value of debt in every industry.
2. I want to find the mean value of debt for every year for the whole sample
How can I go about doing these?
egen tocount = tag(c_id SIC_ID) (This is what I have for now to count for companies within a specific SIC code).
Thanks in advance!
0 Response to Finding mean value of a column based on year
Post a Comment