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
How to remove (horizontal) blue lines when using coefplotI am using coefplot in Stata and I wanted to ask if anyone in this forum knows how to remove the (ho…
Using margins, test, and lincom to test hypothesis that two predictive values are equalHi, I'm trying to do something that should be easy but I'm not certain I am doing it/interpreting th…
how to use an asterisk(*) for multiple variables with an "if" conditionDear all, i have an issues which iam trying to figure out but i am not getting anywhere and i need u…
Consideration on the Expand command : Rename a duplicated observationHi everyone, I am a neophyte on Stata, I don't think this question is complicated but in the help co…
Persistent class objects with ado programsI'm attempting to create an -ado- program whose purpose is to create an instance of a class and then…
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