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
Xtlogit correctly predictedDear stat users, I am interested in calculating the correctly called event, false alrams, specifity…
Interpretation of outputDear all, I just started using STATA hence I need help in interpreting an output. Is the P-value in…
Are there any assumptions for npregress?Hi, I am working on an abstract. I want to build model for continuous outcome variable (not normall…
Fixed effects models with instrumental variables and bootstrapped standard errors within clustersI'm trying to run some panel data, and the way the sampling occurred I should bootstrap the standard…
Better looking window (resolution)Dear all, I was wondering if there is a way to increase the resolution of the whole Stata screen, i…
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