When I use WTFINL or HWTFINL, I get really large estimates that I know are incorrect. I’ve limited the data to one record per household, and I used the IPUMS CPS Stata read-in code that adjusts the weight variables by dividing by 10,000. Is a further adjustment necessary? I am using monthly CPS data from 2023 to 2025. Here is a simple version of my code, which leads to estimates of billions of people in 2023 and 2024, and 546 million in 2025. Do I need to do this monthly, and then average?
local filedt 20250608
use “./output/cps_extract_00003_`filedt’.dta”, clear
gen counter=1
bysort year month hseq hrhhid hrhhid2 (pernum): keep if _n == 1
bysort year: tab counter [iw=hwtfinl]