Hi all,
I am doing an OLS regression and would like to include three fixed effects into my model. The table below shows the variables I plan to include in my model. Column 2 is my dependent variable, columns 3-4 are my independent variables, and columns 5-7 are my variables I would like to include as fixed effects. (Note: the table is not representive of my data set and I just attached it to illustrate what I am trying to do). Without the fixed effects my do-file is the following: regress Dependent_Variable Independent_Variable1 Independent_Variable2. Now I would also like to include the fixed effects into the model. I have used the following code: regress Dependent_Variable Independent_Variable1 Independent_Variable2 i.Year i.Organisation i.City.
I would like to get one number, which is aggregated over all my fixed effects. At the moment, I get a separate line for each value of my variables in columns 5-7. Does anyone know how to solve this issue?
Thank you for your help!
I am doing an OLS regression and would like to include three fixed effects into my model. The table below shows the variables I plan to include in my model. Column 2 is my dependent variable, columns 3-4 are my independent variables, and columns 5-7 are my variables I would like to include as fixed effects. (Note: the table is not representive of my data set and I just attached it to illustrate what I am trying to do). Without the fixed effects my do-file is the following: regress Dependent_Variable Independent_Variable1 Independent_Variable2. Now I would also like to include the fixed effects into the model. I have used the following code: regress Dependent_Variable Independent_Variable1 Independent_Variable2 i.Year i.Organisation i.City.
I would like to get one number, which is aggregated over all my fixed effects. At the moment, I get a separate line for each value of my variables in columns 5-7. Does anyone know how to solve this issue?
Thank you for your help!
ID | Dependent_variable | Independent_Variable1 | Independent_Variable2 | Year | Organisation | City |
1 | 1 | 32 | 44 | 1990 | 1 | 1 |
2 | 37 | 9 | 98 | 1991 | 1 | 2 |
3 | 23 | 14 | 71 | 1995 | 2 | 2 |
4 | 43 | 50 | 11 | 1993 | 3 | 3 |
5 | 23 | 53 | 31 | 1998 | 3 | 4 |
6 | 37 | 31 | 42 | 2000 | 3 | 5 |
7 | 9 | 6 | 84 | 1991 | 4 | 6 |
8 | 63 | 44 | 34 | 1995 | 5 | 7 |
9 | 78 | 34 | 77 | 1993 | 6 | 7 |
Comment