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

Creating 2000, 1998, or 1996 Parent Files with One Record Per Respondent

In 1996, 1998, and 2000 Section D parent information was asked of the designated family respondent. She (or he) provided information about her (or his) mother, father and, if married or partnered, mother-in-law and father-in-law. These variables are distributed in a household-level file, which contains the PN of the family respondent and of the non-family respondent, if any.

In order to create the standardized file, up to two records will need to be generated from this record with the parent variables and parent-in-law variables in a standard output position. The appropriate value will need to be assigned to the PN and xPN_SP variables from xPN_FAM or xPN_NFAM (where x represents the yearís prefix: 2000=G, 1998=F, 1996=E). The steps required to create the standardized parents file for any of these years are described in detail below using 2000 as an example (Overview Flowchart).

Step 1: Create a File with Parent Information for the Family Respondentís Parents

Create a file containing parent information about the family respondentís parents. Select records from the Section D household-level file, H00D_H, where GPN_FAM is not null. Assign PN the value of GPN_FAM and GPN_SP the value of GPN_NFAM.  Keep identification variables (HHID, PN) and parent variables of interest.  See the appropriate Parent to Parent-in-Law Variable Cross-Reference Table for a listing of parent and equivalent parent-in-law variables in 2000, 1998, and 1996. Variables that do not have equivalents are designated as "NOT ASKED" in these tables.

Step 2: Create a File with Parent Information for the Non-Family Respondentís Parents

Create a file containing parent information about the non-family respondentís parents.  Select records from the Section D household-level file, e.g., H00D_H, where GPN_NFAM is not null.  Assign PN the value of GPN_NFAM and GPN_SP the value of GPN_FAM. Copy the parent-in-law variables to output (parent) variables. Keep identification variables (HHID, PN) and parent variables of interest.

Step 3: Combine these Two Files

Concatenate the two files created in steps 1 and 2 above.  Sort the resulting file by HHID and PN.

Step 4: Inspect Output Records

The values of the variables in the first 20 records in the resulting files will look something like this.

                      Listing of 2000 Parents File

        Obs    HHID      PN     GPN_SP    GSUBHH    G2122    G2132

          1    000002    010                0         .        .
          2    000003    010     020        0         .        .
          3    000003    020     010        0         .        .
          4    010001    010                0         .        .
          5    010003    030                0         .        1
          6    010004    010     040        0         1        .
          7    010004    040     010        0         1        .
          8    010013    010                2         .        .
          9    010013    040                1         1        .
         10    010038    010     040        0         .        .
         11    010038    040     010        0         5        .
         12    010050    010                0         1        .
         13    010059    020     030        0         .        .
         14    010059    030     020        0         .        .
         15    010075    020     030        0         5        .
         16    010075    030     020        0         5        .
         17    010083    010     020        0         1        .
         18    010083    020     010        0         .        5
         19    010097    040                0         1        .
         20    010109    030                0         .        .

                      Listing of 1998 Parents File

        Obs    HHID      PN     FPN_SP    FSUBHH    F1906    F1916

          1    000002    010                0         .        .
          2    000003    010     020        0         .        .
          3    000003    020     010        0         .        .
          4    010001    010                0         .        .
          5    010003    020     030        0         5        5
          6    010003    030     020        0         .        1
          7    010004    010     040        0         1        .
          8    010004    040     010        0         1        .
          9    010013    010                2         .        .
         10    010013    040                1         1        .
         11    010038    010     040        0         .        .
         12    010038    040     010        0         1        .
         13    010050    010                0         1        .
         14    010059    020     030        0         .        .
         15    010059    030     020        0         .        .
         16    010075    020     030        0         1        .
         17    010075    030     020        0         1        .
         18    010083    010     020        0         1        5
         19    010083    020     010        0         5        8
         20    010097    040                0         1        5

                      Listing of 1996 Parents File

      Obs    HHID      PN     EPN_SP    ESUBHH    E1557_1    E1566_1

        1    000002    010                0          .          .
        2    000003    010     020        0          .          .
        3    000003    020     010        0          .          .
        4    010001    010                0          .          .
        5    010003    020     030        0          .          .
        6    010003    030     020        0          5          1
        7    010004    010     040        0          1          5
        8    010004    040     010        0          1          .
        9    010013    010                2          .          .
       10    010013    040                1          1          .
       11    010038    010     040        0          .          .
       12    010038    040     010        0          1          .
       13    010050    010                0          1          .
       14    010059    020     030        0          .          .
       15    010059    030     020        0          .          .
       16    010063    010                0          .          .
       17    010075    020     030        0          1          .
       18    010075    030     020        0          1          .
       19    010083    020                0          1          8
       20    010097    040                0          1          1


Top

Overview Flowchart

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



Top

Copyright © 2014 The Regents of the University of Michigan