st: a tabulate question.

[adiallo5@worldbank.org]

Dear all,

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
         6 |        31         11          2 |        44
         7 |        59         11         13 |        83
         8 |        31          2         14 |        47
         9 |        27         12          2 |        41
        10 |        16         16          4 |        36
        11 |        22          4          3 |        29
        12 |        32         22          0 |        54
        14 |        24          6          2 |        32
        15 |         3         26          5 |        34
        17 |         0          0         11 |        11
        18 |         9          2          0 |        11

.......


       818 |        10          1          0 |        11
       855 |         0         11          0 |        11
       884 |         0          2          9 |        11
       980 |         1         10          0 |        11
      1044 |         0          3          9 |        12
      1049 |         0          9          2 |        11
      1053 |         0          7          4 |        11
      1099 |         0          1         10 |        11
      1118 |         0         11          0 |        11
      1147 |        11          0          0 |        11
      1181 |         3          8          0 |        11
      1231 |         0          1         10 |        11
      1296 |         0          1         10 |        11
      1587 |         4          7          0 |        11
      1767 |         0          1         10 |        11
      1772 |         0          9          2 |        11
      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?

Thanks.


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