-total- accepts -if- and -in-, so restrictions
are no problem.
You really _should_ care about systematic name
structures. If I have variables
a b c d e
then I can get totals in variables like this:
foreach v of var a b c d e {
egen total_`v' = total(`v')
}
or like this:
foreach v of var a b c d e {
egen `v'_total = total(`v')
}
So, using text like "total" as suffix or prefix in new
names is an easy way of making new variables systematically.
It is less easy to insert text as infix.
I know only a very little Spanish. I'm not sure what that
has to do with anything.
Nick
[email protected]
Sebastian Kruk
> I have a household survey. I want to obtain data on the labour force
> which is subcategorized by employed (when pobpcoac equals 2) and
> unemployed (when pobpcoac equals 3 or 4 or 5), <14 years old (when
> pobpcoac equals 1) and inactive population (when pobpcoac is between 6
> and 11) by sex and chief or not of the house.
>
> >If you want just to get totals of variables, there is a
> command called -total-.
>
> I want to get totals of variables under some restrictions.
>
> >Otherwise, there is little point in filling variables with constants,
> unless you really >need those variables later.
>
> >If you really do, look at -foreach- as a way of looping over
> variables. -search >foreach- will indicate sources of tutorials.
>
> I'm just beginning to learn Stata.
>
> >Your variable name structure makes looping a little difficult.
>
> I don't care about names, I just want to obtaing employed, unemployed,
> and inactive population.
>
> >Putting "indice" inside each variable name is awkward.
>
> Do you know spanish?
>
> >Nick
> >[email protected]
>
> Sebastian Kruk
>
> >> Are there a easier way of do it?
> >>
> >> egen desocupados_indice = anycount (pobpcoac), values(3 4 5)
> >>
> >> egen byte desocupados_indice_man = anycount(pobpcoac) if
> >> e1==1, values(3 4 5)
> >>
> >> egen byte desocupados_indice_man_jefe = anycount(pobpcoac)
> if e1==1 &
> >> e3==1, values(3 4 5)
> >>
> >> egen byte desocupados_indice_man_no_jefe =
> anycount(pobpcoac) if e1==1
> >> & e3!=1, values(3 4 5)
> >>
> >> egen byte desocupados_indice_woman = anycount(pobpcoac) if
> >> e1==2, values(3 4 5)
> >>
> >> egen byte desocupados_indice_woman_jefe =
> anycount(pobpcoac) if e1==2
> >> & e3==1, values(3 4 5)
> >>
> >> egen byte desocupados_indice_woman_no_jefe = anycount(pobpcoac) if
> >> e1==2 & e3!=1, values(3 4 5)
> >>
> >> egen desocupados = total(desocupados_indice)
> >>
> >> egen desocupados_man = total(desocupados_indice_man)
> >>
> >> egen desocupados_man_jefe = total(desocupados_indice_man_jefe)
> >>
> >> egen desocupados_man_no_jefe =
> total(desocupados_indice_man_no_jefe)
> >>
> >> egen desocupados_woman = total(desocupados_indice_woman)
> >>
> >> egen desocupados_woman_jefe = total(desocupados_indice_woman_jefe)
> >>
> >> egen desocupados_woman_no_jefe =
> >> total(desocupados_indice_woman_no_jefe)
> >>
> >> egen ocupados_indice = anycount (pobpcoac), values(2)
> >>
> >> egen ocupados_indice_man = anycount(pobpcoac) if e1==1, values(2)
> >>
> >> egen ocupados_indice_man_jefe = anycount(pobpcoac) if
> e1==1 & e3==1,
> >> values(2)
> >>
> >> egen ocupados_indice_man_no_jefe = anycount(pobpcoac) if e1==1 &
> >> e3!=1, values(2)
> >>
> >> egen ocupados_indice_woman = anycount(pobpcoac) if e1==2, values(2)
> >>
> >> egen ocupados_indice_woman_jefe = anycount(pobpcoac) if e1==2
> >> & e3==1, values(2)
> >>
> >> egen ocupados_indice_woman_no_jefe = anycount(pobpcoac) if e1==2 &
> >> e3!=1, values(2)
> >>
> >> egen ocupados = total (ocupados_indice)
> >>
> >> egen ocupados_man = total(ocupados_indice_man)
> >>
> >> egen ocupados_man_jefe = total(ocupados_indice_man_jefe)
> >>
> >> egen ocupados_man_no_jefe = total(ocupados_indice_man_no_jefe)
> >>
> >> egen ocupados_woman = total(ocupados_indice_woman)
> >>
> >> egen ocupados_woman_jefe = total(desocupados_indice_woman_jefe)
> >>
> >> egen desocupados_woman_no_jefe =
> >> total(desocupados_indice_woman_no_jefe)
> >>
> >> generate pea=ocupados+desocupados
> >>
> >> egen pei_indice = anycount (pobpcoac), values(6/11)
> >>
> >> egen pei = total( pei_indice)
> >>
> >> generate pet=pea+pei
> >>
> >> egen pnet_indice = anycount (pobpcoac), values(1)
> >>
> >> egen pnet = total( pnet_indice)
> >>
> >> generate poblacion=pet+pnet
> >>
> >> generate tasa_empleo=ocupados/pet
> >>
> >> generate pet_ine=1620743
> >>
> >> generate ocupados_expandidos=tasa_empleo*pet_ine
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
