st: Cumulative average of categorical variables

[Marcello Pagano <pagano@hsph.harvard.edu>]

For Luisa:

---------- Forwarded message ----------
From: Luisa Soares-Miranda<luisasoaresmiranda@gmail.com>
Date: Fri, May 6, 2011 at 12:37 PM
Subject: cumulative average of categorical variables
To: statalist@hsphsun2.harvard.edu


Dear all,

Can anyone tell me how should I do the cumulative average of categorical
variables? My variable was measured in year 1, 2, 3, 4, and they are
categorical ( 4 categories, 0,1,2,3) , so I had use  rowmedian. However in
the en my final variable (the cumulative average ) comes out like this:

Cum_averg |      Freq.     Percent        Cum.
------------+-----------------------------------
         0 |        360        6.11        6.11
        .5 |        342        5.81       11.92
         1 |      2,220       37.70       49.62
       1.5 |        792       13.45       63.07
         2 |      1,611       27.36       90.42
       2.5 |        261        4.43       94.85
         3 |        303        5.15      100.00
------------+-----------------------------------
     Total |      5,889      100.00

So my problem is how do I categorize my new variable the cumulative average
into (0,1,2,3)??? That is whys I do not know if I am doing this right.

thank you,
regards

Luisa


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/