BUILD_PNADC_PANEL

Basic Identification

The household identifier – stored as id_dom – combines the variables:

• UPA – Primary Sampling Unit - PSU;
• V1008 – Household;
• V1014 – Panel Number;

In order to create a unique number for every combination of those variables.

The basic individual identifier – stored as id_ind – combines the household id with:

• V2007 – Sex;
• Date of Birth – [V20082 (year), V20081 (month), V2008 (day)];

In order to create a unique number for every combination of those variables.

Advanced Identification

On individuals who were not matched across all interviews using the basic method, we apply a progressive multi-stage algorithm to increase matching power without compromising uniqueness.

First, we reproduce the birth date donation method based on the methodology described in the IPEA technical note (Osório, 2019). It estimates and imputes missing birth dates (day, month, and year) by matching individuals with donors from different interviews within the same household based on sex, acceptable household condition changes, and estimated age. This process is executed by our internal function donate_birth_dates.

• Stage 1 (advanced_1): Repeats the basic identification logic, but utilizing the donated dates. The identifier – stored as id_rs1 – combines:
  • id_dom – Household ID
  • V2007 – Sex
  • birth_day – Donated day of birth
  • birth_month – Donated month of birth
  • birth_year – Donated year of birth
• Stage 2 (advanced_2): For individuals not completely matched in Stage 1, we relax the year of birth constraint (assuming it is often misreported). The identifier – stored as id_rs2 – combines:
  • id_dom – Household ID
  • birth_month – Donated month of birth
  • birth_day – Donated day of birth
  • V2003 – Order number in the household
• Stage 3 (advanced_3): Targets candidates with fragmented interviews (less than 5 matches in the previous stages). It considers a match successful if there is a unique individual in the same household, in a different quarter, that satisfies the acceptable difference criteria established by Ribas and Soares (up to 4 days difference in the day of birth, 2 months in the month of birth, and a dynamically adjusted year-of-birth difference based on the individual’s reported age). The final identifier is stored as id_rs3.

Attrition and Identification Rates