Variable Created
CVC_TTL_RESIDENCES_EDT

Number of different residences (since age 12) edited to include only the information from the round 6 childhood retrospective section.

Variables Used
    PUBID = PUBID_1997
    CV_TTL_RES97 = CV_TTL_RESIDENCES_1997
    YHHI_3500_98 = YHHI_3500_1998
    YHHI_3600_98 = YHHI_3600_1998
    CV_TTL_RES98 = CV_TTL_RESIDENCES_1998
    YHHI_3500_99 = YHHI_3500_1999
    YHHI_3600_99 = YHHI_3600_1999
    CV_TTL_RES99 = CV_TTL_RESIDENCES_1999
    YHHI_3500_00 = YHHI_3500_00
    YHHI_3600_00 = YHHI_3600_00
    CV_TTL_RES00 = CV_TTL_RESIDENCES_00
    YHHI_3500_01 = YHHI_3500_01
    YHHI_3600_01 = YHHI_3600_01
    CV_TTL_RES01 = CV_TTL_RESIDENCES_01
    YHHI_3500_02 = YHHI_3500_02
    YHHI_3600_02 = YHHI_3600_02
    YCHR_1080_02 = YCHR_1080_02
    CV_TTL_RES02 = CV_TTL_RESIDENCES_02
    CV_TTL_RES_EDT02 = CV_TTL_RESIDENCES_EDT_02
    CV_TTL_RES03 = CV_TTL_RESIDENCES_03
    CV_TTL_RES_EDT03 = CV_TTL_RESIDENCES_EDT_03
    YHHI_3500_03 = YHHI_3500_03
    YHHI_3600_03 = YHHI_3600_03
    YCHR_1080_03 = YCHR_1080_03
    CV_TTL_RES04 = CV_TTL_RESIDENCES_04
    CV_TTL_RES_EDT04 = CV_TTL_RESIDENCES_EDT_04
    YHHI_3500_04 = YHHI_3500_04
    YHHI_3600_04 = YHHI_3600_04
    YCHR_1080_04 = YCHR_1080_04
    CV_TTL_RES05 = CV_TTL_RESIDENCES_05
    CV_TTL_RES_EDT05 = CV_TTL_RESIDENCES_EDT_05
    YHHI_3500_05 = YHHI_3500_05
    YHHI_3600_05 = YHHI_3600_05
    YCHR_1080_05 = YCHR_1080_05
    CV_TTL_RES06 = CV_TTL_RESIDENCES_06
    YHHI_3500_06 = YHHI_3500_06
    YHHI_3600_06 = YHHI_3600_06
    CV_TTL_RES07 = CV_TTL_RESIDENCES_07
    YHHI_3500_07 = YHHI_3500_07
    YHHI_3600_07 = YHHI_3600_07
    YHHI_3500_08 = YHHI_3500_08
    YHHI_3600_08 = YHHI_3600_08
    YHHI_3500_09 = YHHI_3500_09
    YHHI_3600_09 = YHHI_3600_09
    YHHI_3500_10 = YHHI_3500_10
    YHHI_3600_10 = YHHI_3600_10
    YHHI_3500_11 = YHHI_3500_11
    YHHI_3600_11 = YHHI_3600_11
    YHHI_3500_13 = YHHI_3500_13
    YHHI_3600_13 = YHHI_3600_13
    YHHI_3500_15 = YHHI_3500_15
    YHHI_3600_15 = YHHI_3600_15
    YHHI_3600_EXP_15 = YHHI_3600_EXP_15
    YHHI_3500_17 = YHHI_3500_17
    YHHI_3600_17 = YHHI_3600_17
    YHHI_3600_EXP_17 = YHHI_3600_EXP_17
    YHHI_3500_19 = YHHI_3500_19
    YHHI_3600_19 = YHHI_3600_19
    YCHR_1080_COMB_XRND = YCHR_1080_COMB_XRND
    CVC_TTL_RES = CVC_TTL_RESIDENCES_XRND;

SAS Code for Variable Creation

data residences_edt2; set residences_edt1;
if YHHI_3600_EXP_15>-4 & YHHI_3600_15=-4 then YHHI_3600_15=YHHI_3600_EXP_15;
if YHHI_3600_EXP_17>-4 & YHHI_3600_17=-4 then YHHI_3600_17=YHHI_3600_EXP_17;

array res_edt		CV_TTL_RES_EDT02-CV_TTL_RES_EDT05;
array yr			yr02-yr05 (2 3 4 5);

do over res_edt;
	if res_edt>-4 then do;
		residprev=res_edt;
		residprev_yr=yr;
	end;
end;


data residences_edt3; set residences_edt2;
if residprev>-4;

array y3500	 (i)	YHHI_3500_01-YHHI_3500_11 YHHI_3500_13 YHHI_3500_15 YHHI_3500_17 YHHI_3500_19;
array y3600	 (i)	YHHI_3600_01-YHHI_3600_11 YHHI_3600_13 YHHI_3600_15 YHHI_3600_17 YHHI_3600_19;


do i=(residprev_yr+1) to 15;
	if (residprev in (-1,-2,-3)) then resid=-3;
	if residprev ne -4 and ((y3500 in (-1,-2,-3)) or (y3600 in (-1,-2,-3))) then resid=-3;

	if residprev>=0 & y3500=0 then resid=residprev;
	if residprev>=0 & y3600>=0 then resid=residprev+y3600;
	if (y3500=-5) then resid=residprev;
	residprev=resid;
end;
run;