On August 1, 2020, I wrote:
I am analyzing questionnaire information from two individual data files for my dissertation. The first data file (N=944) contains school, school principal, and head school counselor information. The second data file (N=26,150) contains student, parent, and teacher information. Both data files have school id, stratum, and primary sampling unit (PSU) in common. Neither "match cases on key variables" nor "cases are sorted in order of key variables in both data sets" populated when the usual merging data techniques were applied.
Thank you to all who replied.
I have a second question regarding these data sets and my quantitative study. Each administrator questionnaire item is answered differently for the 20 students from their individual schools. Rather than analyze the data from the student level (as it is currently set up), I believe that I must first convert the data to the school level. I know that means are involved. However, since "match cases on key variables" and "cases are sorted in order of key variables in both data sets" did not populate in SPSS, I am not sure how to proceed.
As I understand you want to match two files. If so, you can use school id as key id and merge files in spss or excel. Here is an video for this: https://www.youtube.com/watch?v=yACxsqiMAQo
Thank you for your suggestion. I've applied this video for the merging part of my question. However, it does not address how I might convert the student-level data to school-level data.
It sounds like you have a case of multi-level modeling (also known as hierarchical linear modeling). A good textbook on this kind of analysis is Hierarchical Linear Models Applications and Data Analysis Methods by Raudenbush and Bryck
- Badges
- Science topic