Timing of farm succession and exit in smallholder agriculture: the case of the Philippines: survey data and Stata replication files
Description
This dataset contains household survey data and Stata replication code for a study of the drivers and expected timing of farm succession and exit among smallholder upland farming households in Lantapan, Bukidnon, Philippines. The data were collected in 2024 through a tablet-based survey (KoboCollect) of 314 farming households, drawn by stratified random sampling (strata by elevation, Neyman allocation) from the 5,177 landowner farmers on the Master List of Farmers of the Municipal Agriculture Office. Respondents reported the likelihood of intra-family farm succession on a five-category scale, the expected number of years until succession or exit, and detailed information on household composition, the household head’s and spouse’s characteristics, children’s farm involvement and migration plans, farm income and assets, land, production and marketing practices, shocks experienced, and intra-household decision-making measured through a Women’s Empowerment in Agriculture Index (WEAI) adapted from Alkire et al. (2013) with stricter adequacy cut-offs for the Philippine context. The deposit has two parts. The Excel workbook (Data for Analysis.xlsx) holds the anonymized analysis dataset: one row per household, identified only by an anonymous code and barangay, in four sheets (Probit for the succession-likelihood models; AFT_All for the competing-risks timing models; AFT_SUC and AFT_Exit as single-pathway reference sheets). The two Stata do-files reproduce every table and figure of the associated article: probit do file estimate the drivers of expected succession on the full sample (n = 314) and on the headline sample excluding undecided households (n = 266), with descriptives, diagnostics, alternative estimators, and multiple-imputation robustness; the accelerated-failure-time (AFT) file constructs the survival data, selects the failure-time distribution by AIC/BIC (Weibull for both pathways), and estimates the timing of succession and exit as competing risks with barangay fixed effects and robust standard errors. All monetary variables are in Philippine pesos (PHP). Informed consent was obtained from all participants and no direct identifiers are included.
Files
Steps to reproduce
1. Requirements: Stata 17 or newer. The do-files install the community package estout automatically if absent (internet required once); multiple-imputation and bootstrap steps use the seed set inside the files (20260722), so results replicate exactly. 2. Place the three do-files and Data for Analysis.xlsx in one folder and set it as Stata’s working directory. All outputs are written to a subfolder named probit_outputs (created automatically): RTF tables that open in Word, PNG figures, .docx reports, saved estimates (.ster), and .smcl logs. 3. Import sheet "Probit" of Data for Analysis.xlsx into Stata (import excel, first row as variable names), then run probit_succession_analysis_final.do. 4. Re-clear Stata, import sheet "AFT_All", and run aft_succession_exit_analysis.do. The distribution holder is set to Weibull for both pathways, confirmed by the Stage 1 AIC comparison; set run_stage1 = 1 in PART 0 to re-fit all five candidate distributions, and censor_undecided = 0 to reproduce the sensitivity coding in which undecided households are treated as exit events rather than censored. 5. The main article exhibits correspond to: Table3_probit_AME_A2.rtf (marginal effects), Table_AFT_suc.rtf and Table_AFT_exit.rtf (timing models), Table2_combined_probit_AFT.rtf (combined table), Fig_KM_*.png and Fig_hazard_*.png (survival and hazard figures).
Institutions
- University of Southeastern PhilippinesDavao Region, Davao City