Family Data » Creating Parent Files with One Record Per Respondent »

The 1992 PARENTS distribution file contains two or four records per household with information about a mother or father, and, for households with a married (or partnered) couple, a mother-in-law or father-in-law. As identifiers this file contains HHID (HOUSEHOLD IDENTIFIER), PN (PERSON NUMBER), and ATYPEPAR (MOM OR DAD).

In order to create the standardized file, two records, a mother record and a father record, will need to be combined into a single parent record. The mother variables and father variables will need distinct names, or locations, in the output file. The steps required to create the standardized parents file are described below (Overview Flowchart).

Step 1:     Sort PARENTS File

The 1992 PARENTS file has up to four records per household:

  1. mother of Section E respondent,

  2. father of Section E respondent,

  3. mother of spouse/partner of Section E respondent, and

  4. father of spouse/partner of Section E respondent.

Sort the PARENTS file by HHID and PN. The output file will have 25,444 records and fifty-four variables.

Step 2:      Create File with Mother Records

Create a file including only mother records. Select records where ATYPEPAR equals 1. Rename these variables:  V8201- V8224, V18205-V18211, and V18213-V18224, e.g., V8201=V8201M. Keep these identification variables: HHID PN ASUBHH APN_SP AFAMR AFINR V1 V2 V3 and these renamed variables: V8201- V8224, V18205-V18211, and V18213-V18224; do not keep ATYPEPAR.  The output file will have 12,722 records and fifty-two variables.

Step 3:      Create File with Father Records

Create a file including only father records. Select records where ATYPEPAR equals 2. Create father variables using an analogous procedure to that used to create mother variables, e.g., rename variables V8201=V8201F. The output file will have 12,722 records and fifty-two variables.

Step 4:      Merge Mother and Father Files to Create Respondent-level File with Information about Each Parent

Merge these two files by HHID and PN to create a parents-level file; this is a one-to-one match, both input files will have 12,722 records. The output file will have 12,722 records and ninety-five variables.

Step 5:      Inspect Output Records

The variables in the first twenty-five records in this file should look something like this the listing provided below.

Note that for households consisting of a married (or partnered) pair of respondents, if only one of the respondents provided an interview, APN_SP will not have a value and AFAMR will only have a valid value for the respondent who provided a 1992 interview. See HHID 010075 in the listing below for an example.

                          Listing of 1992 Parents File

      Obs HHID   PN  AFAMR APN_SP V8201M V8202M V8208M V8201F V8202F V8208F

        1 000001 010   1            1      1     1991    1      2     1965
        2 000002 010   1            1      1     1988    1      2     1988
        3 000003 010   5    020     2      1     1987    2      2     1962
        4 000003 020   1    010     1      1     1964    1      2     1968
        5 010001 010   1            1      1     1991    1      2     1965
        6 010003 020   5    030     2      1     1990    2      2     1972
        7 010003 030   1    020     1      1        .    1      2        .
        8 010004 010   5    040     2      1        .    2      2        .
        9 010004 040   1    010     1      1        .    1      2     1952
       10 010013 010   5    040     2      1     1953    2      2     1971
       11 010013 040   1    010     1      1        .    1      2     1971
       12 010038 010   5    040     2      1     1960    2      2     1973
       13 010038 040   1    010     1      1        .    1      2     1973
       14 010050 010   1            1      1        .    1      2     1982
       15 010059 020   1    030     1      1     1969    1      2     1979
       16 010059 030   5    020     2      1     1975    2      2     1975
       17 010063 010   1            1      1     1938    1      2     1972
       18 010075 020   1            1      1        .    1      2     1973
       19 010075 030   .            2      1        .    2      2     1973
       20 010083 010   .            2      1        .    2      2        .
       21 010083 020   1            1      1        .    1      2        .
       22 010090 010   1            1      1        .    1      2     1982
       23 010094 010   1            1      1     1961    1      2        .
       24 010097 010   5    040     2      1        .    2      2        .
       25 010097 040   1    010     1      1        .    1      2        .

Top

Overview Flowchart

Sample code in SAS, SPSS, or Stata is available.



Top

Copyright © 2014 The Regents of the University of Michigan