A part of a group

[Lucian Lipciuc]

Hello guys,

I have some firms data from 2010 to 2018 and I defined zombie firm by

gen zombie = (l2.icr <1 & l1.icr < 1 & icr < 1)
gen Zombie = (l2.icr <1 & l1.icr < 1 & icr< 1 & age > 10)
where
icr = iterest covarage ratio

Then I executed "tabstat capital, by (year)" and gave the mean of capital of the firms by each year, like in the attachment. How can I see the mean or the capital of zombie firms by year?

Thank you in advance

[Marcos Almeida]

You can try something like: tabulate Zombie year, summarize(capital)

[Lucian Lipciuc]

Yes, that's exactly what I need. Can I make a graphic with that data?

[Marcos Almeida]

This would be a very simple graph, but you may start by typing:

graph bar (mean) capital, over(Zombie) over(year) asyvars

[Lucian Lipciuc]

wow that's perfect! Muito brigado

[Marcos Almeida]

"De nada". Thank you for reporting the thead reached a satisfactory solution for you.