#delimit; cap log close; clear all; capture clear; set more off, perm /* -------------------------------------------------------------------- */; /* This command file was generated by SOEPINFO-WWW */; /* from the SOEP HOMEPAGE: http://www.diw-berlin.de/soep. */; /* */; /* !!! I M P O R T A N T - W A R N I N G !!! */; /* You alone are responsible for contents and appropriate */; /* usage by accepting the usage agreement. */; /* --------------------------------------------------------------------- */; /* To copy this command file to your own harddisk: */; /* Use your mouse or (CNTL-A) to select this text, then "copy" */; /* (CNTL-C) then in your windows application, or in a text */; /* editor, "paste" (CNTL-V). */; /* -------------------------------------------------------------------- */; /* */; /* Please report any errors of the STATA code generated here */; /* to Jan Goebel */; /* -------------------------------------------------------------------- */; /* */; /* ----- Here you can customize the paths and options: ----- */; /* ----- Some further explanations: ----- */; /* The following */; /* */; /* global macros (in stata), */; /* file handles (in SPSS) or */; /* libnames (in SAS) */; /* */; /* define the locations for the original SOEP DATA, the directory */; /* for temporary files and the destination of the resulting data file. */; /* */; /* MY_IN_PATH = "path/to/your/SOEP/directory/" */; /* MY_OUT_PATH = "path/to/the/directory/for/the/resulting/file/" */; /* MY_TEMP_PATH = "path/to/the/directory/for/the/temporary/files/" */; /* */; /* The correct specification of the path depends on your Operating */; /* System and on your SOEP installation, but be sure to use a */; /* TRAILING backslash ("\", within Windows) or a */; /* TRAILING forward slash ("/", within Unix/Linux). */; /* */; /* You can also change the name for the resulting data file with the */; /* variable MY_OUT_FILE and the name for the log file (only with */; /* stata, variable MY_LOG_FILE). */; /* ---------------------------------------------------------------- */; /* Not processed Data */; /* ================== */; /* */; /* stillfj biojob */; /* reqeduc biojob */; /* nacefj biojob */; /* bsgebjah biosoc */; /* f0101 abroad */; /* f0401 abroad */; /* f0402 abroad */; /* ----- Here you can customize the paths and options: ----- */; global MY_IN_PATH "Your_in_path"; global MY_OUT_PATH "Your_out_path"; global MY_TEMP_PATH "Your_out_path"; global MY_OUT_FILE ${MY_OUT_PATH}name_of_the_file.dta; global MY_LOG_FILE ${MY_OUT_PATH}name_of_the_logfile.log; log using "${MY_LOG_FILE}", text replace; set more off; /* ----------------[ automatically pull PPFAD ]----------------- */; use hhnr persnr sex gebjahr psample gsampreg hsampreg isampreg jsampreg ksampreg lsampreg msampreg nsampreg osampreg psampreg qsampreg ghhnr hhhnr ihhnr jhhnr khhnr lhhnr mhhnr nhhnr ohhnr phhnr qhhnr gnetto hnetto inetto jnetto knetto lnetto mnetto nnetto onetto pnetto qnetto gpop hpop ipop jpop kpop lpop mpop npop opop ppop qpop loc1989 austritt erstbefr eintritt using "${MY_IN_PATH}ppfad.dta"; /* --------------[ balanced / unbalanced design ]--------------- */; keep if ( ( gnetto > 0 & gnetto < 40 ) | ( hnetto > 0 & hnetto < 40 ) | ( inetto > 0 & inetto < 40 ) | ( jnetto > 0 & jnetto < 40 ) | ( knetto > 0 & knetto < 40 ) | ( lnetto > 0 & lnetto < 40 ) | ( mnetto > 0 & mnetto < 40 ) | ( nnetto > 0 & nnetto < 40 ) | ( onetto > 0 & onetto < 40 ) | ( pnetto > 0 & pnetto < 40 ) | ( qnetto > 0 & qnetto < 40 ) ); /* -----------------[ private housholds only.]------------------ */; keep if ( ( gpop == 1 | gpop == 2 ) | ( hpop == 1 | hpop == 2 ) | ( ipop == 1 | ipop == 2 ) | ( jpop == 1 | jpop == 2 ) | ( kpop == 1 | kpop == 2 ) | ( lpop == 1 | lpop == 2 ) | ( mpop == 1 | mpop == 2 ) | ( npop == 1 | npop == 2 ) | ( opop == 1 | opop == 2 ) | ( ppop == 1 | ppop == 2 ) | ( qpop == 1 | qpop == 2 ) ); /* ----------------------[ define sample ]---------------------- */; keep if (psample == 3); //Including only respondents from the Eastern German territory /* -----------------------[ sort ppfad ]------------------------ */; sort persnr; save "${MY_TEMP_PATH}ppfad.dta", replace; clear; /* -----------------[ automatically pull PHRF ]----------------- */; use hhnr persnr prgroup gphrf hphrf iphrf jphrf kphrf lphrf mphrf nphrf ophrf pphrf qphrf hpbleib ipbleib jpbleib kpbleib lpbleib mpbleib npbleib opbleib ppbleib qpbleib using "${MY_IN_PATH}phrf.dta"; sort persnr; save "${MY_TEMP_PATH}phrf.dta", replace; clear; /* --------------[ automatically create pmaster ]--------------- */; use "${MY_TEMP_PATH}ppfad.dta"; merge persnr using "${MY_TEMP_PATH}phrf.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}ppfad.dta"; erase "${MY_TEMP_PATH}phrf.dta"; sort persnr; save "${MY_TEMP_PATH}pmaster.dta", replace; /* -----------------------( pull lpkal )------------------------ */; use hhnr lhhnr persnr lp1a02 lp1d02 lp1e02 using "${MY_IN_PATH}lpkal.dta"; sort persnr; save "${MY_TEMP_PATH}lpkal.dta", replace; clear; /* -----------------------( pull mpkal )------------------------ */; use hhnr mhhnr persnr mp1a02 mp1d02 mp1e02 using "${MY_IN_PATH}mpkal.dta"; sort persnr; save "${MY_TEMP_PATH}mpkal.dta", replace; clear; /* -----------------------( pull npkal )------------------------ */; use hhnr nhhnr persnr np1a02 np1d02 np1e02 using "${MY_IN_PATH}npkal.dta"; sort persnr; save "${MY_TEMP_PATH}npkal.dta", replace; clear; /* -----------------------( pull opkal )------------------------ */; use hhnr ohhnr persnr op1a02 op1d02 op1e02 using "${MY_IN_PATH}opkal.dta"; sort persnr; save "${MY_TEMP_PATH}opkal.dta", replace; clear; /* -----------------------( pull ppkal )------------------------ */; use hhnr phhnr persnr pp1a02 pp1d02 pp1e02 using "${MY_IN_PATH}ppkal.dta"; sort persnr; save "${MY_TEMP_PATH}ppkal.dta", replace; clear; /* -----------------------( pull qpkal )------------------------ */; use hhnr qhhnr persnr qp1a02 qp1d02 qp1e02 using "${MY_IN_PATH}qpkal.dta"; sort persnr; save "${MY_TEMP_PATH}qpkal.dta", replace; clear; /* ----------------------( pull bioparen )---------------------- */; use hhnr persnr vbbil mbbil using "${MY_IN_PATH}bioparen.dta"; sort persnr; save "${MY_TEMP_PATH}bioparen.dta", replace; clear; /* -----------------------( pull gpgen )------------------------ */; use hhnr ghhnr persnr erwtyp90 erljob90 betr90 oeffd90 partz90 partnr90 gpsbil gerwzeit gtatzeit guebstd nace90 egp90 isced90 stib90 month90 emplst90 expft90 exppt90 expue90 jobch90 degree90 labgro90 allbet90 ausb90 gvebzeit gpsbilo gfamstd impgro90 lfs90 using "${MY_IN_PATH}gpgen.dta"; sort persnr; save "${MY_TEMP_PATH}gpgen.dta", replace; clear; /* -----------------------( pull gpost )------------------------ */; use hhnr ghhnr persnr gp0301e gp0302e gp1401e gp1402e gp1403e gp1404e gp1405e gp1406e gp1407e gp16e gp1701e gp1702e gp1703e gp18e gp20e gp22e gp2301e gp2302e gp25e gp2601e gp27e gp28e gp2901e gp2902e gp2903e gp2904e gp2905e gp3001e gp3002e gp3003e gp3004e gp3005e gp3006e gp3007e gp31e gp32e gp3301e gp3302e gp3401e gp3402e gp3403e gp3404e gp3405e gp3406e gp3407e gp3408e gp3501 gp3502e gp3503e gp4101e gp4102e gp45a01e gp45a02e gp45a03e gp45a04e gp45b01e gp45b02e gp45b03e gp45b04e gp45c01e gp45c02e gp45c03e gp45c04e gp45d01e gp45d02e gp45d03e gp45d04e gp45e01e gp45e02e gp45e03e gp45e04e gp45f01e gp45f02e gp45f03e gp45f04e gp45g01e gp45g02e gp45g03e gp45g04e gp45h01e gp45h02e gp45h03e gp45h04e gp45i01e gp45i02e gp45i03e gp45i04e gp45k01e gp45k02e gp45k03e gp45k04e gp45l01e gp45l02e gp45l03e gp45l04e gp45m01e gp45m02e gp45m03e gp45m04e gp45n01e gp45n02e gp5601e gp5602e gp5603e gp60e gp5604e gp24_is88 gp24_klas gp26_nace gp6401e gp5501e gp5502e gp5504e using "${MY_IN_PATH}gpost.dta"; sort persnr; save "${MY_TEMP_PATH}gpost.dta", replace; clear; /* ----------------------( pull gpkalost )---------------------- */; use hhnr ghhnr persnr gp1a01o gp1d01o gp1d02o using "${MY_IN_PATH}gpkalost.dta"; sort persnr; save "${MY_TEMP_PATH}gpkalost.dta", replace; clear; /* -------------------------( pull hp )------------------------- */; use hhnr hhhnr persnr hp07 hp15 hp16 hp18 hp21 hp23g01 hp23g02 hp23g03 hp23g04 hp23g05 hp23g06 hp23g07 hp23g08 hp23g09o hp23g10o hp23g11 hp23g12 hp23g13 hp24g01 hp24g02 hp26g01 hp26g02 hp26g03 hp26g04 hp26g05 hp26g06 hp26g07 hp26g08 hp26g09 hp29g hp32g hp34 hp3501 hp4701 hp4702 hp4801 hp4802 hp4803 hp4804 hp57 hp33_is88 hp36_nace hp5801 hp5802 hp5803 hp5804 hp5805 hp5806 hp5807 hp5401 hp5402 hp101 hp1001 hp1002 hp1004 hp10901 using "${MY_IN_PATH}hp.dta"; sort persnr; save "${MY_TEMP_PATH}hp.dta", replace; clear; /* -----------------------( pull hpgen )------------------------ */; use hhnr hhhnr persnr erwtyp91 erljob91 betr91 oeffd91 partz91 partnr91 hpsbil herwzeit htatzeit huebstd nace91 egp91 isced91 stib91 month91 emplst91 expft91 exppt91 expue91 jobch91 degree91 labgro91 allbet91 ausb91 hvebzeit hpsbilo hfamstd impgro91 lfs91 using "${MY_IN_PATH}hpgen.dta"; sort persnr; save "${MY_TEMP_PATH}hpgen.dta", replace; clear; /* -----------------------( pull hpost )------------------------ */; use hhnr hhhnr persnr hp44o hp46o hp66oa hp105o05 using "${MY_IN_PATH}hpost.dta"; sort persnr; save "${MY_TEMP_PATH}hpost.dta", replace; clear; /* ----------------------( pull hpkalost )---------------------- */; use hhnr hhhnr persnr hp1a01o using "${MY_IN_PATH}hpkalost.dta"; sort persnr; save "${MY_TEMP_PATH}hpkalost.dta", replace; clear; /* -------------------------( pull ip )------------------------- */; use hhnr ihhnr persnr ip09 ip15 ip16 ip18 ip21 ip23g01 ip23g02 ip23g03 ip23g04 ip23g05 ip23g06 ip23g07 ip23g08 ip23g09o ip23g10o ip23g11 ip23g12 ip23g13 ip24g01 ip24g02 ip26g01 ip26g02 ip26g03 ip26g04 ip26g05 ip26g06 ip26g07 ip26g08 ip26g09 ip29g ip32g ip34 ip3501 ip4701 ip4702 ip4801 ip4802 ip4803 ip4804 ip58 ip105o05 ip33_is88 ip36_nace ip59o01 ip59o02 ip59o03 ip59o04 ip59o05 ip59o06 ip59o07 ip66a ip5401 ip5402 ip101 ip9002 ip9801 ip9802 ip9804 ip10901 using "${MY_IN_PATH}ip.dta"; sort persnr; save "${MY_TEMP_PATH}ip.dta", replace; clear; /* -----------------------( pull ipgen )------------------------ */; use hhnr ihhnr persnr erwtyp92 erljob92 betr92 oeffd92 partz92 partnr92 ipsbil ierwzeit itatzeit iuebstd nace92 egp92 isced92 stib92 month92 emplst92 expft92 exppt92 expue92 jobch92 degree92 labgro92 allbet92 ausb92 ipsbilo ifamstd impgro92 lfs92 ivebzeit using "${MY_IN_PATH}ipgen.dta"; sort persnr; save "${MY_TEMP_PATH}ipgen.dta", replace; clear; /* -------------------------( pull jp )------------------------- */; use hhnr jhhnr persnr jp09 jp15 jp16 jp18 jp21 jp23g01 jp23g02 jp23g03 jp23g04 jp23g05 jp23g06 jp23g07 jp23g08 jp23g09o jp23g10o jp23g11 jp23g12 jp23g13 jp24g01 jp24g02 jp26g01 jp26g02 jp26g03 jp26g04 jp26g05 jp26g06 jp26g07 jp26g08 jp26g09 jp29g jp32g jp34 jp3501 jp4601 jp4602 jp4801 jp4802 jp4803 jp4804 jp33_is88 jp36_nace jp5601 jp5602 jp5603 jp5604 jp5605 jp10901 jp5606 jp5607 jp76a jp5401 jp5402 jp101 jp4802 jp9002 jp0101 jp0102 jp0104 using "${MY_IN_PATH}jp.dta"; sort persnr; save "${MY_TEMP_PATH}jp.dta", replace; clear; /* -----------------------( pull jpgen )------------------------ */; use hhnr jhhnr persnr erwtyp93 erljob93 betr93 oeffd93 partz93 partnr93 jpsbil jerwzeit jtatzeit juebstd nace93 egp93 isced93 stib93 month93 emplst93 expft93 exppt93 expue93 jobch93 degree93 labgro93 allbet93 ausb93 jpsbilo jfamstd impgro93 lfs93 jvebzeit using "${MY_IN_PATH}jpgen.dta"; sort persnr; save "${MY_TEMP_PATH}jpgen.dta", replace; clear; /* -------------------------( pull kp )------------------------- */; use hhnr khhnr persnr kp16 kp2101 kp2102 kp2301 kp2302 kp2303 kp2304 kp2305 kp2306 kp2307 kp2308 kp2309 kp25 kp26 kp28 kp35 kp3801 kp3802 kp39 kp41 kp44 kp46 kp4701 kp50 kp5101 kp5102 kp5103 kp5104 kp45_is88 kp48_nace kp6701 kp6702 kp6703 kp6704 kp6705 kp6706 kp6707 kp65 kp76a kp6401 kp6402 kp101 kp10401 kp9202 kp0101 kp0102 kp0104 using "${MY_IN_PATH}kp.dta"; sort persnr; save "${MY_TEMP_PATH}kp.dta", replace; clear; * -----------------------( pull kpgen )------------------------ */; use hhnr khhnr persnr erwtyp94 erljob94 betr94 oeffd94 partz94 partnr94 kpsbil kerwzeit ktatzeit kuebstd nace94 egp94 isced94 stib94 month94 emplst94 expft94 exppt94 expue94 jobch94 degree94 labgro94 allbet94 ausb94 kpsbilo kfamstd impgro94 lfs94 kvebzeit using "${MY_IN_PATH}kpgen.dta"; sort persnr; save "${MY_TEMP_PATH}kpgen.dta", replace; clear; /* -------------------------( pull lp )------------------------- */; use hhnr lhhnr persnr lp13 lp1701 lp1702 lp1901 lp1902 lp1903 lp1904 lp1905 lp1906 lp1907 lp1908 lp1909 lp21 lp22 lp24 lp27 lp3001 lp3002 lp31 lp33 lp37 lp3801 lp42 lp4301 lp4302 lp4303 lp4304 lp44 lp5301 lp5302 lp36_is88 lp39_nace lp66 lp81a03 lp101 lp10401 lp9802 lp0101 lp0102 lp0104 using "${MY_IN_PATH}lp.dta"; sort persnr; save "${MY_TEMP_PATH}lp.dta", replace; clear; /* -----------------------( pull lpgen )------------------------ */; use hhnr lhhnr persnr erwtyp95 erljob95 betr95 oeffd95 partz95 partnr95 lpsbil lerwzeit ltatzeit luebstd nace95 egp95 isced95 stib95 month95 emplst95 expft95 exppt95 expue95 jobch95 degree95 labgro95 allbet95 ausb95 lpsbilo lfamstd impgro95 lfs95 lvebzeit using "${MY_IN_PATH}lpgen.dta"; sort persnr; save "${MY_TEMP_PATH}lpgen.dta", replace; clear; /* -------------------------( pull mp )------------------------- */; use hhnr mhhnr persnr mp12 mp15 mp16 mp18 mp25 mp2801 mp2802 mp29 mp31 mp35 mp3601 mp40 mp4101 mp4102 mp4103 mp4104 mp34_is88 mp37_nace mp48 mp5401 mp5402 mp5403 mp5404 mp5405 mp5406 mp5407 mp6201 mp6202 mp6401 mp6402 mp6403 mp6404 mp6405 mp6406 mp6407 mp6408 mp6409 mp67a03 mp4701 mp4702 mp106 mp11001 mp8402 mp0101 mp0102 mp0104 using "${MY_IN_PATH}mp.dta"; sort persnr; save "${MY_TEMP_PATH}mp.dta", replace; clear; /* -----------------------( pull mpgen )------------------------ */; use hhnr mhhnr persnr erwtyp96 erljob96 betr96 oeffd96 partz96 partnr96 mpsbil merwzeit mtatzeit muebstd nace96 egp96 isced96 stib96 month96 emplst96 expft96 exppt96 expue96 jobch96 degree96 labgro96 allbet96 ausb96 mpsbilo mfamstd impgro96 lfs96 mvebzeit using "${MY_IN_PATH}mpgen.dta"; sort persnr; save "${MY_TEMP_PATH}mpgen.dta", replace; clear; /* -------------------------( pull np )------------------------- */; use hhnr nhhnr persnr np08 np11 np12 np14 np18 np2201 np2202 np23 np25 np29 np3001 np3401 np3501 np3502 np3503 np3504 np36 np28_is88 np31_nace np41 np6201 np6202 np6401 np6402 np6403 np6404 np6405 np6406 np6407 np6408 np6409 np67a03 np5401 np5402 np113 np11701 np9402 np0101 np0102 np0104 using "${MY_IN_PATH}np.dta"; sort persnr; save "${MY_TEMP_PATH}np.dta", replace; clear; /* -----------------------( pull npgen )------------------------ */; use hhnr nhhnr persnr erwtyp97 erljob97 betr97 oeffd97 partz97 partnr97 npsbil nerwzeit ntatzeit nuebstd nace97 egp97 isced97 stib97 month97 emplst97 expft97 exppt97 expue97 jobch97 degree97 labgro97 allbet97 ausb97 npsbilo nfamstd impgro97 lfs97 nvebzeit using "${MY_IN_PATH}npgen.dta"; sort persnr; save "${MY_TEMP_PATH}npgen.dta", replace; clear; /* -------------------------( pull op )------------------------- */; use hhnr ohhnr persnr op04 op09 op10 op12 op19 op2201 op2202 op23 op25 op29 op3001 op3401 op3501 op3502 op3503 op3504 op28_is88 op31_nace op3701 op3702 op3703 op3704 op3705 op3706 op3707 op5301 op5302 op5501 op5502 op5503 op5504 op5505 op5506 op5507 op5508 op5509 op58a03 op89 op4501 op4502 op119 op12301 op9702 op0101 op0102 op0104 using "${MY_IN_PATH}op.dta"; sort persnr; save "${MY_TEMP_PATH}op.dta", replace; clear; /* -----------------------( pull opgen )------------------------ */; use hhnr ohhnr persnr erwtyp98 erljob98 betr98 oeffd98 partz98 partnr98 opsbil oerwzeit otatzeit ouebstd nace98 egp98 isced98 stib98 month98 emplst98 expft98 exppt98 expue98 jobch98 degree98 labgro98 allbet98 ausb98 opsbilo ofamstd impgro98 lfs98 ovebzeit using "${MY_IN_PATH}opgen.dta"; sort persnr; save "${MY_TEMP_PATH}opgen.dta", replace; clear; /* -------------------------( pull pp )------------------------- */; use hhnr phhnr persnr pp05 pp10 pp11 pp12 pp13 pp19 pp2201 pp2202 pp23 pp26 pp30 pp31 pp3701 pp3801 pp3802 pp3803 pp3804 pp29_is88 pp34_nace pp3901 pp3902 pp3903 pp3904 pp3905 pp3906 pp3907 pp42 pp47 pp7001 pp7002 pp72 pp76a03 pp6001 pp6002 pp131 pp05 pp13501 pp11201 pp0101 pp0102 pp0104 using "${MY_IN_PATH}pp.dta"; sort persnr; save "${MY_TEMP_PATH}pp.dta", replace; clear; /* -----------------------( pull ppgen )------------------------ */; use hhnr phhnr persnr erwtyp99 erljob99 betr99 oeffd99 partz99 partnr99 ppsbil perwzeit ptatzeit puebstd nace99 egp99 isced99 stib99 month99 emplst99 expft99 exppt99 expue99 jobch99 degree99 labgro99 allbet99 ausb99 ppsbilo pfamstd impgro99 lfs99 pvebzeit using "${MY_IN_PATH}ppgen.dta"; sort persnr; save "${MY_TEMP_PATH}ppgen.dta", replace; clear; /* -------------------------( pull qp )------------------------- */; use hhnr qhhnr persnr qp04 qp10 qp11 qp12 qp13 qp18 qp2101 qp2102 qp22 qp24 qp28 qp29 qp3501 qp3601 qp3603 qp3604 qp27_is88 qp32_nace qp3602 qp41 qp42 qp7001 qp7002 qp72 qp76a03 qp5601 qp5602 using "${MY_IN_PATH}qp.dta"; sort persnr; save "${MY_TEMP_PATH}qp.dta", replace; clear; /* -----------------------( pull qpgen )------------------------ */; use hhnr qhhnr persnr erwtyp00 erljob00 betr00 oeffd00 partz00 partnr00 qpsbil qerwzeit qtatzeit quebstd nace00 egp00 isced00 stib00 month00 emplst00 expft00 exppt00 expue00 jobch00 degree00 labgro00 allbet00 ausb00 qpsbilo qfamstd impgro00 lfs00 using "${MY_IN_PATH}qpgen.dta"; sort persnr; save "${MY_TEMP_PATH}qpgen.dta", replace; clear; /* -----------------------( pull ghost )------------------------ */; use hhnr ghhnr gh04e gh34e using "${MY_IN_PATH}ghost.dta"; sort ghhnr; save "${MY_TEMP_PATH}ghost.dta", replace; clear; /* ----------------------( pull gpbrutto )---------------------- */; use hhnr ghhnr persnr ggeburt using "${MY_IN_PATH}gpbrutto.dta"; sort persnr; save "${MY_TEMP_PATH}gpbrutto.dta", replace; clear; /* ----------------------( pull hpbrutto )---------------------- */; use hhnr hhhnr persnr hgeburt using "${MY_IN_PATH}hpbrutto.dta"; sort persnr; save "${MY_TEMP_PATH}hpbrutto.dta", replace; clear; /* ----------------------( pull ipbrutto )---------------------- */; use hhnr ihhnr persnr igeburt using "${MY_IN_PATH}ipbrutto.dta"; sort persnr; save "${MY_TEMP_PATH}ipbrutto.dta", replace; clear; /* ----------------------( pull jpbrutto )---------------------- */; use hhnr jhhnr persnr jgeburt using "${MY_IN_PATH}jpbrutto.dta"; sort persnr; save "${MY_TEMP_PATH}jpbrutto.dta", replace; clear; /* ----------------------( pull kpbrutto )---------------------- */; use hhnr khhnr persnr kgeburt using "${MY_IN_PATH}kpbrutto.dta"; sort persnr; save "${MY_TEMP_PATH}kpbrutto.dta", replace; clear; /* ----------------------( pull lpbrutto )---------------------- */; use hhnr lhhnr persnr lgeburt using "${MY_IN_PATH}lpbrutto.dta"; sort persnr; save "${MY_TEMP_PATH}lpbrutto.dta", replace; clear; /* ----------------------( pull mpbrutto )---------------------- */; use hhnr mhhnr persnr mgeburt using "${MY_IN_PATH}mpbrutto.dta"; sort persnr; save "${MY_TEMP_PATH}mpbrutto.dta", replace; clear; /* ----------------------( pull npbrutto )---------------------- */; use hhnr nhhnr persnr ngeburt using "${MY_IN_PATH}npbrutto.dta"; sort persnr; save "${MY_TEMP_PATH}npbrutto.dta", replace; clear; /* ----------------------( pull opbrutto )---------------------- */; use hhnr ohhnr persnr ogeburt using "${MY_IN_PATH}opbrutto.dta"; sort persnr; save "${MY_TEMP_PATH}opbrutto.dta", replace; clear; /* ----------------------( pull ppbrutto )---------------------- */; use hhnr phhnr persnr pgeburt using "${MY_IN_PATH}ppbrutto.dta"; sort persnr; save "${MY_TEMP_PATH}ppbrutto.dta", replace; clear; /* ----------------------( pull qpbrutto )---------------------- */; use hhnr qhhnr persnr qgeburt using "${MY_IN_PATH}qpbrutto.dta"; sort persnr; save "${MY_TEMP_PATH}qpbrutto.dta", replace; clear; /* ----------------------( pull gpequiv )----------------------- */; use hhnr ghhnr persnr d1110690 d1110790 i1110290 i1111090 h1110190 ijob190 using "${MY_IN_PATH}gpequiv.dta"; sort persnr; save "${MY_TEMP_PATH}gpequiv.dta", replace; clear; /* ----------------------( pull hpequiv )----------------------- */; use hhnr hhhnr persnr d1110691 d1110791 i1110291 i1111091 h1110191 ijob191 using "${MY_IN_PATH}hpequiv.dta"; sort persnr; save "${MY_TEMP_PATH}hpequiv.dta", replace; clear; /* ----------------------( pull ipequiv )----------------------- */; use hhnr ihhnr persnr d1110692 d1110792 i1110292 i1111092 h1110192 y1110192 ijob192 e1110192 using "${MY_IN_PATH}ipequiv.dta"; sort persnr; save "${MY_TEMP_PATH}ipequiv.dta", replace; clear; /* ----------------------( pull jpequiv )----------------------- */; use hhnr jhhnr persnr d1110693 d1110793 i1110293 i1111093 h1110193 y1110193 ijob193 e1110193 using "${MY_IN_PATH}jpequiv.dta"; sort persnr; save "${MY_TEMP_PATH}jpequiv.dta", replace; clear; /* ----------------------( pull kpequiv )----------------------- */; use hhnr khhnr persnr d1110694 d1110794 i1110294 i1111094 h1110194 y1110194 ijob194 e1110194 using "${MY_IN_PATH}kpequiv.dta"; sort persnr; save "${MY_TEMP_PATH}kpequiv.dta", replace; clear; /* ----------------------( pull lpequiv )----------------------- */; use hhnr lhhnr persnr d1110695 d1110795 i1110295 i1111095 h1110195 y1110195 ijob195 e1110195 using "${MY_IN_PATH}lpequiv.dta"; sort persnr; save "${MY_TEMP_PATH}lpequiv.dta", replace; clear; /* ----------------------( pull mpequiv )----------------------- */; use hhnr mhhnr persnr d1110696 d1110796 i1110296 i1111096 h1110196 y1110196 ijob196 e1110196 using "${MY_IN_PATH}mpequiv.dta"; sort persnr; save "${MY_TEMP_PATH}mpequiv.dta", replace; clear; /* ----------------------( pull npequiv )----------------------- */; use hhnr nhhnr persnr d1110697 d1110797 i1110297 i1111097 h1110197 y1110197 ijob197 e1110197 using "${MY_IN_PATH}npequiv.dta"; sort persnr; save "${MY_TEMP_PATH}npequiv.dta", replace; clear; /* ----------------------( pull opequiv )----------------------- */; use hhnr ohhnr persnr d1110698 d1110798 i1110298 i1111098 h1110198 y1110198 ijob198 e1110198 using "${MY_IN_PATH}opequiv.dta"; sort persnr; save "${MY_TEMP_PATH}opequiv.dta", replace; clear; /* ----------------------( pull ppequiv )----------------------- */; use hhnr phhnr persnr d1110699 d1110799 i1110299 i1111099 h1110199 y1110199 ijob199 e1110199 using "${MY_IN_PATH}ppequiv.dta"; sort persnr; save "${MY_TEMP_PATH}ppequiv.dta", replace; clear; /* ----------------------( pull qpequiv )----------------------- */; use hhnr qhhnr persnr d1110600 d1110700 i1110200 i1111000 h1110100 using "${MY_IN_PATH}qpequiv.dta"; sort persnr; save "${MY_TEMP_PATH}qpequiv.dta", replace; clear; /* -----------------------( pull ghgen )------------------------ */; use hhnr ghhnr hinc90 nuts190 using "${MY_IN_PATH}ghgen.dta"; sort ghhnr; save "${MY_TEMP_PATH}ghgen.dta", replace; clear; /* -----------------------( pull hhgen )------------------------ */; use hhnr hhhnr hinc91 nuts191 using "${MY_IN_PATH}hhgen.dta"; sort hhhnr; save "${MY_TEMP_PATH}hhgen.dta", replace; clear; /* -----------------------( pull ihgen )------------------------ */; use hhnr ihhnr hinc92 nuts192 using "${MY_IN_PATH}ihgen.dta"; sort ihhnr; save "${MY_TEMP_PATH}ihgen.dta", replace; clear; /* -----------------------( pull jhgen )------------------------ */; use hhnr jhhnr hinc93 nuts193 using "${MY_IN_PATH}jhgen.dta"; sort jhhnr; save "${MY_TEMP_PATH}jhgen.dta", replace; clear; /* -----------------------( pull khgen )------------------------ */; use hhnr khhnr hinc94 nuts194 using "${MY_IN_PATH}khgen.dta"; sort khhnr; save "${MY_TEMP_PATH}khgen.dta", replace; clear; /* -----------------------( pull lhgen )------------------------ */; use hhnr lhhnr hinc95 nuts195 using "${MY_IN_PATH}lhgen.dta"; sort lhhnr; save "${MY_TEMP_PATH}lhgen.dta", replace; clear; /* -----------------------( pull mhgen )------------------------ */; use hhnr mhhnr hinc96 nuts196 using "${MY_IN_PATH}mhgen.dta"; sort mhhnr; save "${MY_TEMP_PATH}mhgen.dta", replace; clear; /* -----------------------( pull nhgen )------------------------ */; use hhnr nhhnr hinc97 nuts197 using "${MY_IN_PATH}nhgen.dta"; sort nhhnr; save "${MY_TEMP_PATH}nhgen.dta", replace; clear; /* -----------------------( pull ohgen )------------------------ */; use hhnr ohhnr hinc98 nuts198 using "${MY_IN_PATH}ohgen.dta"; sort ohhnr; save "${MY_TEMP_PATH}ohgen.dta", replace; clear; /* -----------------------( pull phgen )------------------------ */; use hhnr phhnr hinc99 nuts199 using "${MY_IN_PATH}phgen.dta"; sort phhnr; save "${MY_TEMP_PATH}phgen.dta", replace; clear; /* -----------------------( pull qhgen )------------------------ */; use hhnr qhhnr hinc00 using "${MY_IN_PATH}qhgen.dta"; sort qhhnr; save "${MY_TEMP_PATH}qhgen.dta", replace; clear; /* -----------------( Now merge all together )------------------ */; use "${MY_TEMP_PATH}pmaster.dta"; erase "${MY_TEMP_PATH}pmaster.dta"; /* -----------( merge together by person: ALL Waves )----------- */; /* -----------------------( merge LPKAL )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}lpkal.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}lpkal.dta"; /* -----------------------( merge MPKAL )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}mpkal.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}mpkal.dta"; /* -----------------------( merge NPKAL )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}npkal.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}npkal.dta"; /* -----------------------( merge OPKAL )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}opkal.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}opkal.dta"; /* -----------------------( merge PPKAL )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}ppkal.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}ppkal.dta"; /* ---------------------( merge BIOPAREN )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}bioparen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}bioparen.dta"; /* -----------------------( merge GPGEN )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}gpgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}gpgen.dta"; /* -----------------------( merge GPOST )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}gpost.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}gpost.dta"; /* ---------------------( merge GPKALOST )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}gpkalost.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}gpkalost.dta"; /* ------------------------( merge HP )------------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}hp.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}hp.dta"; /* -----------------------( merge HPOST )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}hpost.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}hpost.dta"; /* -----------------------( merge HPGEN )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}hpgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}hpgen.dta"; /* ------------------------( merge IP )------------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}ip.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}ip.dta"; /* -----------------------( merge IPGEN )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}ipgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}ipgen.dta"; /* ------------------------( merge JP )------------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}jp.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}jp.dta"; /* -----------------------( merge JPGEN )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}jpgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}jpgen.dta"; /* ------------------------( merge KP )------------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}kp.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}kp.dta"; /* -----------------------( merge KPGEN )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}kpgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}kpgen.dta"; /* ------------------------( merge LP )------------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}lp.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}lp.dta"; /* -----------------------( merge LPGEN )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}lpgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}lpgen.dta"; /* ------------------------( merge MP )------------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}mp.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}mp.dta"; /* -----------------------( merge MPGEN )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}mpgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}mpgen.dta"; /* ------------------------( merge NP )------------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}np.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}np.dta"; /* -----------------------( merge NPGEN )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}npgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}npgen.dta"; /* ------------------------( merge OP )------------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}op.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}op.dta"; /* -----------------------( merge OPGEN )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}opgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}opgen.dta"; /* ------------------------( merge PP )------------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}pp.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}pp.dta"; /* -----------------------( merge PPGEN )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}ppgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}ppgen.dta"; /* ------------------------( merge QP )------------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}qp.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}qp.dta"; /* -----------------------( merge QPGEN )----------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}qpgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}qpgen.dta"; /* ---------------------( merge GPBRUTTO )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}gpbrutto.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}gpbrutto.dta"; /* ---------------------( merge HPBRUTTO )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}hpbrutto.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}hpbrutto.dta"; /* ---------------------( merge IPBRUTTO )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}ipbrutto.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}ipbrutto.dta"; /* ---------------------( merge JPBRUTTO )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}jpbrutto.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}jpbrutto.dta"; /* ---------------------( merge KPBRUTTO )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}kpbrutto.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}kpbrutto.dta"; /* ---------------------( merge LPBRUTTO )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}lpbrutto.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}lpbrutto.dta"; /* ---------------------( merge MPBRUTTO )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}mpbrutto.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}mpbrutto.dta"; /* ---------------------( merge NPBRUTTO )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}npbrutto.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}npbrutto.dta"; /* ---------------------( merge OPBRUTTO )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}opbrutto.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}opbrutto.dta"; /* ---------------------( merge PPBRUTTO )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}ppbrutto.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}ppbrutto.dta"; /* ---------------------( merge QPBRUTTO )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}qpbrutto.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}qpbrutto.dta"; /* ----------------------( merge GPEQUIV )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}gpequiv.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}gpequiv.dta"; /* ----------------------( merge HPEQUIV )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}hpequiv.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}hpequiv.dta"; /* ----------------------( merge IPEQUIV )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}ipequiv.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}ipequiv.dta"; /* ----------------------( merge JPEQUIV )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}jpequiv.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}jpequiv.dta"; /* ----------------------( merge KPEQUIV )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}kpequiv.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}kpequiv.dta"; /* ----------------------( merge LPEQUIV )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}lpequiv.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}lpequiv.dta"; /* ----------------------( merge MPEQUIV )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}mpequiv.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}mpequiv.dta"; /* ----------------------( merge NPEQUIV )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}npequiv.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}npequiv.dta"; /* ----------------------( merge OPEQUIV )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}opequiv.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}opequiv.dta"; /* ----------------------( merge PPEQUIV )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}ppequiv.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}ppequiv.dta"; /* ----------------------( merge QPEQUIV )---------------------- */; sort persnr; merge persnr using "${MY_TEMP_PATH}qpequiv.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}qpequiv.dta"; /* -----------( merge together by household: Wave G)------------ */; /* -----------------------( merge GHOST )----------------------- */; sort ghhnr; merge ghhnr using "${MY_TEMP_PATH}ghost.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}ghost.dta"; /* -----------------------( merge GHGEN )----------------------- */; sort ghhnr; merge ghhnr using "${MY_TEMP_PATH}ghgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}ghgen.dta"; /* -----------( merge together by household: Wave H)------------ */; /* -----------------------( merge HHGEN )----------------------- */; sort hhhnr; merge hhhnr using "${MY_TEMP_PATH}hhgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}hhgen.dta"; /* -----------( merge together by household: Wave I)------------ */; /* -----------------------( merge IHGEN )----------------------- */; sort ihhnr; merge ihhnr using "${MY_TEMP_PATH}ihgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}ihgen.dta"; /* -----------( merge together by household: Wave J)------------ */; /* -----------------------( merge JHGEN )----------------------- */; sort jhhnr; merge jhhnr using "${MY_TEMP_PATH}jhgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}jhgen.dta"; /* -----------( merge together by household: Wave K)------------ */; /* -----------------------( merge KHGEN )----------------------- */; sort khhnr; merge khhnr using "${MY_TEMP_PATH}khgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}khgen.dta"; /* -----------( merge together by household: Wave L)------------ */; /* -----------------------( merge LHGEN )----------------------- */; sort lhhnr; merge lhhnr using "${MY_TEMP_PATH}lhgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}lhgen.dta"; /* -----------( merge together by household: Wave M)------------ */; /* -----------------------( merge MHGEN )----------------------- */; sort mhhnr; merge mhhnr using "${MY_TEMP_PATH}mhgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}mhgen.dta"; /* -----------( merge together by household: Wave N)------------ */; /* -----------------------( merge NHGEN )----------------------- */; sort nhhnr; merge nhhnr using "${MY_TEMP_PATH}nhgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}nhgen.dta"; /* -----------( merge together by household: Wave O)------------ */; /* -----------------------( merge OHGEN )----------------------- */; sort ohhnr; merge ohhnr using "${MY_TEMP_PATH}ohgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}ohgen.dta"; /* -----------( merge together by household: Wave P)------------ */; /* -----------------------( merge PHGEN )----------------------- */; sort phhnr; merge phhnr using "${MY_TEMP_PATH}phgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}phgen.dta"; /* -----------( merge together by household: Wave Q)------------ */; /* -----------------------( merge QHGEN )----------------------- */; sort qhhnr; merge qhhnr using "${MY_TEMP_PATH}qhgen.dta"; drop if _merge == 2; drop _merge; erase "${MY_TEMP_PATH}qhgen.dta"; /* --------------------------( done! )-------------------------- */; label data "SOEPINFO: Magic at Work! http://panel.gsoep.de/soepinfo/"; keep if erstbefr==1990; save "${MY_OUT_FILE}", replace; desc;