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!
0 Response to Confusion about how to keep students in the right courses in the right level
Post a Comment