--------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  E:\Kerja\Farmasi Unpad\Data_IFLS\Latihan\Post test\post_test.log
  log type:  text
 opened on:  15 Jul 2021, 19:38:31

. /**********************
> Buku K
> **********************/
. use "$ifls5/bk_ar1.dta", clear 

. 
. *mendifine dataset
. keep if inlist(ar01a, 1,2,3,5,11)
(6,686 observations deleted)

. keep if  ar01i==1
(8,488 observations deleted)

. 
. *Sex
. recode ar07(3=0 "Perempuan")(1=1 "Laki-laki"), gen(sex)
(37368 differences between ar07 and sex)

. 
. *Pendidikan
. 
. keep if ar16!=99
(9 observations deleted)

. gen educyear=0 if ar16==1
(65,432 missing values generated)

. 
. *SD
. replace educyear = 0 if ar16 == 2 & ar17 == 0
(1,461 real changes made)

. replace educyear = 1 if ar16 == 2 & ar17 == 1
(1,951 real changes made)

. replace educyear = 2 if ar16 == 2 & ar17 == 2
(2,383 real changes made)

. replace educyear = 3 if ar16 == 2 & ar17 == 3
(2,314 real changes made)

. replace educyear = 4 if ar16 == 2 & ar17 == 4
(2,312 real changes made)

. replace educyear = 5 if ar16 == 2 & ar17 == 5
(1,791 real changes made)

. replace educyear = 6 if ar16 == 2 & ar17 == 6
(46 real changes made)

. replace educyear = 6 if ar16 == 2 & ar17 == 7
(8,786 real changes made)

. 
. *Madrasah
. replace educyear = 0 if ar16 == 72 & ar17 == 0
(123 real changes made)

. replace educyear = 1 if ar16 == 72 & ar17 == 1
(135 real changes made)

. replace educyear = 2 if ar16 == 72 & ar17 == 2
(146 real changes made)

. replace educyear = 3 if ar16 == 72 & ar17 == 3
(123 real changes made)

. replace educyear = 4 if ar16 == 72 & ar17 == 4
(113 real changes made)

. replace educyear = 5 if ar16 == 72 & ar17 == 5
(99 real changes made)

. replace educyear = 6 if ar16 == 72 & ar17 == 6
(3 real changes made)

. replace educyear = 6 if ar16 == 72 & ar17 == 7
(332 real changes made)

. 
. *Paket A
. replace educyear = 6 if ar16 == 11 & ar17 == 7
(20 real changes made)

. replace educyear = 0 if ar16 == 11 & ar17 > 7
(0 real changes made)

. replace educyear = 0 if ar16 == 11 & ar17 < 7
(3 real changes made)

. 
. 
. *SMP
. replace educyear = 6 if ar16 == 3 & ar17 == 0
(1,215 real changes made)

. replace educyear = 7 if ar16 == 3 & ar17 == 1
(1,607 real changes made)

. replace educyear = 8 if ar16 == 3 & ar17 == 2
(1,423 real changes made)

. replace educyear = 9 if ar16 == 3 & ar17 == 3
(26 real changes made)

. replace educyear = 9 if ar16 == 3 & ar17 == 7
(6,388 real changes made)

. 
. *SMP Kejuruan
. replace educyear = 6 if ar16 == 4 & ar17 == 0
(10 real changes made)

. replace educyear = 7 if ar16 == 4 & ar17 == 1
(15 real changes made)

. replace educyear = 8 if ar16 == 4 & ar17 == 2
(16 real changes made)

. replace educyear = 9 if ar16 == 4 & ar17 == 3
(1 real change made)

. replace educyear = 9 if ar16 == 4 & ar17 == 7
(86 real changes made)

. 
. *Paket B
. replace educyear = 9 if ar16 == 12 & ar17 == 7
(94 real changes made)

. replace educyear = 6 if ar16 == 12 & ar17 > 7
(0 real changes made)

. replace educyear = 6 if ar16 == 12 & ar17 < 7
(21 real changes made)

. 
. *MTs
. replace educyear = 6 if ar16 == 73 & ar17 == 0
(270 real changes made)

. replace educyear = 7 if ar16 == 73 & ar17 == 1
(372 real changes made)

. replace educyear = 8 if ar16 == 73 & ar17 == 2
(325 real changes made)

. replace educyear = 9 if ar16 == 73 & ar17 == 3
(7 real changes made)

. replace educyear = 9 if ar16 == 73 & ar17 == 7
(1,237 real changes made)

. 
. *SMA
. replace educyear = 9 if ar16 == 5 & ar17 == 0
(573 real changes made)

. replace educyear = 10 if ar16 == 5 & ar17 == 1
(723 real changes made)

. replace educyear = 11 if ar16 == 5 & ar17 == 2
(591 real changes made)

. replace educyear = 12 if ar16 == 5 & ar17 == 3
(12 real changes made)

. replace educyear = 12 if ar16 == 5 & ar17 == 7
(7,908 real changes made)

. 
. *SMK
. replace educyear = 9 if ar16 == 6 & ar17 == 0
(473 real changes made)

. replace educyear = 10 if ar16 == 6 & ar17 == 1
(483 real changes made)

. replace educyear = 11 if ar16 == 6 & ar17 == 2
(481 real changes made)

. replace educyear = 12 if ar16 == 6 & ar17 == 3
(14 real changes made)

. replace educyear = 12 if ar16 == 6 & ar17 == 7
(5,649 real changes made)

. 
. *MA
. replace educyear = 9 if ar16 == 74 & ar17 == 0
(130 real changes made)

. replace educyear = 10 if ar16 == 74 & ar17 == 1
(153 real changes made)

. replace educyear = 11 if ar16 == 74 & ar17 == 2
(121 real changes made)

. replace educyear = 12 if ar16 == 74 & ar17 == 3
(2 real changes made)

. replace educyear = 12 if ar16 == 74 & ar17 == 7
(1,029 real changes made)

. 
. *Paket C
. replace educyear = 12 if ar16 == 15 & ar17 == 7
(236 real changes made)

. replace educyear = 9 if ar16 == 15 & ar17 > 7
(1 real change made)

. replace educyear = 9 if ar16 == 15 & ar17 < 7
(31 real changes made)

. 
. *Vokasi
. replace educyear = 12 if ar16 == 60 & ar17 == 0
(120 real changes made)

. replace educyear = 13 if ar16 == 60 & ar17 == 1
(134 real changes made)

. replace educyear = 14 if ar16 == 60 & ar17 == 2
(124 real changes made)

. replace educyear = 15 if ar16 == 60 & ar17 == 3
(34 real changes made)

. replace educyear = 14 if ar16 == 60 & ar17 == 7
(1,641 real changes made)

. 
. *S1
. replace educyear = 12 if ar16 == 61 & ar17 == 0
(416 real changes made)

. replace educyear = 13 if ar16 == 61 & ar17 == 1
(409 real changes made)

. replace educyear = 14 if ar16 == 61 & ar17 == 2
(411 real changes made)

. replace educyear = 15 if ar16 == 61 & ar17 == 3
(423 real changes made)

. replace educyear = 16 if ar16 == 61 & ar17 == 4
(152 real changes made)

. replace educyear = 16 if ar16 == 61 & ar17 == 5
(30 real changes made)

. replace educyear = 16 if ar16 == 61 & ar17 == 6
(47 real changes made)

. replace educyear = 16 if ar16 == 61 & ar17 == 7
(3,663 real changes made)

. 
. *S1 UT
. replace educyear = 12 if ar16 == 13 & ar17 == 0
(8 real changes made)

. replace educyear = 13 if ar16 == 13 & ar17 == 1
(4 real changes made)

. replace educyear = 14 if ar16 == 13 & ar17 == 2
(5 real changes made)

. replace educyear = 15 if ar16 == 13 & ar17 == 3
(3 real changes made)

. replace educyear = 16 if ar16 == 13 & ar17 == 4
(4 real changes made)

. replace educyear = 16 if ar16 == 13 & ar17 == 5
(0 real changes made)

. replace educyear = 16 if ar16 == 13 & ar17 == 6
(0 real changes made)

. replace educyear = 16 if ar16 == 13 & ar17 == 7
(11 real changes made)

. 
. *S2
. replace educyear = 16 if ar16 == 62 & ar17 == 0
(28 real changes made)

. replace educyear = 17 if ar16 == 62 & ar17 == 1
(41 real changes made)

. replace educyear = 18 if ar16 == 62 & ar17 == 2
(16 real changes made)

. replace educyear = 18 if ar16 == 62 & ar17 == 7
(284 real changes made)

. 
. *S2
. replace educyear = 18 if ar16 == 63 & ar17 == 0
(4 real changes made)

. replace educyear = 19 if ar16 == 63 & ar17 == 1
(2 real changes made)

. replace educyear = 20 if ar16 == 63 & ar17 == 2
(3 real changes made)

. replace educyear = 21 if ar16 == 63 & ar17 == 3
(1 real change made)

. replace educyear = 22 if ar16 == 63 & ar17 == 4
(0 real changes made)

. replace educyear = 20 if ar16 == 63 & ar17 == 7
(14 real changes made)

. 
. *jumlah anggota keluarga
. gen bantu=1

. bys hhid*: egen famsize=total(bantu)

. 
. *Status Pernikahan
. recode  ar13(2=1 "Married")(min/max=0 "Unmarried"), gen(marstat)
(74199 differences between ar13 and marstat)

. 
. keep marstat educyear famsize sex pid* hhid*

. tempfile data_master14

. save `data_master14', replace 
(note: file C:\Users\ALESHA~1\AppData\Local\Temp\ST_2074_000001.tmp not found)
file C:\Users\ALESHA~1\AppData\Local\Temp\ST_2074_000001.tmp saved

. 
. *Tempat tinggal
. use "$ifls5/bk_sc1.dta", clear 

. recode sc05(2=0 "Pedesaan")(1=1 "Perkotaan"), gen(res)
(6339 differences between sc05 and res)

. keep res hhid*

. tempfile residence14

. save `residence14', replace 
(note: file C:\Users\ALESHA~1\AppData\Local\Temp\ST_2074_000002.tmp not found)
file C:\Users\ALESHA~1\AppData\Local\Temp\ST_2074_000002.tmp saved

. 
. *Depresi
. use "$ifls5/b3b_kp.dta", clear 

. keep hhid* pid* kp02 kptype

. reshape wide kp02 , i(hhid14 pid14) j(kptype ) str
(note: j = A B C D E F G H I J)

Data                               long   ->   wide
-----------------------------------------------------------------------------
Number of obs.                   314470   ->   31447
Number of variables                   6   ->      14
j variable (10 values)           kptype   ->   (dropped)
xij variables:
                                   kp02   ->   kp02A kp02B ... kp02J
-----------------------------------------------------------------------------

. foreach i in kp02A kp02B kp02C kp02D kp02F kp02G kp02I {
  2. recode `i' (1=0) (2=1) (3=2) (4=3)
  3. }
(kp02A: 31447 changes made)
(kp02B: 31447 changes made)
(kp02C: 31447 changes made)
(kp02D: 31447 changes made)
(kp02F: 31447 changes made)
(kp02G: 31447 changes made)
(kp02I: 31447 changes made)

. egen dep14 = rowmean(kp02A kp02B kp02C kp02D kp02F kp02G kp02I )

. keep pid* hhid* dep14

. tempfile depresi14

. save `depresi14', replace
(note: file C:\Users\ALESHA~1\AppData\Local\Temp\ST_2074_000003.tmp not found)
file C:\Users\ALESHA~1\AppData\Local\Temp\ST_2074_000003.tmp saved

. 
. *Religiusitas
. use "$ifls5/b3a_tr", clear 

. recode  tr11(1 2 3 =1 "Religius")(4 7=0 "Tidak Religius"), gen(religius14)
(26432 differences between tr11 and religius14)

. keep pid* hhid* religius14

. tempfile religiusitas14

. save `religiusitas14', replace
(note: file C:\Users\ALESHA~1\AppData\Local\Temp\ST_2074_000004.tmp not found)
file C:\Users\ALESHA~1\AppData\Local\Temp\ST_2074_000004.tmp saved

. 
. *Perhiasan
. use "$ifls5/b2_hr1", clear 

. keep if hr01!=9
(19 observations deleted)

. keep if hrtype == "J"
(182,119 observations deleted)

. recode hr01(1=1 "Memiliki")(3=0 "Tidak Memiliki"), gen(jel14)
(8145 differences between hr01 and jel14)

. keep hhid* jel14

. tempfile perhiasan14

. save `perhiasan14', replace
(note: file C:\Users\ALESHA~1\AppData\Local\Temp\ST_2074_000005.tmp not found)
file C:\Users\ALESHA~1\AppData\Local\Temp\ST_2074_000005.tmp saved

. 
. *Bahasa Indonesia
. use "$ifls5/b3a_dl1", clear 

. global  alfabet A B C D E F G H I J K L M N O P Q R S T U V W 

. foreach y in $alfabet{
  2. gen bahasa_`y'= regexm( dl01a, "`y'")
  3. }

. recode bahasa_W(1=1 "Bahasa Indonesia")(0=0 "Bahasa Lainnya"), gen(bahasa_ind14)
(0 differences between bahasa_W and bahasa_ind14)

. keep pid* hhid* bahasa_ind14

. tempfile bahasa14

. save `bahasa14', replace
(note: file C:\Users\ALESHA~1\AppData\Local\Temp\ST_2074_000006.tmp not found)
file C:\Users\ALESHA~1\AppData\Local\Temp\ST_2074_000006.tmp saved

. 
. *Donasi
. use "$ifls5/b1_ks3", clear 

. keep if ks3type=="D"
(90,834 observations deleted)

. keep hhid* ks08

. rename ks08 donasi

. tempfile donasi14

. save `donasi14', replace
(note: file C:\Users\ALESHA~1\AppData\Local\Temp\ST_2074_000007.tmp not found)
file C:\Users\ALESHA~1\AppData\Local\Temp\ST_2074_000007.tmp saved

. 
. use `data_master14', clear 

. merge m:1 hhid14_9 using `residence14'

    Result                           # of obs.
    -----------------------------------------
    not matched                            37
        from master                         0  (_merge==1)
        from using                         37  (_merge==2)

    matched                            74,199  (_merge==3)
    -----------------------------------------

. drop if _merge ==2
(37 observations deleted)

. drop _merge

. 
. merge 1:1 hhid14_9 pid14 using `depresi14'

    Result                           # of obs.
    -----------------------------------------
    not matched                        42,758
        from master                    42,755  (_merge==1)
        from using                          3  (_merge==2)

    matched                            31,444  (_merge==3)
    -----------------------------------------

. drop if _merge ==2
(3 observations deleted)

. drop _merge

. 
. merge 1:1 hhid14_9 pid14 using `religiusitas14'

    Result                           # of obs.
    -----------------------------------------
    not matched                        42,543
        from master                    42,540  (_merge==1)
        from using                          3  (_merge==2)

    matched                            31,659  (_merge==3)
    -----------------------------------------

. drop if _merge ==2
(3 observations deleted)

. drop _merge

. 
. merge m:1 hhid14_9 using `perhiasan14'

    Result                           # of obs.
    -----------------------------------------
    not matched                         1,906
        from master                     1,906  (_merge==1)
        from using                          0  (_merge==2)

    matched                            72,293  (_merge==3)
    -----------------------------------------

. drop if _merge ==2
(0 observations deleted)

. drop _merge

. 
. merge m:1 hhid14_9 pid14 using `bahasa14'

    Result                           # of obs.
    -----------------------------------------
    not matched                        39,743
        from master                    39,739  (_merge==1)
        from using                          4  (_merge==2)

    matched                            34,460  (_merge==3)
    -----------------------------------------

. drop if _merge ==2
(4 observations deleted)

. drop _merge

. 
. merge m:1 hhid14_9 using `donasi14'

    Result                           # of obs.
    -----------------------------------------
    not matched                         2,076
        from master                     2,076  (_merge==1)
        from using                          0  (_merge==2)

    matched                            72,123  (_merge==3)
    -----------------------------------------

. drop if _merge ==2
(0 observations deleted)

. drop _merge

. 
. save "$simpan\data_posttest", replace 
file E:\Kerja\Farmasi Unpad\Data_IFLS\Latihan\Post test\data_posttest.dta saved

. capture log close /*Untuk menutup log file*/