 |
 |
Saturday, Jul 5
|
|
|
|
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
|
