clear all use "\\ad.ucl.ac.uk\homee\qtnvmve\Documents\marga\CANADA\original\original\data\main.dta" sort PUMFI * COUNTRY* gen str2 country="CA" *SURVEY* gen survey=2015 *SWAVE* gen swave=0 *MSAMP* gen msamp=0 *HLID* gen hldid=0 *PERSID* gen persid=PUMFID *** INCORIG*** rename HHINCG1 incorig **REGION** rename PRV region *** EMPINCLM*** recode INCG1 (1=10000)(2=29500)(3=49999)(4=69999)(5=89999)(6=109999)(7=120000), gen(monthlyinc) gen empinclm=. replace empinclm=monthlyinc/12 if INCG1 <98 ***( this variable should be taken with precaution) *** ***OCCUPO*** rename NAIC12CW occupo replace occupo=-7 if occupo ==96 replace occupo=-8 if occupo ==97| occupo ==98|occupo ==99 ***EDUCA *** rename EHG_ALL educa *** ETHNIC*** gen ethnic=-9 ***migrantd** rename BRTHMACR migrantd replace migrantd=-8 if migrantd==7|migrantd==8|migrantd==9 ***migrantm** rename BRTHMCAN migrantm replace migrantm =-8 if migrantm ==7|migrantm ==8|migrantm ==9 ***migrantf** rename BRTHFCAN migrantf replace migrantf=-8 if migrantf==7|migrantf==8|migrantf==9 keep country survey swave msamp hldid persid incorig region empinclm occupo educa ethnic migrantd migrantm migrantf order country survey swave msamp hldid persid incorig region empinclm occupo educa ethnic migrantd migrantm migrantf save "D:\MTUS_X\MTUS_X_DAT_SUBMITT\canadian_2015_light diary\survey_ca_2015.dta", replace