Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: RE: RE: RE: Writing the value of a variable in another variable in a selective way
From 
 
Nick Cox <[email protected]> 
To 
 
"'[email protected]'" <[email protected]> 
Subject 
 
st: RE: RE: RE: Writing the value of a variable in another variable in a selective way 
Date 
 
Wed, 1 Jun 2011 11:01:42 +0100 
Tim is correct; thanks! 
Nick 
[email protected] 
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 [email protected]
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/