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

st: ask for data manipulation!


From   vinkwai wong <0034058@fudan.edu.cn>
To   "statalist@hsphsun2.harvard.edu" <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/



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