Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

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!

Nick Cox schrieb:
Tim is correct; thanks! Nick
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

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:

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

*   For searches and help try:

© Copyright 1996–2016 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index