Maarten, thank you very much. The way you have done the tabulation is
being very useful.
May I bother you again with other question? with the same data, I'd
like to know, by range of age, what�s the percentage self -employed
males or females. I tryed to do this in the same way you have done the
other tabulation (using cond()), but it didn�t work. I'm sure that I�m
doing something wrong; so, I tryed in an "ugly" way, this:
bysort age: egen self_age_m = count(selfemployed & sex == 1)
bysort edad: egen self_age_f = count(selfemployed & sex == 2)
bysort edad: egen activity_m = count(activity & sex == 1)
bysort edad: egen activity_f = count(activity & sex == 2)
gen self_act_age_m = self_age_m / activity_m
gen self_act_age_f = self_age_f / activity_f
noi tab age self_act_age_m
noi tab age self_act_age_f
but Stata is not doing what I was expecting. The output (wrong) is this:
self_act_age_m
age? | 1 | Total
-----------+-----------+----------
1 | 66 | 66
2 | 2,311 | 2,311
3 | 3,761 | 3,761
4 | 3,947 | 3,947
5 | 2,852 | 2,852
6 | 1,924 | 1,924
7 | 1,582 | 1,582
-----------+-----------+----------
Total | 16,443 | 16,443
age | self_act_age_f | Total
-----------+-----------+----------
1 | 66 | 66
2 | 2,311 | 2,311
3 | 3,761 | 3,761
4 | 3,947 | 3,947
5 | 2,852 | 2,852
6 | 1,924 | 1,924
7 | 1,582 | 1,582
-----------+-----------+----------
Total | 16,443 | 16,443
But I�to know the percentage of people satisfying some conditions by age.
Thank you again!!
Leonor
2008/6/18, Leonor Saravia <[email protected]>:
> Dear Statalisters,
>
> First I�d like to thank Andrea Bennet and Austin Nichols, for the help
> in merging the different datasets that I'm already using. :)
>
> I'm working with a database that has information for working people,
> male and female, in different ranges of age and I'd like Stata to
> count how many male (female) persons are in each interval of age and
> satisfy the condition of being a self-employed person. Until now, I' m
> doing this:
>
> bysort age: egen indep_m = sum(selfemploy == 1 & sex == 1)
> tab inxed_m
>
> bysort age: egen indep_f = sum(selfemploy == 1 & sex == 2)
> tab inxed_f
>
> And the Stata output for this is:
>
> inxed_m | Freq. Percent Cum.
> ------------+-----------------------------------
> 2 | 66 0.40 0.40
> 70 | 1,582 9.62 10.02
> 144 | 2,311 14.05 24.08
> 231 | 1,924 11.70 35.78
> 373 | 3,761 22.87 58.65
> 427 | 2,852 17.34 76.00
> 530 | 3,947 24.00 100.00
> ------------+-----------------------------------
> Total | 16,443 100.00
>
> inxed_f | Freq. Percent Cum.
> ------------+-----------------------------------
> 0 | 66 0.40 0.40
> 26 | 1,582 9.62 10.02
> 65 | 2,311 14.05 24.08
> 68 | 1,924 11.70 35.78
> 164 | 2,852 17.34 53.12
> 171 | 3,761 22.87 76.00
> 259 | 3,947 24.00 100.00
> ------------+-----------------------------------
>
>
> My problem is that when I tabulate the result variables (" indep_m"
> and "indep_f ") Stata brings the output of the number of persons in
> each age range in an ascending order, but I'd like to have the
> information ordered by the range of age (not by the number of persons
> satisfying the conditions), to know how many persons are working as
> independent in each range of age.
>
> I'd appreciate very much your advice in this.
>
> Thanks!
>
> Leonor
>
*
* 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/
