Following is a response from Senior DHS staff member, Tom Pullum:
The following Stata lines will add the mother's data and the household-level data to the child's record. Let us know if you need something else.
* Merge the KR, IR, and HR files for the Tanzania 2022 survey
* specify workspace
cd e:\DHS\DHS_data\scratch
use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\TZHR82FL.DTA", clear
* Just keep household-level variables
drop *_*
gen cluster=hv001
gen hh=hv002
sort cluster hh
save HRtemp.dta, replace
use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\TZIR82FL.DTA", clear
gen cluster=v001
gen hh=v002
gen mo_line=v003
sort cluster hh mo_line
save IRtemp.dta, replace
use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\TZKR82FL.DTA", clear
gen cluster=v001
gen hh=v002
gen mo_line=v003
* Merge the child with the mother's data
* The KR file already includes many of the mother's variables; they will be over-written
sort cluster hh mo_line
quietly merge cluster hh mo_line using IRtemp.dta
tab _merge
keep if _merge==3
drop _merge
* Merge the child and mother with the household data
sort cluster hh
quietly merge cluster hh using HRtemp.dta
tab _merge
keep if _merge==3
drop _merge