* * example of attaching spouse's characteristics GET FILE='C:\temp\ruggl212.sav' /KEEP=YEAR SERIAL SPLOC OCC1950 /RENAME (SPLOC=PERNUM)(OCC1950=SPOCC) . select if (PERNUM>0). SORT CASES BY YEAR, SERIAL, PERNUM . MATCH FILES TABLE=* /FILE='C:\temp\ruggl212.sav' /BY YEAR SERIAL,PERNUM . execute. * * example of using aggrgate on characteristics of children GET FILE='C:\temp\ruggl212.sav' /KEEP=year SERIAL MOMLOC AGE /RENAME (MOMLOC=PERNUM) . select if (AGE<10 & PERNUM>0). SORT CASES BY YEAR, SERIAL, PERNUM. AGGREGATE /OUTFILE='C:\temp\agrkids.sav' /BREAK=year serial pernum /NCHLT10 = NU(year). MATCH FILES TABLE='C:\temp\agrkids.sav' /FILE='C:\temp\ruggl212.sav' /BY year serial pernum . execute.