-------------------------------------------------------------------------------------------------------------------------------------------------------- name: log: m:/usersupport_no774.log log type: text opened on: 4 May 2017, 12:39:40 . use "W:\main\eudb\stata\b_indall.dta", clear . fre b_hhorig b_hhorig -- sample origin ----------------------------------------------------------------------------- | Freq. Percent Valid Cum. --------------------------------+-------------------------------------------- Valid 1 ukhls gb 2009-10 | 48646 62.74 62.74 62.74 2 ukhls ni 2009-10 | 2823 3.64 3.64 66.38 3 bhps gb 1991 | 9035 11.65 11.65 78.03 4 bhps sco 1999 | 2122 2.74 2.74 80.77 5 bhps wal 1999 | 2440 3.15 3.15 83.91 6 bhps ni 2001 | 2965 3.82 3.82 87.74 7 ukhls emboost 2009-10 | 9507 12.26 12.26 100.00 Total | 77538 100.00 100.00 ----------------------------------------------------------------------------- . keep if inlist(b_hhorig,3,4,5,6) (60,976 observations deleted) . drop if pid==-8 (836 observations deleted) . merge 1:1 pid using T:\final\nindall Result # of obs. ----------------------------------------- not matched 9,953 from master 1,776 (_merge==1) from using 8,177 (_merge==2) matched 13,950 (_merge==3) ----------------------------------------- . use "W:\main\eudb\stata\b_indresp.dta", clear . fre b_hhorig b_hhorig -- sample origin ----------------------------------------------------------------------------- | Freq. Percent Valid Cum. --------------------------------+-------------------------------------------- Valid 1 ukhls gb 2009-10 | 35105 64.30 64.30 64.30 2 ukhls ni 2009-10 | 1858 3.40 3.40 67.70 3 bhps gb 1991 | 6598 12.08 12.08 79.79 4 bhps sco 1999 | 1576 2.89 2.89 82.67 5 bhps wal 1999 | 1795 3.29 3.29 85.96 6 bhps ni 2001 | 2067 3.79 3.79 89.75 7 ukhls emboost 2009-10 | 5598 10.25 10.25 100.00 Total | 54597 100.00 100.00 ----------------------------------------------------------------------------- . keep if inlist(b_hhorig,3,4,5,6) (42,561 observations deleted) . drop if pid==-8 (256 observations deleted) . merge 1:1 pid using T:\final\nindresp Result # of obs. ----------------------------------------- not matched 8,105 from master 2,047 (_merge==1) from using 6,058 (_merge==2) matched 9,733 (_merge==3) ----------------------------------------- . log close name: log: m:/usersupport_no774.log log type: text closed on: 4 May 2017, 12:39:56 --------------------------------------------------------------------------------------------------------------------------------------------------------