Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# Re: st: RE: RE: RE: Writing the value of a variable in another variable in a selective way

 From oezguer.guererk@uni-erfurt.de To statalist@hsphsun2.harvard.edu Subject Re: st: RE: RE: RE: Writing the value of a variable in another variable in a selective way Date Wed, 01 Jun 2011 13:39:00 +0200

After 2 hours of unsuccesful trying on my own let me ask again please, this time more precisely:
```
```
I have n==20 "subjects", each with entries for t==60 periods. Each subject has a unique "partner". I would like to stata to write the value of the variable "profit" of subject i's partner into subject i's variable "partnerprofit", for each period.
```
I tried the code below, but it doesn't work.

forval subject =1/20 {

forval period =1/60 {
local partner = partner[`subject']
replace partnerprofit = profit[`partner'] in `period'
}
}
}

Thank you very much again!
Ozgur

Nick Cox schrieb:
```
Tim is correct; thanks! Nick n.j.cox@durham.ac.uk
```Mak, Timothy

```
I think Nick meant:
```gen partnerprofit = profit[5] in 3

```
But following this logic, and if your dataset is not large, you could do it in a loop, I think:
```gen partnerprofit = .
forval i=1/`=c(N)' {

local partnerid = partnerid[`i']
replace partnerprofit = profit[`partnerid'] in `i'

}

```
where I assume you have a partnerid variable which gives you the observation number of the partner. If your id's do not go in 1,2,3,...,n, however, you may need to do a bit more programming... and probably -merge- is the easiest.
```Nick Cox

```
If the problem is just this, the solution would be gen partnerprofit = profit[5] in 13 In general, think about a -merge-.
```On Behalf Of oezguer.guererk@uni-erfurt.de

```
How can I write the value of the variable called profit for e.g., subject i as the value into another variable called "partnerprofit" of another subject j?
```
```
For example: I am subject 3, my partner is subject 5; his profit is 13, now I would like to stata write in my "partnerprofit" the value 13.
```

*
*   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/
```
```
--
Dr. Özgür Gürerk

Lst. für Mikroökonomie & Laboratorium für experimentelle Wirtschaftsforschung (eLab)
Microeconomics & Laboratory for Experimental Economics (eLab)

```
Universität Erfurt, Nordhäuser Str. 63, D-99089 Erfurt
```Tel: +49 361 7374561
Fax: +49 361 7374569
www.uni-erfurt.de/elab
--

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