U.S. flag

An official website of the United States government

Skip Header


2020 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 income from unrelated individuals.

In the 2020 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,200 and a mean monthly value of $3,637. Among all records the difference in median monthly income when excluding and including Type 2 income from unrelated individuals was $29.

The omitted Type 2 income from unrelated individuals in the 2020 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.pu2020;

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 9, 2024
Is this page helpful?
Thumbs Up Image Yes Thumbs Down Image No
NO THANKS
255 characters maximum 255 characters maximum reached
Thank you for your feedback.
Comments or suggestions?

Top

Back to Header