---------------------------------------------------------------------------------------------------------------------------------- name: log: C:\Users\rwr\Dropbox\basu-house\build\code\../temp/nlsy_data.log log type: text opened on: 17 Jul 2016, 17:07:25 . /*****************************************************************************/ > > /*** Hourly Wage ***/ > use `tempdata'EMPLOYERS_ALL_HRLY_WAGE_data; . keep if !missing(hrly_wage_nom); (5,237,382 observations deleted) . /*** birth date ***/ > merge m:1 `merge3' using `tempdata'DATE_OF_BIRTH_data, keep(master match) nogen; (label vlR0214700 already defined) (label vlR0214800 already defined) Result # of obs. ----------------------------------------- not matched 0 matched 141,138 ----------------------------------------- . /*** cross-sectional sample weights ***/ > merge m:1 `merge3' year using `tempdata'C_SAMPWEIGHT_data, keep(master match) nogen; (label vlR0214800 already defined) (label vlR0214700 already defined) Result # of obs. ----------------------------------------- not matched 0 matched 141,138 ----------------------------------------- . /*** highest grade completed ***/ > merge m:1 `merge3' year using `tempdata'HGCREV_data, keep(master match) nogen; (label vlR0214800 already defined) (label vlR0214700 already defined) Result # of obs. ----------------------------------------- not matched 0 matched 141,138 ----------------------------------------- . /* /\*** previous wage with same employer (if available) ***\/ */ > /* merge 1:1 `merge3' year job using `tempdata'Dhrly_wage_data, keep(master match) nogen; */ > /*** union status ***/ > merge 1:1 `merge3' year job using `tempdata'EMPLOYERS_ALL_UNION_data, keep(master match) nogen; (label vlR0214800 already defined) (label vlR0214700 already defined) Result # of obs. ----------------------------------------- not matched 9 from master 9 from using 0 matched 141,129 ----------------------------------------- . /*** marital status ***/ > merge m:1 `merge3' year using `tempdata'MARSTAT-KEY_data, keep(master match) nogen; (label vlR0214800 already defined) (label vlR0214700 already defined) Result # of obs. ----------------------------------------- not matched 0 matched 141,138 ----------------------------------------- . /*** tenure ***/ > merge 1:1 `merge3' year job using `tempdata'EMPLOYERS_ALL_TENURE_data, keep(master match) nogen; (label vlR0214800 already defined) (label vlR0214700 already defined) Result # of obs. ----------------------------------------- not matched 2,230 from master 2,230 from using 0 matched 138,908 ----------------------------------------- . /*** industry ***/ > merge 1:1 `merge3' year job using `tempdata'EMPLOYERS_ALL_IND_data, keep(master match) nogen; (label vlR0214800 already defined) (label vlR0214700 already defined) Result # of obs. ----------------------------------------- not matched 8,722 from master 8,722 from using 0 matched 132,416 ----------------------------------------- . /*** start week ***/ > merge 1:1 `merge3' year job using `tempdata'EMPLOYERS_ALL_STADATE_data, keep(master match) nogen; (label vlR0214800 already defined) (label vlR0214700 already defined) Result # of obs. ----------------------------------------- not matched 0 matched 141,138 ----------------------------------------- . /*** stop week ***/ > merge 1:1 `merge3' year job using `tempdata'EMPLOYERS_ALL_STOPDATE_data, keep(master match) nogen; (label vlR0214800 already defined) (label vlR0214700 already defined) Result # of obs. ----------------------------------------- not matched 0 matched 141,138 ----------------------------------------- . /*** class of worker ***/ > merge 1:1 `merge3' year job using `tempdata'EMPLOYERS_ALL_COW_data, keep(master match) nogen; (label vlR0214800 already defined) (label vlR0214700 already defined) Result # of obs. ----------------------------------------- not matched 5 from master 5 from using 0 matched 141,133 ----------------------------------------- . /*** class of worker ***/ > merge 1:1 `merge3' year job using `tempdata'EMPLOYERS_ALL_TIMERATE_data, keep(master match) nogen; (label vlR0214800 already defined) (label vlR0214700 already defined) Result # of obs. ----------------------------------------- not matched 0 matched 141,138 ----------------------------------------- . /*** Reason non-interviewed; contains sample markers for the military and disadvantaged groups ***/ > merge m:1 `merge3' year using `tempdata'RNI_data, keep(master match) nogen; (label vlR0214800 already defined) (label vlR0214700 already defined) Result # of obs. ----------------------------------------- not matched 4,960 from master 4,960 from using 0 matched 136,178 ----------------------------------------- . /*** NUMBER ARRAY to merge with weekly status array ***/ > merge 1:1 `merge3' year job using `tempdata'EMPLOYERS_ALL_NUM_ARRAY_data, keep(master match) nogen; (label vlR0214800 already defined) (label vlR0214700 already defined) Result # of obs. ----------------------------------------- not matched 0 matched 141,138 ----------------------------------------- . /*** round number ***/ > merge m:1 year using `input'rounds, keep(master match) nogen; Result # of obs. ----------------------------------------- not matched 0 matched 141,138 ----------------------------------------- . /*** annual unemployment rates ***/ > gen datey = yofd(stopd); (213 missing values generated) . merge m:1 datey using `tempdata'fred2dta_yearly_data, keep(master match) nogen; Result # of obs. ----------------------------------------- not matched 213 from master 213 from using 0 matched 140,925 ----------------------------------------- . /*** generate variables of interest ***/ > gen tenurey = tenurew / 52; (2,230 missing values generated) . gen datem = mofd(stopd); (213 missing values generated) . format datem %tm; . gen datew = wofd(stopd); (213 missing values generated) . format datew %tw; . gen age = datem - dob; (213 missing values generated) . replace age = age / 12; (140,925 real changes made) . gen potexperience = age - hgc - 6; (2,106 missing values generated) . replace potexperience = 0 if potexperience < 0 & !missing(potexperience); (1,007 real changes made) . /* date the employer--job began */ > gen employer_startw = datew - tenurew; (2,289 missing values generated) . format employer_startw %tw; . gen employer_starty = yofd(dofw(employer_startw)); (2,289 missing values generated) . /*** generate non-NLSY year ***/ > gen non_nlsy = 0; . replace non_nlsy = 1 if > datey == 1995 | > datey == 1997 | > datey == 1999 | > datey == 2001 | > datey == 2003 | > datey == 2005 | > datey == 2007 | > datey == 2009 | > datey == 2011 | > datey == 2013; (7,786 real changes made) . /*** label variables ***/ > la var year "year of round"; . la var disadvantaged_samp "=1 if disadvantaged sample"; . la var startd "start date of interview"; . la var stopd "stop date of interview"; . la var tenurew "weeks of tenure"; . la var tenurey "years of tenure"; . la var dob "date of birth (monthly Stata format)"; . la var non_nlsy "non-NLSY years (based on datey)"; . /* date varibles corresponding to date job ended or the interview date */ > la var datey "Stata year of most current obs of wage (interview date or date job ended)"; . la var datem "Stata month of most current obs of the wage (interview date or date job ended)"; . la var datew "Stata week of most current obs of the wage (interview date or date job ended)"; . la var employer_startw "Stata week the employer--job relationship began"; . la var employer_starty "Stata year the employer--job relationship began"; . /*** merge in cumulative tightness ***/ > gen cum_tight_datew = employer_startw - 1; (2,289 missing values generated) . format cum_tight_datew %tw; . merge m:1 id race sex cum_tight_datew using `tempdata'cum_tight_data, keep(master match); (label vlR0214700 already defined) (label vlR0214800 already defined) Result # of obs. ----------------------------------------- not matched 6,454 from master 6,454 (_merge==1) from using 0 (_merge==2) matched 134,684 (_merge==3) ----------------------------------------- . /* the non-merges are those without tenure and very early dates */ > tab cum_tight_datew if _merge == 1; cum_tight_d | atew | Freq. Percent Cum. ------------+----------------------------------- 1969w51 | 2 0.05 0.05 1969w52 | 1 0.02 0.07 1970w1 | 2 0.05 0.12 1970w2 | 1 0.02 0.14 1970w27 | 1 0.02 0.17 1972w5 | 1 0.02 0.19 1972w6 | 2 0.05 0.24 1972w52 | 2 0.05 0.29 1973w1 | 2 0.05 0.34 1973w41 | 4 0.10 0.43 1973w42 | 4 0.10 0.53 1973w43 | 5 0.12 0.65 1973w45 | 2 0.05 0.70 1973w46 | 8 0.19 0.89 1973w47 | 5 0.12 1.01 1973w48 | 2 0.05 1.06 1974w1 | 2 0.05 1.10 1974w2 | 1 0.02 1.13 1974w3 | 1 0.02 1.15 1974w4 | 2 0.05 1.20 1974w10 | 3 0.07 1.27 1974w13 | 1 0.02 1.30 1974w18 | 3 0.07 1.37 1974w24 | 2 0.05 1.42 1974w25 | 2 0.05 1.46 1974w26 | 1 0.02 1.49 1974w27 | 2 0.05 1.54 1974w28 | 5 0.12 1.66 1974w29 | 7 0.17 1.82 1974w30 | 6 0.14 1.97 1974w31 | 1 0.02 1.99 1974w38 | 3 0.07 2.06 1974w39 | 1 0.02 2.09 1974w45 | 3 0.07 2.16 1974w46 | 6 0.14 2.30 1974w47 | 8 0.19 2.50 1974w48 | 5 0.12 2.62 1974w49 | 1 0.02 2.64 1974w50 | 2 0.05 2.69 1974w51 | 4 0.10 2.79 1974w52 | 4 0.10 2.88 1975w8 | 1 0.02 2.91 1975w9 | 1 0.02 2.93 1975w21 | 1 0.02 2.95 1975w25 | 4 0.10 3.05 1975w34 | 5 0.12 3.17 1975w35 | 5 0.12 3.29 1975w36 | 4 0.10 3.39 1975w37 | 8 0.19 3.58 1975w38 | 12 0.29 3.87 1975w39 | 7 0.17 4.03 1975w40 | 5 0.12 4.15 1975w41 | 6 0.14 4.30 1975w42 | 4 0.10 4.39 1975w43 | 3 0.07 4.47 1975w44 | 7 0.17 4.63 1975w45 | 2 0.05 4.68 1975w46 | 5 0.12 4.80 1975w47 | 7 0.17 4.97 1975w48 | 1 0.02 4.99 1975w51 | 1 0.02 5.02 1976w1 | 5 0.12 5.14 1976w2 | 2 0.05 5.19 1976w3 | 4 0.10 5.28 1976w4 | 2 0.05 5.33 1976w6 | 1 0.02 5.35 1976w7 | 2 0.05 5.40 1976w8 | 1 0.02 5.43 1976w12 | 6 0.14 5.57 1976w13 | 3 0.07 5.64 1976w14 | 1 0.02 5.67 1976w15 | 3 0.07 5.74 1976w16 | 5 0.12 5.86 1976w17 | 3 0.07 5.93 1976w18 | 5 0.12 6.05 1976w19 | 6 0.14 6.19 1976w20 | 7 0.17 6.36 1976w21 | 3 0.07 6.43 1976w23 | 1 0.02 6.46 1976w24 | 3 0.07 6.53 1976w25 | 17 0.41 6.94 1976w26 | 12 0.29 7.23 1976w27 | 4 0.10 7.32 1976w28 | 3 0.07 7.39 1976w29 | 6 0.14 7.54 1976w30 | 1 0.02 7.56 1976w31 | 1 0.02 7.59 1976w33 | 7 0.17 7.76 1976w34 | 2 0.05 7.80 1976w36 | 1 0.02 7.83 1976w38 | 2 0.05 7.88 1976w40 | 1 0.02 7.90 1976w41 | 2 0.05 7.95 1976w42 | 11 0.26 8.21 1976w43 | 8 0.19 8.40 1976w46 | 2 0.05 8.45 1976w49 | 3 0.07 8.52 1976w50 | 11 0.26 8.79 1976w51 | 10 0.24 9.03 1976w52 | 1 0.02 9.05 1977w1 | 3 0.07 9.12 1977w2 | 7 0.17 9.29 1977w3 | 13 0.31 9.60 1977w4 | 11 0.26 9.87 1977w5 | 4 0.10 9.96 1977w6 | 7 0.17 10.13 1977w7 | 13 0.31 10.44 1977w8 | 7 0.17 10.61 1977w9 | 5 0.12 10.73 1977w10 | 1 0.02 10.76 1977w11 | 17 0.41 11.16 1977w12 | 9 0.22 11.38 1977w13 | 7 0.17 11.55 1977w14 | 13 0.31 11.86 1977w15 | 10 0.24 12.10 1977w16 | 22 0.53 12.63 1977w17 | 11 0.26 12.89 1977w18 | 2 0.05 12.94 1977w19 | 4 0.10 13.04 1977w20 | 8 0.19 13.23 1977w21 | 7 0.17 13.40 1977w22 | 2 0.05 13.45 1977w23 | 4 0.10 13.54 1977w24 | 29 0.70 14.24 1977w25 | 15 0.36 14.60 1977w26 | 1 0.02 14.62 1977w28 | 1 0.02 14.65 1977w29 | 14 0.34 14.98 1977w30 | 8 0.19 15.17 1977w31 | 3 0.07 15.25 1977w32 | 5 0.12 15.37 1977w33 | 50 1.20 16.57 1977w34 | 18 0.43 17.00 1977w35 | 4 0.10 17.09 1977w36 | 11 0.26 17.36 1977w37 | 36 0.86 18.22 1977w38 | 16 0.38 18.61 1977w39 | 1 0.02 18.63 1977w40 | 6 0.14 18.78 1977w41 | 46 1.10 19.88 1977w42 | 27 0.65 20.53 1977w43 | 34 0.82 21.34 1977w44 | 44 1.06 22.40 1977w45 | 75 1.80 24.20 1977w46 | 142 3.41 27.61 1977w47 | 161 3.87 31.48 1977w48 | 262 6.29 37.77 1977w49 | 401 9.63 47.39 1977w50 | 1,466 35.20 82.59 1977w51 | 725 17.41 100.00 ------------+----------------------------------- Total | 4,165 100.00 . /* master only */ > drop _merge; . /*****************************************************************************/ > /*** save data ***/ > save `output'`prg', replace; (note: file ../output/nlsy_data.dta not found) file ../output/nlsy_data.dta saved . log close; name: log: C:\Users\rwr\Dropbox\basu-house\build\code\../temp/nlsy_data.log log type: text closed on: 17 Jul 2016, 17:07:44 ----------------------------------------------------------------------------------------------------------------------------------