I have a dataset with the following format:
X Y Z
1 12 2.5
1 3 3.4
1 7 8.9
2 18 0.9
2 6 1.9
2 11 3.7
3 5 1.2
3 19 4.5
3 8 5.6
I want to reshape it as follows:
X Y1 Z1 Y2 Z2 Y3 Z3
1 12 2.5 3 3.4 7 8.9
2 18 0.9 6 1.9 11 3.7
3 5 1.2 19 4.5 8 5.6
I know I need to use reshape command. But don't know
how. Can anyone please help? Thanks a lot.
Mazhar
+-------------------------+
| gstn comp distance |
|-------------------------|
1. | 4 105 7174.6529 |
2. | 4 52 9432.1751 |
3. | 4 55 9760.1456 |
4. | 4 59 10351.248 |
5. | 4 57 10590.998 |
|-------------------------|
6. | 5 691 8421.3531 |
7. | 5 111 8912.8855 |
8. | 5 109 9413.6016 |
9. | 5 7 10006.499 |
10. | 5 110 10485.966 |
|-------------------------|
11. | 7 10 5240.1692 |
12. | 7 9 7148.0657 |
13. | 7 501 8312.9357 |
14. | 7 8 8761.7633 |
15. | 7 494 11348.099 |
____________________________________________________
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football
http://football.fantasysports.yahoo.com
*
* 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/
