Look at reshape. It may be similar to:
Reshape wide x i(ID) j(Pain)
________________________
Steven W. Bradley
Doctoral Student
Management Department
Kelley School of Business
Indiana University
[email protected]
812.855.1953
_________________________
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Jeff
NASTERNAK
Sent: Thursday, September 01, 2005 4:14 PM
To: [email protected]
Subject: st: transposing data
hi,
I am using version 6 and am a new user.
I have data in the form:
ID Pain
1 10
1 5
1 6
2 3
2 1
2 5
would like the data in the following form:
ID Pain1 Pain2 Pain3
1 10 5 6
2 3 1 5
thank you for your help.
Jeff
*
* 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/