Dear Statalist,
I am using Stata/SE 11 for Windows to try to change the place of
observations in editor.
From
group1 result1 group2 result2
1 1 0 0
1 0 0 1
1 1 0 0
1 0 0 1
1 1 0 0
To
group result
1 1
1 0
1 1
1 0
1 1
0 0
0 1
0 0
0 1
0 0
I wrote a do file to conduct this change as below.
-----------------------------------------------
clear
foreach var in ///
group1 result1 group2 result2 {
gen `var'=.
}
set obs 5
replace group1=1
replace group2=0
replace result1=1 in 1
replace result1=0 in 2
replace result1=1 in 3
replace result1=0 in 4
replace result1=1 in 5
replace result2=0 in 1
replace result2=1 in 2
replace result2=0 in 3
replace result2=1 in 4
replace result2=0 in 5
preserve
drop group2 result2
rename group1 group
rename result1 result
save groupresult.dta,replace
restore
drop group1 result1
rename group2 group
rename result2 result
append using groupresult.dta
--------------------------------------------------
But I would like to know how can I do it more simple way, without making
dta.file.
Can someone help me with this?
Regards,
Ichiro
*
* 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/