Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Saving percentage distribution


From   zt22@cornell.edu
To   statalist@hsphsun2.harvard.edu
Subject   st: Saving percentage distribution
Date   Tue, 3 Dec 2002 13:25:30 -0500 (EST)

Hi,

I have two vars ind (52 categories) and occ (7 categories), and I want
the percentage distribution of ind for each category of occ. Note that 
not each ind category has cases. For instance:

Occ=1
ind     pct
1       .0309522
2       .0334331
3	0
4	.0356777
5       .3402772
6       .0294558
.       .
.       .
52      .3151532

Occ=2
ind     pct
1       .0036623
2       .0006301
3	0
4       .0064976
5	0
6       .0455619
.       .
.       .
52      .0953769

As shown above, ind=3 is not in both occ=1 and occ=2 while ind=5 is in
occ=1 but not in occ=2. 

My questions are:

First, if I use tabulate to get the percentage distribution of any 
categorical variable, how can I save the percentages in a new dataset 
that looks like one of the tables above. 
 
Second, in the specific example above, is there a way I can create a new 
dataset that looks like this:

ind     pctocc1         pctocc2
1       .0309522        .0036623
2       .0334331        .0006301
3       0               0
4       .0356777        .0064976
5       .3402772        0
6       .0294558        .0455619
.       .               .
.       .               .
52      .3151532        .0953769

Thanks very much.

Best,
Zun
*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index