Hi,
The 'gen draft...' method works perfectly.
It seems like the first method with 'levels' is only for version 8 of
stata? It get the error message; version 8 not supported...
Thank you very much for your help, Nick!
Best regards,
Alexander Severinsen
-----Opprinnelig melding-----
Fra: [email protected]
[mailto:[email protected]] P� vegne av Nick Cox
Sendt: 11. april 2003 11:41
Til: [email protected]
Emne: st: RE: Making symmetry
Alexander
>
> I have 2 ID-variables:
>
> Id1 Id2
> 1 1
> 2 3
> 3 5
> 4 .
> 5 .
>
> And I want the variabels to be symmetric in relation to ID1
>
> Like this:
>
> Id1 Id2
> 1 1
> 2 .
> 3 3
> 4 .
> 5 5
This will work if the number of distinct
levels in -Id2- is modest:
ssc inst levels
levels Id2
replace Id2 = .
foreach l of local levels {
qui replace Id2 = `l' if Id1 == `l'
}
Slow but sure with arbitrarily large data sets:
gen draft = .
forval i = 1 / `=_N' {
qui replace draft = Id2[`i'] if Id1 == Id2[`i']
}
replace Id2 = draft
Nick
[email protected]
*
* 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/
*
* 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/
