An official website of the United States government
Here’s how you know
Official websites use .gov
A .gov website belongs to an official government organization in the United States.
Secure .gov websites use HTTPS
A lock (
) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.
In the 2018, 2019, and 2020 SIPP, THTOTINCT2 (Total household income including Type 2 people) omitted Type 2 income from unrelated individuals.
In the 2019 SIPP, this impacted less than 1.0 percent of person-month records. Among the impacted records, omitted Type 2 income from unrelated household members had a median monthly value of $2,917 and a mean monthly value of $4,754. Among all records the difference in median monthly income when excluding and including Type 2 income from unrelated individuals was $18.
The omitted Type 2 income from unrelated individuals in the 2019 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;
Share
Top