----------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  D:\Economic Data\LATIHAN IFLS\PROJECT\3.HASIL\log file penelitian.log
  log type:  text
 opened on:  31 May 2021, 23:38:44

. *-----------------------------------------------------
. 
. 
. 
. *==========================DATA SET========================
. 
. 
. *----------------sex, maristat, famsize, educyear------------
. 
. *variabel jenis kelamin*
. use "$ifls5\bk_ar1", replace

. recode ar07(1=1 "male")(3=0 "female"), gen(sex)
(41802 differences between ar07 and sex)

. 
. *variabel maristat*
. recode ar13 (1=0 "belum menikah")(4=1 "cerai")(2=2 "menikah"),gen(maristat)
(32794 differences between ar13 and maristat)

. 
. *variabel ukuran RT*
. gen bantu=1

. bys hhid14_9: egen famsize=sum(bantu)

. 
. *variabel pendidikan*
. 
. gen educyear=0 if ar16==1
(79,826 missing values generated)

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

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

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

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

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

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

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

. replace educyear = 7 if ar16 == 2 & ar17 == 7
(10,065 real changes made)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

. replace educyear = 7 if ar16 == 4 & ar17 == 1
(17 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
(100 real changes made)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

. replace educyear = 16 if ar16 == 61 & ar17 == 7
(4,153 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
(5 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 S3
. replace educyear = 16 if ar16 == 62
(442 real changes made)

. replace educyear = 16 if ar16 == 63
(35 real changes made)

. 
. //pendidikan berdasarkan jenjang edukasi
. gen educ=0 if educyear <= 6
(63,534 missing values generated)

. replace educ=1 if educyear >=7 & educyear <=9
(24,115 real changes made)

. replace educ=2 if educyear >=10 & educyear <=12
(19,795 real changes made)

. replace educ=3 if educyear >=13 & educyear <=14
(3,008 real changes made)

. la val educ educ

. lab def educ 0 "SD/sederajat" 1 "SMP/sederajat" 2 "SMA/sederajat" 3 "Universitas/sederajat"

. 
. //pendidikan berdasarkan sekolah rendah dan sekolah tinggi
. gen pendidikan=0 if educyear <=12
(19,624 missing values generated)

. replace pendidikan=1 if educyear >=13 & educyear <=16
(8,406 real changes made)

. la val pendidikan pendidikan

. lab def pendidikan 0 "0:pendidikan rendah" 1 "1:pendidikan tinggi"

. 
. 
. keep sex maristat famsize educyear educ pendidikan hhid* pid*

. 
. save"$hasil\data1", replace
file D:\Economic Data\LATIHAN IFLS\PROJECT\3.HASIL\data1.dta saved

. 
. 
. *_______________________________________________________________
. 
. 
. 
. *-------------------------tempat tinggal------------------------
. *variabel tempat tinggal*
. use "$ifls5\bk_sc1", replace

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

. 
. keep res hhid*

. 
. save "$hasil\data2", replace
file D:\Economic Data\LATIHAN IFLS\PROJECT\3.HASIL\data2.dta saved

. 
. *_______________________________________________________________
. 
. 
. 
. *-------------------------relijiusitas------------------------
. *variabel relijiusitas*
. use "$ifls5\b3a_tr", replace

. recode tr11 (1 2=1 "relijius")(3 4=0 "tidak relijius"), gen(relijius)
(26374 differences between tr11 and relijius)

. 
. keep relijius hhid* pid*

. 
. save "$hasil\data3", replace
file D:\Economic Data\LATIHAN IFLS\PROJECT\3.HASIL\data3.dta saved

. 
. *_______________________________________________________________
. 
. 
. 
. *-------------------kepemilikan perhiasan------------------------
. *variabel perhiasan*
. use "$ifls5\b3a_hr1", replace

. keep hr01 hr1type pid* hhid*

. reshape wide hr01, i(pidlink) j(hr1type) string
(note: j = A B C D1 D2 D3 E F G H J K1 K2)

Data                               long   ->   wide
-----------------------------------------------------------------------------
Number of obs.                   148551   ->   11427
Number of variables                   6   ->      17
j variable (13 values)          hr1type   ->   (dropped)
xij variables:
                                   hr01   ->   hr01A hr01B ... hr01K2
-----------------------------------------------------------------------------

. recode hr01J (1=1 "memiliki perhiasan")(3=0 "tidak memiliki perhiasan"), gen(perhiasan)
(4986 differences between hr01J and perhiasan)

. 
. keep perhiasan hhid* pid*

. 
. save "$hasil\data4", replace
file D:\Economic Data\LATIHAN IFLS\PROJECT\3.HASIL\data4.dta saved

. 
. *_______________________________________________________________
. 
. 
. 
. *---------------------------donasi-------------------------------
. *variabel donasi*
. use "$ifls5\b1_ks3", replace

. keep ks3type ks08 hhid*

. reshape wide ks08, i(hhid14_9) j(ks3type) string
(note: j = A B C D E F G)

Data                               long   ->   wide
-----------------------------------------------------------------------------
Number of obs.                   105973   ->   15139
Number of variables                   4   ->       9
j variable (7 values)           ks3type   ->   (dropped)
xij variables:
                                   ks08   ->   ks08A ks08B ... ks08G
-----------------------------------------------------------------------------

. gen donasi=(ks08D)
(40 missing values generated)

. 
. keep donasi hhid*

. 
. save "$hasil\data5", replace
file D:\Economic Data\LATIHAN IFLS\PROJECT\3.HASIL\data5.dta saved

. 
. *_______________________________________________________________
. 
. 
. 
. *---------------------------bahasa-------------------------------
. *variabel bahasa*
. use "$ifls5\b3a_dl1", replace

. 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 i in alfabet {
  2. gen dummy_bahasa`i' = regexm(dl01a, "`i''")
  3. }

. recode dummy_bahasa (1=1 "Bahasa Inggris")(0=0 "tidak menggunakan Bahasa Inggris"), gen(bahasa)
(0 differences between dummy_bahasaalfabet and bahasa)

. 
. keep bahasa hhid* pid*

. 
. save "$hasil\data6", replace
file D:\Economic Data\LATIHAN IFLS\PROJECT\3.HASIL\data6.dta saved

. 
. *_______________________________________________________________
. 
. 
. use "$hasil\data1", replace

. merge m:1 pidlink using "$hasil\data3"

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

    matched                            42,544  (_merge==3)
    -----------------------------------------

. keep if _m==3
(46,838 observations deleted)

. save "$hasil\merge1&3", replace
file D:\Economic Data\LATIHAN IFLS\PROJECT\3.HASIL\merge1&3.dta saved

. 
. 
. use "$hasil\merge1&3", replace

. drop _merge

. merge m:1 pidlink using "$hasil\data4"

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

    matched                            14,875  (_merge==3)
    -----------------------------------------

. keep if _m==3
(27,669 observations deleted)

. save "$hasil\merge1,3,4", replace
file D:\Economic Data\LATIHAN IFLS\PROJECT\3.HASIL\merge1,3,4.dta saved

. 
. 
. use "$hasil\merge1,3,4", replace

. drop _merge

. merge m:1 pidlink using "$hasil\data6"

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

    matched                            14,875  (_merge==3)
    -----------------------------------------

. keep if _m==3
(23,037 observations deleted)

. drop _merge

. save "$hasil\merge1,3,4,6", replace
file D:\Economic Data\LATIHAN IFLS\PROJECT\3.HASIL\merge1,3,4,6.dta saved

. 
. 
. use "$hasil\data2", replace

. merge m:1 hhid14 using "$hasil\data5"

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

    matched                            15,139  (_merge==3)
    -----------------------------------------

. keep if _m==3
(782 observations deleted)

. drop _merge

. save "$hasil\merge2&5", replace
file D:\Economic Data\LATIHAN IFLS\PROJECT\3.HASIL\merge2&5.dta saved

. 
end of do-file

. use "$hasil\merge2&5", replace

. merge 1:m hhid14_9 using "$hasil\merge1,3,4,6"

    Result                           # of obs.
    -----------------------------------------
    not matched                         4,918
        from master                     4,707  (_merge==1)
        from using                        211  (_merge==2)

    matched                            14,664  (_merge==3)
    -----------------------------------------

. keep if _m==3
(4,918 observations deleted)

. drop _merge

. save "$hasil\dataset", replace
(note: file D:\Economic Data\LATIHAN IFLS\PROJECT\3.HASIL\dataset.dta not found)
file D:\Economic Data\LATIHAN IFLS\PROJECT\3.HASIL\dataset.dta saved