Create mean values in paneldata for an firm-overview

[albert master]

Hey!
I want to create an overview of my paneldataset and like to show an overview of the included companies.
Therefore I like to include certain key figures like the mean firm value of the company over the sample period.
I started by seperating the different industries I have in my data but the next step is missing:

tab companyname if _est_reg1==1 & industry_cl=="Mining"

I hope I have expressed myself clearly, thanks a lot for your advice!

[Ken Chui]

Let's say the variable you wish to get the mean is called "value", try:

table companyname if _est_reg1==1 & industry_cl=="Mining", stat(mean value)

To learn more, check out help table.

And this is not directly related to your answer. You can also get that through collapse, which should save you a lot of code typing:

collapse (mean) value, by(companyname industry_cl _est_reg1)
list
* Or browse
browse