Hi.I have to conduct twolevel (2-1-1) analysis where leadership styles will be analysed at group level and mediators and dependent variable at individual level. My data has 358 observations for leadership, mediators collected from employees and 61 managers have rated the performance of employees in 61 teams. I have to aggregate those 358 observation on leadership and mediators to 61 teams. If I entered my data as it is like 358 observations and 61 observations for performance, MPLus gives me an error of having missing data. How can I aggregate my data? or what command should I write?
Hi Related to the above post on data aggregation, As employees filled questionnaire on leadership and mediators giving 358 observations, I also collected data on their age gender tenure education which reflect values of 358 respondents. My questions is if I aggregate the values of IV and mediators having 358 observations to 61 then how can this new aggregated data match with data on age gender education and tenure which will still reflect values given by 358 respondents. I want age gender education to be control variables in the model. Is it possible to run analysis in this way or do I need to aggregate these control variables too?