st: How to create a new variable which contains the response from another member

["Chiung-Ya Tang" <ctang@purdue.edu>]

Hi,

I am learning STATA and would like to use it to analyze a set of dyadic data. The data is as following:

Group    member        V1
　1       1            3.2
　1       2            4.5
　2       1            3.1
　2       2            3.3
　3       1             .
　3       2            2.3

I wish to generate a new variable--V2 in which responses from V1 are exchanged within a group. So, it should look like this:

Group         member          V1      V2
　1              1            3.2     4.5
　1              2            4.5     3.2
　2              1            3.1     3.3
　2              2            3.3     3.1
　3              1             .      2.3
　3              2            2.3      .


I searched commands as well information from Statalist archives but still haven't figured out how to do that correctly. While keeping learning new commands, I definitely appreciate any help from you. Thank you.

Sincerely,
Chiungya
　
　
　
　


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