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!