Stata 15.1
I have a list of students who are taking certain courses. Some of the courses have level 1, 2, 3, or 4. Right now, if a student is in a course that has more than 1 level, it appears that they have taken that course many times when it should only show up once. I want to put them in the right course and level.
Example 1:
Variables: Student, course, level
Student A, course 2000, level 1
Student A, course 3000, level 1
Student A, course 3000, level 2
Student A, course 3000, level 3
Student A, course 3000, level 4
Student A, course 4000, level 2
I would like my final data set to look like this:
Student A, course 2000, level 1
Student A, course 3000, level 3
Student A, course 4000, level 2
Example 2:
Variables: Student, course, level
Student B, course 3000, level 1
Student B, course 3000, level 2
Student B, course 3000, level 3
Student B, course 3000, level 4
Student B, course 4000, level 3
I would like my final data set to look like this:
Student B, course 3000, level 1
Student B, course 4000, level 3
Should I be using bysort, egen command? What command is there for sequencing or ordering of observations by course and level? Any guidance would be great!
Related Posts with Confusion about how to keep students in the right courses in the right level
.sav to .dta on MP 17Hi, I am trying to efficiently convert sav to dta, and I have been trying to do so in R, but some o…
Contract variables with statistics of another variable, or combination of contract and collapseDear Stata users, My following question may be easy but I could not find a direct command to achiev…
İnteresting Problem About Xtbunitroot test (Karavias and Tzavalis (2014)ı have N:12 T:31 panel data. ı am researching agriculture subsideies how to effect inputs costs. I w…
New package sscpax on SSCThanks once again to Kit Baum, a new package sscpax is now available for download from SSC. In Stata…
Saving option within a programDear All, I have the following rough code (it needs further amendements): Code: capture program …
Subscribe to:
Post Comments (Atom)
0 Response to Confusion about how to keep students in the right courses in the right level
Post a Comment