-------------
      name:  <unnamed>
       log:  E:\LSE\Classes\Dissertation\My analysis\Promit\New analysis july 29\Working sheets on data\16 august_2022_Log file_2_work after child module merging.smcl
  log type:  smcl
 opened on:  16 Aug 2022, 16:28:33

. use "E:\LSE\Classes\Dissertation\My analysis\Promit\New analysis july 29\Working sheets on data\wave 8_9_10_xdat_combined_14 August_1.dta"
(Information for all persons in household, incl. children and non)

. merge m:m pidp using "E:\LSE\Classes\Dissertation\My analysis\Promit\New analysis july 29\Data for my analysis\i_child.dta", generate(child_with8910_merge)
(label i_grmpno already defined)
(label i_grfpno already defined)
(label i_mnspno already defined)
(label i_mnspid already defined)
(label i_mnpno already defined)
(label i_fnspno already defined)
(label i_fnspid already defined)
(label i_fnpno already defined)
(label i_hrpno already defined)
(label i_hrpid already defined)
(label i_adresp15_dv already defined)
(label i_depchl_dv already defined)
(label i_buno_dv already defined)
(label i_agegr13_dv already defined)
(label i_agegr10_dv already defined)
(label i_agegr5_dv already defined)
(label i_hhresp_dv already defined)
(label i_urban_dv already defined)
(label i_gor_dv already defined)
(label i_country already defined)
(label i_nnsib_dv already defined)
(label i_ngrp_dv already defined)
(label i_npns_dv already defined)
(label i_npn_dv already defined)
(label i_doby_dv already defined)
(label i_intdaty_dv already defined)
(label i_intdatm_dv already defined)
(label i_intdatd_dv already defined)
(label i_age_dv already defined)
(label i_sex_dv already defined)
(label i_grmpid already defined)
(label i_grfpid already defined)
(label i_pns2sex already defined)
(label i_pns2pno already defined)
(label i_pns2pid already defined)
(label i_pns1sex already defined)
(label i_pns1pno already defined)
(label i_pns1pid already defined)
(label i_pn2sex already defined)
(label i_pn2pno already defined)
(label i_pn2pid already defined)
(label i_pn1sex already defined)
(label i_pn1pno already defined)
(label i_pn1pid already defined)
(label i_mnpid already defined)
(label i_fnpid already defined)
(label i_age_if already defined)
(label i_doby_if already defined)
(label i_intdaty_if already defined)
(label i_intdatm_if already defined)
(label i_intdatd_if already defined)
(label i_ringfence already defined)
(label i_instdet_code already defined)
(label i_newentrant already defined)
(label i_region already defined)
(label i_hhlang already defined)
(label i_hglitrans already defined)
(label i_hglieng already defined)
(label i_reasref97 already defined)
(label i_reasref96 already defined)
(label i_reasref32 already defined)
(label i_reasref31 already defined)
(label i_reasref30 already defined)
(label i_reasref26 already defined)
(label i_reasref25 already defined)
(label i_reasref24 already defined)
(label i_reasref23 already defined)
(label i_reasref22 already defined)
(label i_reasref21 already defined)
(label i_reasref20 already defined)
(label i_reasref15 already defined)
(label i_reasref14 already defined)
(label i_reasref13 already defined)
(label i_reasref12 already defined)
(label i_reasref11 already defined)
(label i_reasref10 already defined)
(label i_lingua already defined)
(label i_newdad already defined)
(label i_newmum already defined)
(label i_hgadoptf already defined)
(label i_hgadoptm already defined)
(label i_hgbioad2 already defined)
(label i_hgbioad1 already defined)
(label i_hgbiof already defined)
(label i_hgbiom already defined)
(label i_livpar already defined)
(label i_pensioner already defined)
(label i_rjrflag already defined)
(label i_bedsits already defined)
(label i_purposeblt already defined)
(label i_housebun already defined)
(label i_dwltype already defined)
(label i_hhelig already defined)
(label i_respemail already defined)
(label i_respemailconf already defined)
(label i_hhemail already defined)
(label i_ctitle already defined)
(label i_newper already defined)
(label i_curstat already defined)
(label i_movctry already defined)
(label i_moveyr already defined)
(label i_movemth already defined)
(label i_lvwhy already defined)
(label i_mothr already defined)
(label i_stillres already defined)
(label i_includ already defined)
(label i_dieprisyr already defined)
(label i_dieprismth already defined)
(label i_more already defined)
(label i_ageif already defined)
(label i_nebirthy already defined)
(label i_nesex already defined)
(label i_jnyear already defined)
(label i_jnmnth already defined)
(label i_rejoinero already defined)
(label i_rejoiner already defined)
(label i_joiner already defined)
(label i_ynew already defined)
(label i_prishome already defined)
(label i_abspris already defined)
(label i_unihome already defined)
(label i_absun already defined)
(label i_birthy already defined)
(label i_dvage already defined)
(label i_sex already defined)
(label i_ivfho already defined)
(label i_ivfio already defined)
(label i_quarter already defined)
(label i_month already defined)
(label i_sampst already defined)
(label i_strata already defined)
(label i_psu already defined)
(label i_memorig already defined)
(label i_hhorig already defined)
(label i_childpno already defined)
(label pid already defined)

    Result                      Number of obs
    -----------------------------------------
    Not matched                       139,099
        from master                   139,099  (child_with8910_merge==1)
        from using                          0  (child_with8910_merge==2)

    Matched                            10,306  (child_with8910_merge==3)
    -----------------------------------------

. save "E:\LSE\Classes\Dissertation\My analysis\Promit\New analysis july 29\Working sheets on data\wave 8_9_10_xdat_combined_14 August_1_child wave 9.dta"


file
E:\LSE\Classes\Dissertation\My analysis\Promit\New analysis july 29\Working sheets on data\wave 8_9_10_xdat_combined_14 August_1_child wave 9.dta{rm}
saved


. merge m:m pidp using "E:\LSE\Classes\Dissertation\My analysis\Promit\New analysis july 29\Data for my analysis\j_child.dta", generate(j_child_with8910_merge)
(label j_grmpno already defined)
(label j_grfpno already defined)
(label j_mnspno already defined)
(label j_mnspid already defined)
(label j_mnpno already defined)
(label j_fnspno already defined)
(label j_fnspid already defined)
(label j_fnpno already defined)
(label j_adresp15_dv already defined)
(label j_depchl_dv already defined)
(label j_buno_dv already defined)
(label j_agegr13_dv already defined)
(label j_agegr10_dv already defined)
(label j_agegr5_dv already defined)
(label j_hhresp_dv already defined)
(label j_urban_dv already defined)
(label j_gor_dv already defined)
(label j_country already defined)
(label j_nnsib_dv already defined)
(label j_ngrp_dv already defined)
(label j_npns_dv already defined)
(label j_npn_dv already defined)
(label j_doby_dv already defined)
(label j_intdaty_dv already defined)
(label j_intdatm_dv already defined)
(label j_intdatd_dv already defined)
(label j_age_dv already defined)
(label j_sex_dv already defined)
(label j_grmpid already defined)
(label j_grfpid already defined)
(label j_pns2sex already defined)
(label j_pns2pno already defined)
(label j_pns2pid already defined)
(label j_pns1sex already defined)
(label j_pns1pno already defined)
(label j_pns1pid already defined)
(label j_pn2sex already defined)
(label j_pn2pno already defined)
(label j_pn2pid already defined)
(label j_pn1sex already defined)
(label j_pn1pno already defined)
(label j_pn1pid already defined)
(label j_mnpid already defined)
(label j_fnpid already defined)
(label j_age_if already defined)
(label j_doby_if already defined)
(label j_intdaty_if already defined)
(label j_intdatm_if already defined)
(label j_intdatd_if already defined)
(label j_ringfence already defined)
(label j_instdet_code already defined)
(label j_newentrant already defined)
(label j_region already defined)
(label j_hhlang already defined)
(label j_hglitrans already defined)
(label j_hglieng already defined)
(label j_reasref97 already defined)
(label j_reasref96 already defined)
(label j_reasref32 already defined)
(label j_reasref31 already defined)
(label j_reasref30 already defined)
(label j_reasref26 already defined)
(label j_reasref25 already defined)
(label j_reasref24 already defined)
(label j_reasref23 already defined)
(label j_reasref22 already defined)
(label j_reasref21 already defined)
(label j_reasref20 already defined)
(label j_reasref15 already defined)
(label j_reasref14 already defined)
(label j_reasref13 already defined)
(label j_reasref12 already defined)
(label j_reasref11 already defined)
(label j_reasref10 already defined)
(label j_lingua already defined)
(label j_newdad already defined)
(label j_newmum already defined)
(label j_hgadoptf already defined)
(label j_hgadoptm already defined)
(label j_hgbioad2 already defined)
(label j_hgbioad1 already defined)
(label j_hgbiof already defined)
(label j_hgbiom already defined)
(label j_livpar already defined)
(label j_pensioner already defined)
(label j_rjrflag already defined)
(label j_bedsits already defined)
(label j_purposeblt already defined)
(label j_housebun already defined)
(label j_dwltype already defined)
(label j_hhelig already defined)
(label j_respemail already defined)
(label j_respemailconf already defined)
(label j_hhemail already defined)
(label j_ctitle already defined)
(label j_newper already defined)
(label j_curstat already defined)
(label j_movctry already defined)
(label j_moveyr already defined)
(label j_movemth already defined)
(label j_lvwhy already defined)
(label j_mothr already defined)
(label j_stillres already defined)
(label j_includ already defined)
(label j_dieprisyr already defined)
(label j_dieprismth already defined)
(label j_more already defined)
(label j_ageif already defined)
(label j_nebirthy already defined)
(label j_nesex already defined)
(label j_jnyear already defined)
(label j_jnmnth already defined)
(label j_rejoinero already defined)
(label j_rejoiner already defined)
(label j_joiner already defined)
(label j_ynew already defined)
(label j_prishome already defined)
(label j_abspris already defined)
(label j_unihome already defined)
(label j_absun already defined)
(label j_birthy already defined)
(label j_dvage already defined)
(label j_sex already defined)
(label j_ivfho already defined)
(label j_ivfio already defined)
(label j_quarter already defined)
(label j_month already defined)
(label j_sampst already defined)
(label j_strata already defined)
(label j_psu already defined)
(label j_memorig already defined)
(label j_hhorig already defined)
(label j_childpno already defined)
(label pid already defined)

    Result                      Number of obs
    -----------------------------------------
    Not matched                       139,846
        from master                   139,846  (j_child_with8910_merge==1)
        from using                          0  (j_child_with8910_merge==2)

    Matched                             9,559  (j_child_with8910_merge==3)
    -----------------------------------------

. save "E:\LSE\Classes\Dissertation\My analysis\Promit\New analysis july 29\Working sheets on data\wave 8_9_10_xdat_combined_14 August_1_child wave 9 and 10.dta"


file
E:\LSE\Classes\Dissertation\My analysis\Promit\New analysis july 29\Working sheets on data\wave 8_9_10_xdat_combined_14 August_1_child wave 9 and 10.dta{rm}
saved


. tabulate i_wrkch2a0 dropout_10, chi col
no observations

. tabulate i_wrkch2a0

           No |
childcare/nur |
     sery use |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      2,981       28.92       95.21
    Mentioned |        494        4.79      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a1

      Nursery |
    school or |
        class |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,070       29.79       96.07
    Mentioned |        405        3.93      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a2 i_wrkch2a3 i_wrkch2a4 i_wrkch2a5 i_wrkch2a6 i_wrkch2a7 i_wrkch2a8 i_wrkch2a9 i_wrkch2a10 i_wrkch2a11 i_wrkch2a12 i_wrkch2a13 i_wrkch2a14 i_wrkch2a15 i_wrkch2a16 i_wrkch2a17 i_wrkch21
too many variables specified
r(103);

. tabulate i_wrkch2a2

     SE needs |
  Sch/nursery |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,465       33.62       99.90
    Mentioned |         10        0.10      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a3

    childcare |
    used: day |
   nursery or |
       creche |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,256       31.59       97.88
Yes mentioned |        219        2.12      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a4

 Playgroup or |
   pre-school |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,382       32.82       99.10
    Mentioned |         93        0.90      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a5

  Childminder |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,075       29.84       96.12
    Mentioned |        400        3.88      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a6

  Nanny/carer |
      in home |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,401       33.00       99.28
    Mentioned |         74        0.72      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a7

  Baby-sitter |
      in home |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,394       32.93       99.21
    Mentioned |         81        0.79      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a8

 B'fast/after |
  sch club at |
school/nurser |
            y |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      2,778       26.96       93.24
    Mentioned |        697        6.76      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a9

 B'fast/after |
 sch club o/s |
school/nurser |
            y |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,350       32.51       98.79
    Mentioned |        125        1.21      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a10

      Holiday |
  club/scheme |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,375       32.75       99.03
    Mentioned |        100        0.97      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a11

   Ex/non-res |
       parent |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,404       33.03       99.31
    Mentioned |         71        0.69      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a12

      Child's |
grandparent(s |
            ) |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      1,967       19.09       85.37
    Mentioned |      1,508       14.63      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a13

Child's older |
      bro/sis |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,388       32.87       99.16
    Mentioned |         87        0.84      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a14

      Another |
     relative |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,200       31.05       97.33
    Mentioned |        275        2.67      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a15

  A friend or |
    neighbour |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,247       31.51       97.79
    Mentioned |        228        2.21      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a16

Other nursery |
  Ed provider |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,469       33.66       99.94
    Mentioned |          6        0.06      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch2a17

        Other |
    childcare |
     provider |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |      6,814       66.12       66.12
      Refusal |          3        0.03       66.15
   Don't know |         14        0.14       66.28
Not mentioned |      3,441       33.39       99.67
    Mentioned |         34        0.33      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. tabulate i_wrkch21

      Nursery |
    school or |
nursery class |      Freq.     Percent        Cum.
--------------+-----------------------------------
 Inapplicable |     10,226       99.22       99.22
   Don't know |          2        0.02       99.24
Not mentioned |         69        0.67       99.91
    Mentioned |          9        0.09      100.00
--------------+-----------------------------------
        Total |     10,306      100.00

. label list i_wrkch21
i_wrkch21:
          -9 Missing
          -8 Inapplicable
          -2 Refusal
          -1 Don't know
           0 Not mentioned
           1 Mentioned

. gen childcare_9=1 if i_wrkch2a0==1
(148,911 missing values generated)

.
. replace childcare_9=2 if i_wrkch2a1==1| i_wrkch2a2==1| i_wrkch2a3==1| i_wrkch2a4==1| i_wrkch2a5==1| i_wrkch2a8==1| i_wrkch2a9==1| i_wrkch2a10==1| i_wrkch2a16==1| i_wrkch2a17==1| i_wrkch21==1| i_wrkch24==1| i_wrkch25==1| i_wrkch28==1| i_wrkch29==1| i_wrkch216==1| i_wrkch217==1
(1,849 real changes made)

.
. replace childcare_9=3 if i_wrkch2a6==1| i_wrkch2a7==1| i_wrkch2a11==1| i_wrkch2a12==1| i_wrkch2a13==1| i_wrkch2a14==1| i_wrkch2a15==1| i_wrkch26==1| i_wrkch27==1| i_wrkch211==1| i_wrkch212==1| i_wrkch213==1| i_wrkch214==1| i_wrkch215==1
(1,854 real changes made)

. tabulate childcare_9

childcare_9 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        494       14.22       14.22
          2 |      1,127       32.43       46.65
          3 |      1,854       53.35      100.00
------------+-----------------------------------
      Total |      3,475      100.00

. tabulate childcare_9 dropout_10
no observations

. tabulate i_employ

     In paid |
employment   |      Freq.     Percent        Cum.
-------------+-----------------------------------
     Missing |          6        0.01        0.01
Inapplicable |     10,316       19.58       19.59
     Refusal |        120        0.23       19.82
  Don't know |         68        0.13       19.95
         Yes |     24,395       46.30       66.24
          No |     17,786       33.76      100.00
-------------+-----------------------------------
       Total |     52,691      100.00

. tabulate employed_9 childcare_9
no observations

. tabulate childcare_9 employ_j
variable employ_j not found
r(111);

.  tabulate childcare_9 j_employ

childcare_ |  In paid employment
         9 | Inapplica         No |     Total
-----------+----------------------+----------
         1 |       436          2 |       438
         2 |     1,005          0 |     1,005
         3 |     1,694          2 |     1,696
-----------+----------------------+----------
     Total |     3,135          4 |     3,139

. tabulate childcare_9 i_employ

childcare_ | In paid employment
         9 |   Missing  Inapplica |     Total
-----------+----------------------+----------
         1 |         1        493 |       494
         2 |         0      1,127 |     1,127
         3 |         0      1,854 |     1,854
-----------+----------------------+----------
     Total |         1      3,474 |     3,475

. exit, clear