cap log close log using SOEP_4_deskr, text replace use "SOEP_3_panel.dta", clear d tab wave sector_ost tab sector_ost, m replace sector_ost=13 if sector_ost==-2 & employed==0 //No sector information as not employed replace sector_ost=. if sector_ost<0 tab sector_ost, m tab sector_ost if wave==1990, m tab sector_ost if wave==1993, m tab sector_ost if wave==1990 gen help= sector_ost if wave==1990 bysort persnr: egen sectorost1990=mean(help) drop help gen help=sector_ost if wave==1993 bysort persnr: egen sectorost1993=mean(help) tab sectorost1993 drop help tab sectorost1993, m * Keeping observations with realised interviews only keep if relint==1 save SOEP_4_panel_deskr , replace ******************************************************************************** * Transition Matrix ******************************************************************************** preserve keep if wave==1990 | wave==1993 drop if sectorost1993==. bysort persnr: gen n1=_n keep if n1==1 tab sectorost1990 tab sectorost1993 count if sector_ost==1 & wave==1990 ******************************** matrix m = J(10,13,.) matrix rowname m = 1990 matrix colname m = 1993 local i=1 local j=1 foreach a of numlist 1/10 { foreach a of numlist 1/13 { count if sectorost1990==`i' & sectorost1993==`j' matrix m [`i',`j'] = r(N) local j=`j'+1 } local i=`i'+1 local j=1 } matrix list m restore ******************************************************************************** * Restricting the sample ******************************************************************************** * Keeping respondents only with valid information in dependent variables * and covariates in 1990 (except for PID which is only inlcuded since 1992) gen help2=. replace help2=1 if wave==1990 & female!=. & age!=. & firmtenure!=. & jobexp!=. & /// firmsize!=. & educ!=. & famstand_grob!=. & labgro!=. & log_stundenlohn!=. & workhours_week!=. /// & wohnen_west!=. & lzf!=. bysort persnr: egen sample_var=mean(help2) drop help2 keep if sample_var==1 tab sector_ost, m replace sector_ost=. if sector_ost>12 tab sector_ost, m tab wave sector_ost, m save, replace ******************************************************************************** * Descriptions over time ******************************************************************************** preserve keep if wave<2000 bysort wave: su labgro_defl if treat_dummy_highlow==0 & sample_var==1 bysort wave: su labgro_defl if treat_dummy_highlow==1 & sample_var==1 bysort wave: su workhours_week if treat_dummy_highlow==0 & sample_var==1 bysort wave: su workhours_week if treat_dummy_highlow==1 & sample_var==1 bysort wave: su not_employed if treat_dummy_highlow==0 & sample_var==1 bysort wave: su not_employed if treat_dummy_highlow==1 & sample_var==1 bysort wave: su log_stundenlohn_defl if treat_dummy_highlow==0 & sample_var==1 bysort wave: su log_stundenlohn_defl if treat_dummy_highlow==1 & sample_var==1 bysort wave: su labgro_defl if treat_dummy_highlow==0 & sample_var==1 & log_stundenlohn_defl!=. bysort wave: su labgro_defl if treat_dummy_highlow==1 & sample_var==1 & log_stundenlohn_defl!=. bysort wave: su workhours_week if treat_dummy_highlow==0 & sample_var==1 & log_stundenlohn_defl!=. bysort wave: su workhours_week if treat_dummy_highlow==1 & sample_var==1 & log_stundenlohn_defl!=. bysort wave: su lzf if treat_dummy_highlow==0 & sample_var==1 bysort wave: su lzf if treat_dummy_highlow==1 & sample_var==1 bysort wave: su wohnen_west if treat_dummy_highlow==0 & sample_var==1 bysort wave: su wohnen_west if treat_dummy_highlow==1 & sample_var==1 bysort wave: su pidyes if treat_dummy_highlow==0 & sample_var==1 bysort wave: su pidyes if treat_dummy_highlow==1 & sample_var==1 bysort wave: su rightpid if treat_dummy_highlow==0 & sample_var==1 bysort wave: su rightpid if treat_dummy_highlow==1 & sample_var==1 bysort wave: su leftpid if treat_dummy_highlow==0 & sample_var==1 bysort wave: su leftpid if treat_dummy_highlow==1 & sample_var==1 ******************************************************************************** * Covariate means in 1990 ******************************************************************************** su female if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su female if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su age if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su age if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su firmtenure if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su firmtenure if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su jobexp if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su jobexp if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su firmsizedummy1 if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su firmsizedummy1 if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su firmsizedummy2 if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su firmsizedummy2 if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su firmsizedummy3 if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su firmsizedummy3 if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su firmsizedummy4 if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su firmsizedummy4 if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su educdummy1 if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su educdummy1 if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su educdummy2 if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su educdummy2 if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su educdummy3 if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su educdummy3 if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su educdummy4 if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su educdummy4 if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su educdummy5 if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su educdummy5 if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su famstand_grobdummy1 if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su famstand_grobdummy1 if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su famstand_grobdummy2 if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su famstand_grobdummy2 if sample_var==1 & treat_dummy_highlow==1 & wave==1990 su famstand_grobdummy3 if sample_var==1 & treat_dummy_highlow==0 & wave==1990 su famstand_grobdummy3 if sample_var==1 & treat_dummy_highlow==1 & wave==1990 restore save, replace