---------------------------------------------------------------- name: log: C:\Users\Christine\Desktop\Christine_drive\Hasil\lo > gfile_penelitian.log log type: text opened on: 15 Jul 2021, 18:18:53 . . /************************* > Manajemen Input Output > **************************/ . global ifls5 "C:\Users\Christine\Desktop\IFLS\IFLS\DATA\2014\H > H" . global ifls51 "C:\Users\Christine\Desktop\IFLS-20210710T075032 > Z-001\IFLS\IFLS5\DATA_IFLS5HH" . global Christine_drive "C:\Users\Christine\Desktop\Christine_d > rive\Hasil" . . cd "C:\Users\Christine\Desktop\Christine_drive\Hasil" C:\Users\Christine\Desktop\Christine_drive\Hasil . . /************************** > Buku K - SEKSI AR > **************************/ . use "$ifls5/bk_ar1.dta", clear . . keep if inlist(ar01a, 1,2,5,11) (31,070 observations deleted) . keep if ar01i==1 (5,725 observations deleted) . . *sex (Jenis kelamin) . recode ar07 (3=0 "Perempuan") (1=1 "Laki-laki"), gen(sex) (26683 differences between ar07 and sex) . . *marstat (status perkawinan) . recode ar13 (6=.)(1=0 "Belum menikah") (3=1 "Cerai") (4=1 "Ce > rai") (5=1 "Cerai") (2=2 "Menikah"), gen(marstat) (26784 differences between ar13 and marstat) . . *Tingkat Pendidikan . . *Tidak/Belum Pernah Sekolah/0 tahun . gen yos = 0 if ar16 == 1 (44,293 missing values generated) . . *SD/6 tahun . replace yos = 0 if ar16 == 2 & ar17 == 0 (1,323 real changes made) . replace yos = 1 if ar16 == 2 & ar17 == 1 (1,663 real changes made) . replace yos = 2 if ar16 == 2 & ar17 == 2 (1,981 real changes made) . replace yos = 3 if ar16 == 2 & ar17 == 3 (1,909 real changes made) . replace yos = 4 if ar16 == 2 & ar17 == 4 (1,878 real changes made) . replace yos = 5 if ar16 == 2 & ar17 == 5 (1,507 real changes made) . replace yos = 6 if ar16 == 2 & ar17 == 6 (36 real changes made) . replace yos = 6 if ar16 == 2 & ar17 == 7 (5,598 real changes made) . replace yos = 6 if ar16 == 11 (16 real changes made) . . *MI/6 tahun . replace yos = 0 if ar16 == 72 & ar17 == 0 (117 real changes made) . replace yos = 1 if ar16 == 72 & ar17 == 1 (124 real changes made) . replace yos = 2 if ar16 == 72 & ar17 == 2 (130 real changes made) . replace yos = 3 if ar16 == 72 & ar17 == 3 (108 real changes made) . replace yos = 4 if ar16 == 72 & ar17 == 4 (106 real changes made) . replace yos = 5 if ar16 == 72 & ar17 == 5 (94 real changes made) . replace yos = 6 if ar16 == 72 & ar17 == 6 (3 real changes made) . replace yos = 6 if ar16 == 72 & ar17 == 7 (232 real changes made) . . *SMP Umum/3 tahun . replace yos = 7 if ar16 == 3 & ar17 == 1 (1,240 real changes made) . replace yos = 8 if ar16 == 3 & ar17 == 2 (1,106 real changes made) . replace yos = 9 if ar16 == 3 & ar17 == 3 (20 real changes made) . replace yos = 9 if ar16 == 3 & ar17 == 7 (3,882 real changes made) . replace yos = 9 if ar16 == 12 (95 real changes made) . . *SMP Kejuruan/3 tahun . replace yos = 7 if ar16 == 4 & ar17 == 1 (14 real changes made) . replace yos = 8 if ar16 == 4 & ar17 == 2 (13 real changes made) . replace yos = 9 if ar16 == 4 & ar17 == 3 (1 real change made) . replace yos = 9 if ar16 == 4 & ar17 == 7 (59 real changes made) . . *SMU/3 tahun . replace yos = 10 if ar16 == 5 & ar17 == 1 (493 real changes made) . replace yos = 11 if ar16 == 5 & ar17 == 2 (397 real changes made) . replace yos = 12 if ar16 == 5 & ar17 == 3 (8 real changes made) . replace yos = 12 if ar16 == 5 & ar17 == 7 (4,647 real changes made) . replace yos = 12 if ar16 == 15 (198 real changes made) . . *SMK/3 tahun . replace yos = 10 if ar16 == 6 & ar17 == 1 (370 real changes made) . replace yos = 11 if ar16 == 6 & ar17 == 2 (364 real changes made) . replace yos = 12 if ar16 == 6 & ar17 == 3 (10 real changes made) . replace yos = 12 if ar16 == 6 & ar17 == 7 (3,549 real changes made) . . *D1/D2/D3/3 tahun . replace yos = 13 if ar16 == 60 & ar17 == 1 (88 real changes made) . replace yos = 14 if ar16 == 60 & ar17 == 2 (81 real changes made) . replace yos = 15 if ar16 == 60 & ar17 == 3 (22 real changes made) . replace yos = 15 if ar16 == 60 & ar17 == 7 (1,042 real changes made) . . *S1/4 tahun . replace yos = 13 if ar16 == 61 & ar17 == 1 (255 real changes made) . replace yos = 14 if ar16 == 61 & ar17 == 2 (246 real changes made) . replace yos = 15 if ar16 == 61 & ar17 == 3 (272 real changes made) . replace yos = 16 if ar16 == 61 & ar17 == 4 (91 real changes made) . replace yos = 16 if ar16 == 61 & ar17 == 5 (25 real changes made) . replace yos = 16 if ar16 == 61 & ar17 == 6 (29 real changes made) . replace yos = 16 if ar16 == 61 & ar17 == 7 (2,239 real changes made) . . *S2/3 tahun . replace yos = 17 if ar16 == 62 & ar17 == 1 (27 real changes made) . replace yos = 18 if ar16 == 62 & ar17 == 2 (11 real changes made) . replace yos = 19 if ar16 == 62 & ar17 == 3 (3 real changes made) . replace yos = 19 if ar16 == 62 & ar17 == 7 (168 real changes made) . . *S3/3 tahun . replace yos = 19 if ar16 == 63 & ar17 == 1 (2 real changes made) . replace yos = 20 if ar16 == 63 & ar17 == 2 (3 real changes made) . replace yos = 21 if ar16 == 63 & ar17 == 3 (1 real change made) . replace yos = 22 if ar16 == 63 & ar17 == 7 (7 real changes made) . . . . *Education Year . gen educ_year = 1 if yos == 0 /*0 tahun*/ (42,353 missing values generated) . replace educ_year = 2 if yos >=1 & yos <=6 /*6 tahun*/ (15,385 real changes made) . replace educ_year = 3 if yos >=7 & yos <=9 /*9 tahun*/ (6,430 real changes made) . replace educ_year = 4 if yos >=10 & yos <=12 /*12 tahun*/ (10,036 real changes made) . replace educ_year = 5 if yos >=13 & yos <=22 /*22 tahun*/ (4,612 real changes made) . . la val educ_year educ_year . lab def educ_year 1 "0 tahun" 2 "6 tahun" 3 "9 tahun" 4 "12 ta > hun" 5 "22 tahun" . . /******************************** > High Level Educ > ********************************/ . gen high_educ = 1 if yos >= 10 & yos <= 22 /*10-22 tahun*/ (37,939 missing values generated) . replace high_educ = 0 if yos >= 1 & yos <= 9 /*1-9 tahun*/ (21,815 real changes made) . . la val high_educ high_educ . lab def high_educ 1 "10-22 tahun" 0 "1-9 tahun" . . . *Famsize . gen bantu=1 . bys hhid14:egen famsize=sum(bantu) . . keep pid* hhid* high_educ educ_year yos marstat sex famsize . save "$Christine_drive/dataset_14", replace file C:\Users\Christine\Desktop\Christine_drive\Hasil/dataset_14 > .dta saved . . . /************************** > Buku K - SEKSI SC > **************************/ . . use "$ifls5/bk_sc1", clear . . keep hhid* sc05 . . *res (Tempat tinggal ) . recode sc05 (2=0 "Pendesaan") (1=1 "Perkotaan"), gen(Res) (6339 differences between sc05 and Res) . . save "$Christine_drive/tempat_tinggal", replace file C:\Users\Christine\Desktop\Christine_drive\Hasil/tempat_tin > ggal.dta saved . . . . /******************************** > Depresi > ********************************/ . use "$ifls51\b3b_kp",clear . . *cek duplikasi . duplicates report hhid14 pid14 Duplicates in terms of hhid14 pid14 -------------------------------------- copies | observations surplus ----------+--------------------------- 10 | 314470 283023 -------------------------------------- . *mempertahankan variabel . keep hhid* pid* kp02 kptype . *reshaping data . 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 ... k > p02J ---------------------------------------------------------------- > ------------- . *menghilangkan data E,H,J . drop kp02E kp02H kp02J . *merata-ratakan . gen rata_rata = (kp02A + kp02B + kp02C + kp02D + kp02F + kp02G > + kp02I)/7 . . . *simpan data . save "$Christine_drive/depresi", replace file C:\Users\Christine\Desktop\Christine_drive\Hasil/depresi.dt > a saved . . /******************************** > Relijiusitas > ********************************/ . use "$ifls51/b3a_tr", clear . keep pid* hhid* tr11 . . *relijius (Relijiusitas) . recode tr11 (7=.)(3=0 "Tidak Relijius") (4=0 "Tidak Relijius") > (1=1 "Relijius") (2=1 "Relijius"), gen (relijius) (26432 differences between tr11 and relijius) . save "$Christine_drive/relijiusitas", replace file C:\Users\Christine\Desktop\Christine_drive\Hasil/relijiusit > as.dta saved . . . /******************************** > Kepemilikan Perhiasan > ********************************/ . use "$ifls51/b3a_hr1", clear . keep hhid* pid* hr01 hr1type . keep if hr1type=="J" (137,124 observations deleted) . recode hr01 (8=.)(3=0 "Tidak memiliki") (1=1 "Memiliki"), gen( > perhiasan) (5024 differences between hr01 and perhiasan) . . save "$Christine_drive/kepemilikan_perhiasan", replace file C:\Users\Christine\Desktop\Christine_drive\Hasil/kepemilika > n_perhiasan.dta saved . . . /******************************** > Donasi > ********************************/ . use "$ifls5/b1_ks3", clear . keep if ks3type=="D" (90,834 observations deleted) . keep hhid* ks08 . rename ks08 Donasi . . save "$Christine_drive/donasi", replace file C:\Users\Christine\Desktop\Christine_drive\Hasil/donasi.dta > saved . . /******************************** > Bahasa > ********************************/ . use "$ifls51/b3a_dl1", clear . gen bahasa_indo = regexm(dl01a, "W") . lab def bahasa_indo 0 "Tidak Menggunakan Bahasa Indonesia" 1 " > Menggunakan Bahasa Indonesia" . lab val bahasa_indo bahasa_indo . . save "$Christine_drive/bahasa", replace file C:\Users\Christine\Desktop\Christine_drive\Hasil/bahasa.dta > saved . . . /******************************** > Merging Data > ********************************/ . use "$Christine_drive/dataset_14", clear . merge 1:1 hhid14 pid14 using "$Christine_drive/relijiusitas" Result # of obs. ----------------------------------------- not matched 20,935 from master 20,930 (_merge==1) from using 5 (_merge==2) matched 31,657 (_merge==3) ----------------------------------------- . drop _merge . . merge m:1 hhid14 using "$Christine_drive/donasi" Result # of obs. ----------------------------------------- not matched 793 from master 791 (_merge==1) from using 2 (_merge==2) matched 51,801 (_merge==3) ----------------------------------------- . drop _merge . . merge 1:1 hhid14 pid14 using "$Christine_drive/bahasa" Result # of obs. ----------------------------------------- not matched 18,134 from master 18,132 (_merge==1) from using 2 (_merge==2) matched 34,462 (_merge==3) ----------------------------------------- . drop _merge . . merge 1:1 hhid14 pid14 using "$Christine_drive/kepemilikan_per > hiasan" Result # of obs. ----------------------------------------- not matched 41,169 from master 41,169 (_merge==1) from using 0 (_merge==2) matched 11,427 (_merge==3) ----------------------------------------- . drop _merge . . merge m:1 hhid14 using "$Christine_drive/tempat_tinggal)" Result # of obs. ----------------------------------------- not matched 570 from master 0 from using 570 matched 52,596 ----------------------------------------- . drop _merge . . merge 1:1 hhid14 pid14 using "$Christine_drive/depresi" Result # of obs. ----------------------------------------- not matched 21,719 from master 21,719 (_merge==1) from using 0 (_merge==2) matched 31,447 (_merge==3) ----------------------------------------- . drop _merge . end of do-file . save "C:\Users\Christine\Desktop\Christine_drive\Tugas IFLS Po > st Test Stata Data.dta" file C:\Users\Christine\Desktop\Christine_drive\Tugas IFLS Post > Test Stata Data.dta saved . exit