Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Need help with transforming dataset, please
From
Bidemi Carrol <[email protected]>
To
[email protected]
Subject
st: Need help with transforming dataset, please
Date
Tue, 26 Feb 2013 00:18:19 +0000
Hi Stata People
I just joined this community, and I am hoping someone can help with my issue.
I would appreciate some help with transforming the dataset below.
Reshape does not seem to work, but I may be applying it wrong.
The original dataset is as follows (with many more grade and subject
combinations):
StudId Gender Subject1 Grade1 Subject2 Grade2 Subject3 Grade3
Subject4 Grade4
121 F MATH 3 ENGLISH 4 GEOG 5
FRENCH 5
122 F ENGLISH 4 GEOG 5 MATH 5
123 M FRENCH 2 ENGLISH 3 MATH 1
GEOG 3
124 M GEOG 1 MATH 2 ENGLISH 2
I would like it to look like this:
StudID Gender Math English French Geog
121 F 3 4 5 5
122 F 5 4 5
123 M 1 3 2 3
124 M 2 2 1
Thanks for any help you can provide.
Cheers
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/