Saturday, Jul 5
Tutorials | Overview | User Guide | FAQ | Contact/Help | News | Data Quality | File Structure | CDS R/D | Sponsorship | More...

Merging PSID Data: SPSS Example

Method 1

    *---------------------------------------------------------------------*
    | This example program demonstrates a relatively simple method for    |
    | merging PSID data.  It uses data from 3 different years, subsetting |
    | criteria, and the compress option (to conserve disk space).         |
    *---------------------------------------------------------------------.
    
    * Read in 1990-1992 cross-year individual file and select variables
      needed for analysis. 

    FILE HANDLE IND90_92 / NAME="[FILE SPECIFICATIONS]" LRECL=1888.
    DATA LIST FILE=IND90_92 /
       V30001  1-4
       V30002  5-7
       V30642  1402-1406
       V30643  1407-1408
       V30644  1409-1410
       V30645  1411-1412
       V30653  1426
       V30657  1432-1433
       V30659  1435-1440
       V30689  1513-1517
       V30690  1518-1519
       V30691  1520-1521
       V30692  1522-1523
       V30699  1536
       V30703  1542-1543
       V30705  1545-1550
       V30707  1552-1557
       V30733  1623-1627
       V30734  1628-1629
       V30735  1630-1631
       V30736  1632-1633
       V30744  1647
       V30748  1653-1654
       V30750  1656-1661
       V30752  1663-1668
       V30805  1760-1765 (3)
       V32000  1786
       V32022  1833-1834
       V32049  1885.
    VARIABLE LABELS
       V30001 "1968 INTERVIEW NUMBER 68"
       V30002 "PERSON NUMBER         68"
       V30642 "1990 INTERVIEW NUMBER"
       V30643 "SEQUENCE NUMBER       90"
       V30644 "RELATIONSHIP TO HEAD  90"
       V30645 "AGE OF INDIVIDUAL     90"
       V30653 "EMPLOYMENT STAT       90"
       V30657 "COMPLETED EDUCATION   90"
       V30659 "TOT TXBL INCOME       90"
       V30689 "1991 INTERVIEW NUMBER"
       V30690 "SEQUENCE NUMBER       91"
       V30691 "RELATIONSHIP TO HEAD  91"
       V30692 "AGE OF INDIVIDUAL     91"
       V30699 "EMPLOYMENT STAT       91"
       V30703 "COMPLETED EDUCATION   91"
       V30705 "TOT LABOR INCOME      91"
       V30707 "TOT ASSET INCOME      91"
       V30733 "1991 INTERVIEW NUMBER"
       V30734 "SEQUENCE NUMBER       92"
       V30735 "RELATIONSHIP TO HEAD  92"
       V30736 "AGE OF INDIVIDUAL     92"
       V30744 "EMPLOYMENT STAT       92"
       V30748 "COMPLETED EDUCATION   92"
       V30750 "TOT LABOR INCOME      92"
       V30752 "TOT ASSET INCOME      92"
       V30805 "COMBINED IND WEIGHT   92"
       V32000 "SEX OF INDIVIDUAL"
       V32022 "# BIRTHS OF THIS IND"
       V32049 "LAST KNOWN MARITAL STAT".
    MISSING VALUES
       V30645 (99)
       V30657 (99)
       V30692 (99)
       V30703 (99)
       V30736 (99)
       V30748 (99)
       V32022 (98)
       V32049 (8).
    RENAME VARIABLES
       (V30642=ID90)
       (V30689=ID91)
       (V30733=ID92).
    
    * This example selects those who were ever heads or wives/"wives"
      between 1990 and 1992.  

    SELECT IF (V30643 EQ 01 AND V30644 EQ 10) OR
    (V30643 EQ 02 AND (V30644 EQ 20 OR V30644 EQ 22)) OR
    (V30690 EQ 01 AND V30691 EQ 10) OR
    (V30690 EQ 02 AND (V30691 EQ 20 OR V30691 EQ 22)) OR
    (V30734 EQ 01 AND V30735 EQ 10) OR
    (V30734 EQ 02 AND (V30735 EQ 20 OR V30735 EQ 22)).
    
    * Sort active file by id90.  

    SORT CASES BY ID90.
    SAVE OUTFILE="IND90_92.SYS" / COMPRESS.
    
    * Read in 1990 family file and select variables needed for analysis.
    
    FILE HANDLE FAM90 / NAME="[FILE SPECIFICATIONS]" LRECL=2333.
    DATA LIST FILE=FAM90 /
       V17702  4-8
       V17836  291-296
       V18262  1181-1183
       V18564  1649-1651
       V18814  2035
       V18878  2177-2182
       V18887  2217-2220 (2)
       V18888  2221-2224 (2).
    VARIABLE LABELS
       V17702 "1990 INTERVIEW NUMBER"
       V17836 "WIFE 89 LABOR/WAGE"
       V18262 "C9-10 OCC-LAST JOB (H-U)"
       V18564 "E9-10 OCC-LAST JOB (W-U)"
       V18814 "M32 RACE OF HEAD (1 MEN)"
       V18878 "TOTAL HEAD LABOR Y 89"
       V18887 "HEAD 89 AVG HRLY EARNING"
       V18888 "WIFE 89 AVG HRLY EARNING".
    MISSING VALUES
       V18262 (999)
       V18564 (999)
       V18814 (9).
    RENAME VARIABLES
       (V17702=ID90).
    
    * Sort active file by id90.  

    SORT CASES BY ID90.
    
    * Merge ind90_92.sys and active file by id90. 

    MATCH FILES FILE="IND90_92.SYS" / TABLE=* / BY ID90.
    
    * Sort active file by id91. 

    SORT CASES BY ID91.
    SAVE OUTFILE="FAM_IND.SYS" / COMPRESS.
    
    * Read in 1991 family file and select variables needed for analysis.
    
    FILE HANDLE FAM91 / NAME="[FILE SPECIFICATIONS]" LRECL=2336.
    DATA LIST FILE=FAM91 /
       V19002  4-8
       V19136  291-296
       V19562  1177-1178
       V19864  1177-1178
       V20114  2036
       V20178  2178-2183
       V20187  2218-2221 (2)
       V20188  2222-2225 (2).
    VARIABLE LABELS
       V19002 "1991 INTERVIEW NUMBER"
       V19136 "WIFE 90 LABOR/WAGE"
       V19562 "C9-10 OCC-LAST JOB (H-U)"
       V19864 "E9-10 OCC-LAST JOB (W-U)"
       V20114 "L32 RACE OF HEAD (1 MEN)"
       V20178 "TOTAL HEAD LABOR Y 90"
       V20187 "HEAD 90 AVG HRLY EARNING"
       V20188 "WIFE 90 AVG HRLY EARNING".
    MISSING VALUES
       V19562 (999)
       V19864 (999)
       V20114 (9).
    RENAME VARIABLES
       (V19002=ID91).
    
    * Sort active file by id91.  

    SORT CASES BY ID91.
    
    * Merge fam_ind.sys and active file by id91. 

    MATCH FILES FILE="FAM_IND.SYS" / TABLE=* / BY ID91.
    
    * Sort active file by id92.  

    SORT CASES BY ID92.
    SAVE OUTFILE="FAM_IND.SYS" / COMPRESS.
    
    * Read in 1992 family file and select variables needed for analysis.
    
    FILE HANDLE FAM92 / NAME="[FILE SPECIFICATIONS]" LRECL=2347.
    DATA LIST FILE=FAM92 /
       V20302  4-8
       V20436  291-296
       V20862  1189-1191
       V21164  1657-1659
       V21420  2049
       V21484  2191-2196
       V21493  2231-2234 (2)
       V21494  2235-2238 (2).
    VARIABLE LABELS
       V20302 "1992 INTERVIEW NUMBER"
       V20436 "WIFE 91 LABOR/WAGE"
       V20862 "C9-10 OCC-LAST JOB (H-U)"
       V21164 "E9-10 OCC-LAST JOB (W-U)"
       V21420 "M32 RACE OF HEAD (1 MEN)"
       V21484 "TOTAL HEAD LABOR Y 91"
       V21493 "HEAD 91 AVG HRLY EARNING"
       V21494 "WIFE 91 AVG HRLY EARNING".
    MISSING VALUES
       V20862 (999)
       V21164 (999)
       V21420 (9).
    RENAME VARIABLES
       (V20302=ID92).
    
    * Sort active file by id92. 

    SORT CASES BY ID92.
    
    * Merge fam_ind.sys and active file by id92.  

    MATCH FILES FILE="FAM_IND.SYS" / TABLE=* / BY ID92.
    SAVE OUTFILE="FAM_IND.SYS" / COMPRESS.
 



Institute for Social Research | University of Michigan | Privacy | Conditions of Use