2018 SIPP: THTOTINCT2 Missing Type 2 Income for Unrelated Household Members

In the 2018, 2019, and 2020 SIPP, THTOTINCT2 (Total household income including Type 2 people) omitted Type 2 [HBS(F1] income from unrelated individuals.

In the 2018 SIPP, this impacted less than 1.5 percent of person-month records. Among the impacted records, omitted Type 2 income from unrelated household members had a median monthly value of $2,500 and a mean monthly value of $4,502[HBS(F2] . Among all records the difference in median monthly income when excluding and including Type 2 income from unrelated individuals was $37.

The omitted Type 2 income from unrelated individuals in the 2018 SIPP had a relatively small impact on the annual and monthly household poverty rates that include Type 2 individuals.

The SAS code below creates THTOTINCT2_CORRECTED which includes all Type 2 income in the recode:

libname sipp <PUT PATHNAME HERE>;  /* location of where the data are stored */

data temp;

set sipp.pu2018;

keep=ssuid pnum monthcode thtotinct2 rrel_pnum1-rrel_pnum30 et2_lno1-et2_lno10 tt2inc1-tt2inc10);

where monthcode in (1:12);

run;

proc sort data=sipp;

by ssuid pnum monthcode;

run;

data sipp_corrected;

set sipp;

by ssuid pnum monthcode;

array rr(30)  rrel_pnum1-rrel_pnum30;

array t(10)   et2_lno1-et2_lno10;

array tinc(10)  tt2inc1-tt2inc10;

t2inc=0;

/* Create monthly value of annual Type 2 income using the array of ten Type 2 people */

do i=1 to 30;

     do j=1 to 10;

          if rr(i)>0 and rr(i)=t(j) and tinc(j)>0

then t2inc=t2inc+(tinc(j)/12);

     end;

end;

thtotinct2_corrected = thtotinc + t2inc;

thtotinct2_corrected = round(thtotinct2_corrected);

run;

Page Last Revised - July 8, 2024