Try
. reshape wide weight cost, i(Accidentnr vehiclenr)
Lina Jonsson
I have a dataset concerning accidents involving two vehicles that I have
in two formats, wide and long like this:
long:
Accidentnr vehiclenr weight cost
1 0 1000 35000
1 1 1500 150000
2 0 1200 150000
2 1 1700 750000
wide:
Accidentnr weight0 weight1 cost0 cost1
1 1000 1500 35000 150000
2 1200 1700 150000 750000
Now I whould like to transform the data to a long format but with
information also concering the other vehicle involved in each accident
like this:
Accidentnr vehiclenr ownweight othersweight owncost
otherscost
1 0 1000 1500
35000 150000
1 1 1500 1000
150000 35000
2 0 1200 1700
150000 750000
2 1 1700 1200
750000 150000
*
* 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/
