I am trying to replicate the OFFPOV column in Table 1 titled “Difference between Official Poverty Rates and PUMS Poverty Rates” on the web page Official Poverty Rates Using the Cps Public-Use Microdata Series. I need to do this with the underlying income, threshold and weights. My current code is typically off by 0.4% that is 13% can come out as 13.4% or 12.6%.
Here is what I am doing. Year-by-year I fliter out data where OFFPOVUNIV is not equal to 1 (i.e. require OFFPOVUNIV==1). For income I am using OFFTOTVAL (I have also tried using FTOTVAL with similar sized errors). For the cutoff I am using OFFCUTOFF. For the weights I am using WTSUPP (I have also tried using HWTSUPP, again with similar sized errors).
Year-by-year for all observations that passed the OFFPOVUNIV==1 test, I sum the WTSUPP values. Call this Total_WTSUPP. Next I create a dummy equal to 1 if OFFTOTVAL<OFFCUTOFF and 0 otherwise. I then multiply this dummy by WTSUPP. Call this Pov_WTSUPP. I then calculate the poverty rate as Pov_WTSUPP/Total_WTSUPP.
As an example of the error, in 1988 the official rate is 13% and by my calculation it is 13.37%. Am I using the wrong income or threshold variable? Am I using the weights as intended? Thank you to whoever can help me resolve this problem.