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
Limitation of arguments in mataCheers together, currently, I am trying to find the internal rate of return or cost of equity for c…
xtreg Y X1 X2...Xn i.country, fe- Is it possible/ correct/ feasible?Declared panel data as xtset year (instead of xtset panelid year) xtset YEAR panel variable: YEAR (…
wildcard in string variableI'm trying to link different business locations to appropriate zip codes using a do-file. I have bus…
How to import several excelsDear Statalist, I need to create a database using several (hundreds) of excels like the one I show …
How to organise my data, Im a beginner!Hi I would like to know what commands to use to organise my data, I currently have a dataset with ov…
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