<>
Where in your dataset is this variable "lister" that you condition on in the
loop? And where do you actually fill the "matchedname" variable whose
contents you complain about?
HTH
Martin
_______________________
----- Original Message -----
From: "Li, Ihsuan" <[email protected]>
To: <[email protected]>
Sent: Monday, March 23, 2009 10:00 PM
Subject: st: loop code problem
Hi statalisters:
I can't figure out the correct coding to create a new variable
"matchedname". My data was retrieved using propensity score matching
technique and it returned _id which is unique to each firm. Each firm also
has an unique cusip number. The first three firms (atna, Sealaska, and
aleut) were matched to three other firms (petrox, Oregon, and ripley). I
know that from the _n1 column, which lists the matched company's
particular id.
What I am trying to do is create string variable "matchedname" that lists
the names of the three firms that were matched to the first three
observations.
Example of my data:
Firm cusip _n1 _id matchedname
atna 100 2569 9521
sealaska 101 4526 9823
aleut 104 325 357
petrox 10001 . 2569
oregon corp 10002 . 4526
ripley 10003 . 325
I tried the following code, and it returned the same _n1 on the
matchedname column instead:
. gen matcheri=.
(6 missing values generated)
. gen matcherj=.
(6 missing values generated)
. gen matchernum=.
(6 missing values generated)
. forvalues i=1(1) 6 {
2. forvalues j=`i'(1) 6 {
3. replace matcheri=1 in `i' if lister[`i']== id[`j'] & lister[`i']!=. &
id[`j'] !=.
4. replace matcherj=1 in `j' if lister[`i']== id[`j'] & lister[`i']!=. &
id[`j'] !=.
5. replace matchernum=lister[`i'] if lister[`i']== id[`j'] &
lister[`i']!=. & id[`j'] !=.
6. }
7. }
What is wrong with this code?
Thanks in advance.
Ihsuan
*
* 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/
*
* 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/