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

SPSS Code for:  [2000] [1998] [1996] [1994] [1992]

Respondent Record with Mother and Father Variables: 2000

Note: Modify variable list as needed; for a listing of parent (and equivalent parent-in-law) variables consult the 2000 Parent to Parent-in-Law Variables Cross-Reference Table .

/*  STEP 1:  PARENT INFORMATION FOR FAMILY RESPONDENTS' PARENTS
GET FILE "C:\HRS2000\SPSS\H00D_H.sav".
STRING   PN (A3)
         GPN_SP (A3).

USE ALL.
SELECT IF (GPN_FAM NE '').

COMPUTE PN  =GPN_FAM.
COMPUTE GPN_SP=GPN_NFAM.

SORT CASES BY HHID (A) PN (A).
/*  KEEP PARENT VARIABLES OF INTEREST
SAVE OUTFILE='c:\temp\FAMR.sav'/ keep=HHID PN GPN_SP GSUBHH
                                      G2122 G2132.
EXECUTE.

/*  STEP 2:  PARENT INFORMATION FOR NON-FAMILY RESPONDENTS' PARENTS
GET FILE "C:\HRS2000\SPSS\H00D_H.sav".

STRING   PN (A3)
         GPN_SP (A3).

USE ALL.
SELECT IF (GPN_NFAM NE '').

COMPUTE PN  =GPN_NFAM.
COMPUTE GPN_SP=GPN_FAM.

/*  copy parent-in-law variables to output variables locations
COMPUTE G2122=G2309.
COMPUTE G2132=G2319.

SORT CASES BY HHID (A) PN (A).
/*  KEEP PARENT VARIABLES OF INTEREST
SAVE OUTFILE='c:\temp\NFAMR.sav'/ keep=HHID PN GPN_SP GSUBHH
                                      G2122 G2132.
EXECUTE.

/*  STEP 3:  CONCATENATE TWO PARENT FILES
MATCH FILES
/FILE="c:\temp\FAMR.sav"
/FILE="c:\temp\NFAMR.sav"
/BY HHID PN.
SAVE OUTFILE='c:\temp\PARENTS.sav'.

Respondent Record with Mother and Father Variables: 1998

Note: Modify variable list as needed; for a listing of parent (and equivalent parent-in-law) variables consult the 1998 Parent to Parent-in-Law Variables Cross-Reference Table .

/*  STEP 1:  PARENT INFORMATION FOR FAMILY RESPONDENTS' PARENTS
GET FILE "C:\HRS1998\SPSS\H98D_H.sav".

STRING   PN (A3)
         FPN_SP (A3).

USE ALL.
SELECT IF (FPN_FAM NE '').

COMPUTE PN  =FPN_FAM.
COMPUTE FPN_SP=FPN_NFAM.

SORT CASES BY HHID (A) PN (A).
/*  KEEP PARENT VARIABLES OF INTEREST
SAVE OUTFILE='c:\temp\FAMR.sav'/ keep=HHID PN FPN_SP FSUBHH
                                      F1906 F1916.
EXECUTE.

/*  STEP 2:  PARENT INFORMATION FOR NON-FAMILY RESPONDENTS' PARENTS
GET FILE "C:\HRS1998\SPSS\H98D_H.sav".

STRING   PN (A3)
         FPN_SP (A3).

USE ALL.
SELECT IF (FPN_NFAM NE '').

COMPUTE PN  =FPN_NFAM.
COMPUTE FPN_SP=FPN_NFAM.

/*  copy parent-in-law variables to output variables locations
COMPUTE F1906=F2068.
COMPUTE F1916=F2078.

SORT CASES BY HHID (A) PN (A).
/*  KEEP PARENT VARIABLES OF INTEREST
SAVE OUTFILE='c:\temp\NFAMR.sav'/ keep=HHID PN FPN_SP FSUBHH
                                      F1906 F1916.
EXECUTE.

/*  STEP 3:  CONCATENATE TWO PARENT FILES
MATCH FILES
/FILE="c:\temp\FAMR.sav"
/FILE="c:\temp\NFAMR.sav"
/BY HHID PN.
SAVE OUTFILE='c:\temp\PARENTS.sav'.

Respondent Record with Mother and Father Variables: 1996

Note: Modify variable list as needed; for a listing of parent (and equivalent parent-in-law) variables consult the 1996 Parent to Parent-in-Law Variables Cross-Reference Table .

/*  STEP 1:  PARENT INFORMATION FOR FAMILY RESPONDENTS' PARENTS
GET FILE "C:\HRS1996\SPSS\H96D_H.sav".

STRING   PN (A3)
         EPN_SP (A3).

USE ALL.
SELECT IF (EPN_FAM NE '').

COMPUTE PN  =EPN_FAM.
COMPUTE EPN_SP=EPN_NFAM.

SORT CASES BY HHID (A) PN (A).
/*  KEEP PARENT VARIABLES OF INTEREST
SAVE OUTFILE='c:\temp\FAMR.sav'/ keep=HHID PN EPN_SP ESUBHH
                                      E1557_1 E1566_1.
EXECUTE.

/*  STEP 2:  PARENT INFORMATION FOR NON-FAMILY RESPONDENTS' PARENTS
GET FILE "C:\HRS1996\SPSS\H96D_H.sav".

STRING   PN (A3)
         EPN_SP (A3).

USE ALL.
SELECT IF (EPN_NFAM NE '').

COMPUTE PN  =EPN_NFAM.
COMPUTE EPN_SP=EPN_NFAM.

/*  copy parent-in-law variables to output variables locations
COMPUTE E1557_1=E1557_2.
COMPUTE E1566_1=E1566_2A.

SORT CASES BY HHID (A) PN (A).
/*  KEEP PARENT VARIABLES OF INTEREST
SAVE OUTFILE='c:\temp\NFAMR.sav'/ keep=HHID PN EPN_SP ESUBHH
                                      E1557_1 E1566_1.
EXECUTE.

/*  STEP 3:  CONCATENATE TWO PARENT FILES
MATCH FILES
/FILE="c:\temp\FAMR.sav"
/FILE="c:\temp\NFAMR.sav"
/BY HHID PN.
SAVE OUTFILE='c:\temp\PARENTS.sav'.

Respondent Record with Mother and Father Variables: 1994

/*  REFORMAT PARENTS FILE TO ONE PER RESPONDENT
GET FILE "C:\HRS1994\SPSS\W2PARS.SAV".

/*  STEP 1: SORT W2PARS FILE
SORT CASES BY HHID (A) PN (A) CSUBHH (A).
SAVE OUTFILE='c:\temp\W2PARS.sav'/COMPRESSED.
EXECUTE.

/*  STEP 2: CREATE FILE WITH MOTHER RECORDS
GET FILE "c:\temp\W2PARS.sav" /keep = CPARCODE
          HHID PN CSUBHH ASUBHH CPN_SP COPN_CS CCSR CFAMR CFINR RPN FAMFLAG
          W8201 W8202 W8203 W8204 W8205 W8206 W8207 W8208 W8209 W8210 W8211
          W8213 W8214 W8215 W8216 W8217 W8218 W8219.

USE ALL.
SELECT IF (CPARCODE EQ '1').

    RENAME variables
    W8201   = W8201M
    W8202   = W8202M
    W8203   = W8203M
    W8204   = W8204M
    W8205   = W8205M
    W8206   = W8206M
    W8207   = W8207M
    W8208   = W8208M
    W8209    = W8209M
    W8210    = W8210M
    W8211    = W8211M
    W8213    = W8213M
    W8214    = W8214M
    W8215    = W8215M
    W8216    = W8216M
    W8217    = W8217M
    W8218    = W8218M
    W8219    = W8219M
    .
SAVE OUTFILE='c:\temp\MOM.sav'/ drop=CPARCODE.
EXECUTE.

/*  STEP 3: CREATE FILE WITH FATHER RECORDS
GET FILE "c:\temp\W2PARS.sav" /keep = CPARCODE
          HHID PN CSUBHH ASUBHH CPN_SP COPN_CS CCSR CFAMR CFINR RPN FAMFLAG
          W8201 W8202 W8203 W8204 W8205 W8206 W8207 W8208 W8209 W8210 W8211
          W8213 W8214 W8215 W8216 W8217 W8218 W8219.

USE ALL.
SELECT IF (CPARCODE EQ '2').

    RENAME variables
    W8201   = W8201F
    W8202   = W8202F
    W8203   = W8203F
    W8204   = W8204F
    W8205   = W8205F
    W8206   = W8206F
    W8207   = W8207F
    W8208   = W8208F
    W8209    = W8209F
    W8210    = W8210F
    W8211    = W8211F
    W8213    = W8213F
    W8214    = W8214F
    W8215    = W8215F
    W8216    = W8216F
    W8217    = W8217F
    W8218    = W8218F
    W8219    = W8219F
    .
SAVE OUTFILE='c:\temp\DAD.sav'/ drop=CPARCODE.
EXECUTE.

/*  STEP 4: CREATE FILE WITH PARENT RECORDS
GET FILE "c:\temp\W2PARS.sav" /keep = CPARCODE
          HHID PN CSUBHH ASUBHH CPN_SP COPN_CS CCSR CFAMR CFINR RPN FAMFLAG
          W8209 W8210 W8211 W8212 W8213 W8214 W8215 W8216 W8217 W8218 W8219.

USE ALL.
SELECT IF (CPARCODE EQ '3').

    RENAME variables
    W8209    = W8209P
    W8210    = W8210P
    W8211    = W8211P
    W8212    = W8212P
    W8213    = W8213P
    W8214    = W8214P
    W8215    = W8215P
    W8216    = W8216P
    W8217    = W8217P
    W8218    = W8218P
    W8219    = W8219P
    .
SAVE OUTFILE='c:\temp\PARENT.sav'/ drop=CPARCODE.
EXECUTE.

/*  STEP 5: MERGE MOTHER FATHER AND PARENT FILES
MATCH FILES
 /FILE="c:\temp\MOM.sav"
 /FILE="c:\temp\DAD.sav"
 /FILE="c:\temp\PARENT.sav"
 /BY HHID PN CSUBHH.
SAVE OUTFILE='c:\temp\PARENTS.sav'.
EXECUTE.

Respondent Record with Mother and Father Variables: 1992

/*  REFORMAT PARENTS FILE FROM ONE PER PARENT TO ONE PER RESPONDENT
GET FILE "C:\HRS1992\SPSS\PARENTS.sav".

/*  STEP 1: SORT PARENTSW FILE
SORT CASES BY HHID (A) PN (A).
SAVE OUTFILE='c:\temp\PARENT1.sav'/COMPRESSED.


/*  STEP 2: CREATE FILE WITH MOTHER RECORDS
GET FILE "c:\temp\PARENT1.sav" /keep = ATYPEPAR
     HHID PN ASUBHH APN_SP AFAMR AFINR V1 V2 V3
     V8201 V8202 V8203 V8204 V8205 V8206 V8207
     V8208 V8209 V8210 V8211 V8212 V8213 V8214
     V8215 V8216 V8217 V8218 V8219 V8220 V8221 V8222 V8223 V8224
     V18205 V18206 V18207 V18208 V18209 V18210 V18211 V18213 V18214
     V18215 V18216 V18217 V18218 V18219 V18220 V18221 V18222 V18223 V18224.

USE ALL.
SELECT IF (ATYPEPAR EQ '1').

    RENAME variables
    V8201 = V8201M
    V8202 = V8202M
    V8203 = V8203M
    V8204 = V8204M
    V8205 = V8205M
    V8206 = V8206M
    V8207 = V8207M
    V8208 = V8208M
    V8209 = V8209M
    V8210 = V8210M
    V8211 = V8211M
    V8212 = V8212M
    V8213 = V8213M
    V8214 = V8214M
    V8215 = V8215M
    V8216 = V8216M
    V8217 = V8217M
    V8218 = V8218M
    V8219 = V8219M
    V8220 = V8220M
    V8221 = V8221M
    V8222 = V8222M
    V8223 = V8223M
    V8224 = V8224M
    V18205 = V18205M
    V18206 = V18206M
    V18207 = V18207M
    V18208 = V18208M
    V18209 = V18209M
    V18210 = V18210M
    V18211 = V18211M
    V18213 = V18213M
    V18214 = V18214M
    V18215 = V18215M
    V18216 = V18216M
    V18217 = V18217M
    V18218 = V18218M
    V18219 = V18219M
    V18220 = V18220M
    V18221 = V18221M
    V18222 = V18222M
    V18223 = V18223M
    V18224 = V18224M
    .
SAVE OUTFILE='c:\temp\MOTHERS.sav' /drop = ATYPEPAR.
EXECUTE.


/*  STEP 3: CREATE FILE WITH FATHER RECORDS
GET FILE "c:\temp\PARENT1.sav" /keep = ATYPEPAR
     HHID PN ASUBHH APN_SP AFAMR AFINR V1 V2 V3
     V8201 V8202 V8203 V8204 V8205 V8206 V8207
     V8208 V8209 V8210 V8211 V8212 V8213 V8214
     V8215 V8216 V8217 V8218 V8219 V8220 V8221 V8222 V8223 V8224
     V18205 V18206 V18207 V18208 V18209 V18210 V18211 V18213 V18214
     V18215 V18216 V18217 V18218 V18219 V18220 V18221 V18222 V18223 V18224.

USE ALL.
SELECT IF (ATYPEPAR EQ '2').

    RENAME variables
    V8201 = V8201F
    V8202 = V8202F
    V8203 = V8203F
    V8204 = V8204F
    V8205 = V8205F
    V8206 = V8206F
    V8207 = V8207F
    V8208 = V8208F
    V8209 = V8209F
    V8210 = V8210F
    V8211 = V8211F
    V8212 = V8212F
    V8213 = V8213F
    V8214 = V8214F
    V8215 = V8215F
    V8216 = V8216F
    V8217 = V8217F
    V8218 = V8218F
    V8219 = V8219F
    V8220 = V8220F
    V8221 = V8221F
    V8222 = V8222F
    V8223 = V8223F
    V8224 = V8224F
    V18205 = V18205F
    V18206 = V18206F
    V18207 = V18207F
    V18208 = V18208F
    V18209 = V18209F
    V18210 = V18210F
    V18211 = V18211F
    V18213 = V18213F
    V18214 = V18214F
    V18215 = V18215F
    V18216 = V18216F
    V18217 = V18217F
    V18218 = V18218F
    V18219 = V18219F
    V18220 = V18220F
    V18221 = V18221F
    V18222 = V18222F
    V18223 = V18223F
    V18224 = V18224F
    .
SAVE OUTFILE='c:\temp\FATHERS.sav' /drop = ATYPEPAR.
EXECUTE.

/*  STEP 4: MERGE MOTHER AND FATHER FILES
MATCH FILES
 /FILE="c:\temp\MOTHERS.sav"
 /FILE="c:\temp\FATHERS.sav"
 /BY HHID PN.
SAVE OUTFILE='c:\temp\PARENTS.sav'.
EXECUTE.