Hello everyone,
Im working with a dataset that includes 2 levels of data: individual level data and schools level data. I created school level variables using individual level observations. For example, i have something like this:
Now, i just need the school information variables, because i need to merge 5 datasets with information of different years, i created all the variables using egen. I think collapse can be helpful, but that means i have to create all the variables again(it is a lot of work). theres something i can do to get a table like this?
Thank you very much, im sorry if my english is not very good.
Im working with a dataset that includes 2 levels of data: individual level data and schools level data. I created school level variables using individual level observations. For example, i have something like this:
School_ID | Ind_ID | Math_score | mean_school_math_score | |
1 | 1 | 100 | 93.6 | |
1 | 2 | 90 | 93.6 | |
1 | 3 | 91 | 93.6 | |
2 | 4 | 90 | 90.6 | |
2 | 5 | 95 | 90.6 | |
2 | 6 | 87 | 90.6 | |
3 | 7 | 100 | 92 | |
3 | 8 | 86 | 92 | |
3 | 9 | 90 | 92 |
School_ID | Mean_school_math_score |
1 | 93.6 |
2 | 90.6 |
3 | 92 |
Comment