st: reshape

["Richard Pitman" <richard.pitman@oxfordoutcomes.com>]

I have data in the following format:

ID	A	B	C
1	a	x	3
1	a	y	2
1	b	z	10
2	a	x	4
2	a	y	7
2	b	z	11
3	a	x	14
3	a	y	10
3	b	z	6

And would like to convert it to

ID	Cax	Cay	Caz	Cbx	Cby	Cbz
1	3	2				10
2	4	7				11
3	14	10				6

But am unclear how to achieve this.

Any pointers gratefully received

TIA

Richard Pitman

*
*   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/