# st: RE: a tabulate question.

 From "Nick Cox" <[email protected]> To <[email protected]> Subject st: RE: a tabulate question. Date Wed, 15 Oct 2003 15:11:20 +0100

```[email protected]
>
> Yesterday night, I encounter this problem. I have the
> following table:
>
> . ta senum rich3
>
> Enumeratio |              rich3
>     n Area |         1          2          3 |     Total
> -----------+---------------------------------+----------
>          1 |        45         31         26 |       102
>          2 |        13         10          6 |        29
>          3 |        40         18          4 |        62
>          5 |        11         13         20 |        44
>       2171 |         0         10          1 |        11
>       2455 |         0          0         11 |        11
>       2920 |         0         11          0 |        11
>       3052 |         0          1         10 |        11
>       4163 |         0          9          3 |        12
> -----------+---------------------------------+----------
>      Total |      2091       2085        931 |      5107
>

> I  am interessed in the first column (very poor). I want to
> compute the ratios
> of poor in the psu
> (for example for the first line: (45 /102 )*100 , for the
> second line: (13 /29)
> *100, etc...)
> and group the PSUs into 3 categories: 40% of poor,  60% of
> poor and more than
> 80% of poor.
>
> I use the command:
> tab senum rich3, matcell(mat_1)
>
> to retrive the matrix but I don't know how to retrive the vector.
>
> I just copy the table into Excel to compute my ratios.
>
> Is there any way to proceed in stata?

If you proceed this way, you end up having
to do an elementwise division of vectors;
that's possible (-search matewd-) but awkward; and then
you have to map your results back onto the dataset.

Here is another way:

egen vpoor = sum(100 * (rich3 == 1)/_N), by(senum)

Watch out, however, for missings.

Nick
[email protected]

*
*   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/
```

• References: