Table Creation

[Deepanshu Mishra]

Hii,
I have a hospitals data. There is variable named districts, blocks and hospital_name, there are some blocks in each district and within each blocks there are many hospitals. I want to know how many blocks in a district. Is there anyone who can help me out in this?? thank you

[Nick Cox]

Possibly for "a district".

tab block if district == "Whatever" 
display r(r)

Do you mean in each district, meaning all of them?

[Deepanshu Mishra]

thanks Nick,
Yes I mean all of them.

[Nick Cox]

Possibly

egen tag = tag(block district) 
egen blocks = total(tag), by(district) 
label var blocks "# of blocks" 
tabdisp district, c(blocks)

For the principles here, read and study https://www.stata-journal.com/sjpdf....iclenum=dm0042

[Deepanshu Mishra]

thanks Nick,
It worked.