Helen,
Look into the MATCH FILES command because this looks like a merging
(adding variables) issue.
Before you can successfully merge the student and teacher data sets,
both of them should be sorted by the KEY variable(s) for matching,
probably the teacher ID in your case.
Something like this will work.
MATCH FILES TABLE = 'your teacher data set'
/FILE = 'your student data set'
/BY <your key variable for matching most likely your
teacher id>.
SAVE OUTFILE 'name of combined data'.
Best regards,
Florio
At 02:43 PM 9/4/2007, Helen Garnier wrote:
>Hello everyone,
> I have a question regarding teacher- and student-level datafiles. I am
>working with SPSS for Windows, v11.5. I can easily aggregate the student
>data to the teacher data using the AGGREGATE command in order to run
>analyses at the teacher level. I would like to replicate or repeat the
>teacher data for each of the teacher's students to work at the student
>level. Is there a command, like AGGREGATE, that will allow me to do that in
>SPSS? What is the syntax I would need to use to replicate teacher variables
>for each student in that class?
>Thank you for your help,
>Helen
Locked
