I am trying to estimate the impact of the percent of tenured faculty at universities on the student retention rate. I am using data from IPEDs for the retention rate, proportion of tenured faculty, student-to-faculty ratio, and SAT scores. Each of these variables has a different variable for each year, for example, I have retention rate 2014, retention rate 2015, etc and S-T-F 2014, 2015, etc. The data has each variable for every year listed by school in one line; it is not broken down by year. I want to run a fixed effects model for 2014-2019, accounting for institutional and year fixed effects. However, because there is no year variable in the data and each school is coded once with every variable for every year, I am not sure how to generate a year variable that assigns each variable to the appropriate year in order to generate year fixed effects.
How do you generate a year variable that aligns with particular variables (ex year2018 should be associated with retention rate 2018, SAT 2018, tenure 2018, etc)? How can I use data set up in this manner to see the impact of tenure on student retention with multiple years of data?
How do you generate a year variable that aligns with particular variables (ex year2018 should be associated with retention rate 2018, SAT 2018, tenure 2018, etc)? How can I use data set up in this manner to see the impact of tenure on student retention with multiple years of data?
Comment