CDS Child to Caregiver Map

The child to caregiver map provides information on “1968 INTERVIEW NUMBER” (ID68) and “PERSON NUMBER 68” (PN) variables about CDS individuals.  The CDS individuals are Child, Primary Caregiver (PCG) and Other Caregiver (OCG).   The map data file has following structure:

Column               Label

ER30001   "CHILD: 1968 INTERVIEW NUMBER"
ER30002   "CHILD: PERSON NUMBER 68"
PCGID_97  "PCG 1997: 1968 INTERVIEW NUMBER"
PCGPN_97  "PCG 1997: PERSON NUMBER 68"
OCGID_97  "OCG 1997: 1968 INTERVIEW NUMBER"
OCGPN_97  "OCG 1997: PERSON NUMBER 68"
PCGID_02  "PCG 2002: 1968 INTERVIEW NUMBER"
PCGPN_02  "PCG 2002: PERSON NUMBER 68"
OCGID_02  "OCG 2002: 1968 INTERVIEW NUMBER"
OCGPN_02  "OCG 2002: PERSON NUMBER 68"

All CDS files contain variables ER30001 and ER30002.  These columns are also in the map file.  The map file can be used to merge PCG and OCG data from Main PSID data to CDS Child level data.  This can be done in two steps:

  1. Merge map file with child file using ER30001 and ER30002 as keys. This step will bring PCG and OCG id’s from 1997 and 2002 to the Child level file.
  2. Merge file from step-1 with main PSID data about PCG or OCG using PCG or OCG ID68 and PN column.  User may have to rename columns.

Below is the sample data from the map file.

ER30001 ER30002 PCGID_97 PCGPN_97 OCGID_97 OCGPN_97 PCGID_02 PCGPN_02 OCGID_02 OCGPN_02
  0004    039     0004     173      0004     003      0004     173      0004     003
  0004    187     0004     005      0004     186      0004     005      0004     186
  0004    041     0004     031         .       .      0004     031         .       .
  0004    042     0004     031         .       .      0004     031         .       .
  0005    032     0005     170      0005     003      0005     170      0005     003
  0007    039     0007     171      0007     005      0007     171         .       .
  0007    040     0007     171      0007     005      0007     171         .       .
  0007    045     0007     175      0007     031      0007     175      0007     031
  0010    034     0010     006      0010     176      0010     006         .       .
  0010    035     0010     006      0010     176      0010     006         .       .

All data values are ID68 and PN of different CDS individuals.  Missing data means that the child did not have PCG or OCG from the CDS interview year.