Hello,
I've created a dataset to analyze differences in NC test scores due to COVID-19. I currently have it set up so each observation has a year, school, test name, and score. I'm trying to create another variable, Difference, that generates the difference in scores from 2020 to 2019, but the difference for the same test at the same school (so long as Year==2020, it will only appear under 2020 observations which is okay with me).
I cannot quite figure out how to do this. I have python experience and would create a dictionary if I was using python, but I'm not sure how to do the equivalent on state. I saw a command that used PanelID, but am not sure if its applicable in my situation. Can anyone help?
I've created a dataset to analyze differences in NC test scores due to COVID-19. I currently have it set up so each observation has a year, school, test name, and score. I'm trying to create another variable, Difference, that generates the difference in scores from 2020 to 2019, but the difference for the same test at the same school (so long as Year==2020, it will only appear under 2020 observations which is okay with me).
I cannot quite figure out how to do this. I have python experience and would create a dictionary if I was using python, but I'm not sure how to do the equivalent on state. I saw a command that used PanelID, but am not sure if its applicable in my situation. Can anyone help?
Comment