From vinkwai wong <0034058@fudan.edu.cn> To "statalist@hsphsun2.harvard.edu" Subject st: ask for data manipulation! Date Wed, 09 Jun 2004 23:00:45 +0800

```i have such a data:
V1   V2   V3  V4
a    b    c   e
a    f    d   .
b    d    e   f
h    d    .   .
a    d    f   e
¡­¡­
(V1,V2,V3,V4 can be any one of a, b, c, d, e, f, g, h. that is to say ,it has 8 possible values.)

and i want to change it the the following form:
a    b    c    d    e    f    g    h
8    7    6    2.5   5   2.5  2.5  2.5    #2.5is the mean of (4+3+2+1)
8    3    3     6    3    7   3    3      #3 is the mean of (5+4+3+2+1)
2.5  8    2.5   7    6    5   2.5   2.5    #2.5is the mean of (4+3+2+1)
3.5 3.5   3.5   7    3.5  3.5  3.5   8               #3.5is the mean of (6+54+3+2+1)
8   2.5   2.5   7    5    6   2.5    2.5
¡­¡­

i want to know if there is some easy way to achieve my goal using Stata?

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