count

[Abigail Yescas]

Hello, I've been looking for the command to create the variable in yellow, using "bysort folio2 ls04: gen mujeres=_N" I created "count" but I don't know how to create variable "mujeres por hogar", can you help me please?

[Nick Cox]

egen mujeresporhogar = total(sexo == 3), by(hogar)

[Abigail Yescas]

thank you very much Nick!!

[Thuy Dung Nguyen]

egen mujeresporhogar = total(sexo == 3), by(hogar)

Sorry Nick Cox,

If I have more than 1 condition as in her example (sexo == 3 and z==0 for example), how can I modify the command.
I try with the following, but it doesn't work:

 
 egen mujeresporhogar = total(sexo == 3 & z==0), by(hogar)

Thank you for your consideration