* PIAAC data are available from http://www.oecd.org/skills/piaac/publicdataandanalysis/


use "\\LANCS\homes\58\ecagj\My Documents\PIAAC\prggbrp1.dta" 
g male=0
replace male=1 if A_N01_T==1
g noqual=0
replace noqual=1 if B_Q01a==1
g lowersec=0
replace lowersec=1 if B_Q01a>=2&B_Q01a<=5
g uppersec=0
replace uppersec=1 if B_Q01a>=6&B_Q01a<=10
g highered=0
replace highered=1 if B_Q01a>=11
drop if B_Q01a>=15
drop if C_Q01a~=1
g spec_arts=0
replace spec_arts=1 if B_Q01b>=2&B_Q01b<=3
g spec_socsci=0
replace spec_socsci=1 if B_Q01b==4
g spec_sci=0
replace spec_sci=1 if B_Q01b>=5&B_Q01b<=7
g spec_med=0
replace spec_med=1 if B_Q01b==8
g wage=D_Q16b

replace wage=wage/(52*D_Q10) if D_Q16a==6
replace wage=wage/(4*D_Q10) if D_Q16a==5
replace wage=wage/(2*D_Q10) if D_Q16a==4
replace wage=wage/D_Q10 if D_Q16a==3
replace wage=wage/(D_Q10/5) if D_Q16a==2
g experience = C_Q09
g age=AGE_R
g tenure=age-D_Q05a1
g size110=0
replace size110=1 if D_Q06a==1
g size1150=0
replace size1150=1 if D_Q06a==2
g size51250=0
replace size51250=1 if D_Q06a==3
g size2511000=0
replace size2511000=1 if D_Q06a==4
g size1000=0
replace size1000=1 if D_Q06a==5
drop if D_Q06a>5
g supervise=0
replace supervise=1 if D_Q08a==1
g overeducated=0
replace overeducated=1 if B_Q01a>D_Q12a|D_Q12b==2
g manproftech=0
destring ISCO1C, replace
replace manproftech=1 if ISCO1C>=1&ISCO1C<=3
g clerical=0
replace clerical=1 if ISCO1C==4
g sales=0
replace sales=1 if ISCO1C==5
g manual=0
g pared=0 if pared~=3
replace pared=1 if pared==3
g born=0
replace born=1 if J_Q04a==1

g tenure05=0
replace tenure05=1 if tenure<=5
g tenure5plus=0
replace tenure5plus=1 if tenure>5
g age1624=0
replace age1624=1 if age>=16&age<=24
g age2549=0
replace age2549=1 if age>=25&age<=49
g age50plus=0
replace age50plus=1 if age>=50
replace manual=1 if ISCO1C<1|ISCO1C>5
drop if male==.|noqual==.| lowersec==.| uppersec==.| highered==.| experience==.| age<16|age>65|age==.| tenure==.| size110==.| size1150==.| size51250==.| size2511000==.| size1000==.| supervise==.| overeducated==.| manproftech==.| clerical==.| sales==.| manual==.
summarize overeducated
mean overeducated [pw=1/SPFWT0]
mean overeducated if male==1 [pw=1/SPFWT0]
mean overeducated if male~=1 [pw=1/SPFWT0]
mean overeducated if manproftech==1 [pw=1/SPFWT0]
mean overeducated if clerical==1 [pw=1/SPFWT0]
mean overeducated if sales==1 [pw=1/SPFWT0]
mean overeducated if manual==1 [pw=1/SPFWT0]
mean overeducated if highered==1 [pw=1/SPFWT0]
mean overeducated if uppersec==1 [pw=1/SPFWT0]
mean overeducated if lowersec==1 [pw=1/SPFWT0]
mean overeducated if spec_arts==1 [pw=1/SPFWT0]
mean overeducated if spec_socsci==1 [pw=1/SPFWT0]
mean overeducated if spec_sci==1 [pw=1/SPFWT0]
mean overeducated if spec_med==1 [pw=1/SPFWT0]
mean overeducated if tenure05==1 [pw=1/SPFWT0]
mean overeducated if tenure5plus==1 [pw=1/SPFWT0]
mean overeducated if age1624==1 [pw=1/SPFWT0]
mean overeducated if age2549==1 [pw=1/SPFWT0]
mean overeducated if age50plus==1 [pw=1/SPFWT0]
mean overeducated if supervise==1 [pw=1/SPFWT0]
mean overeducated if size110==1 [pw=1/SPFWT0]
mean overeducated if size1150==1 [pw=1/SPFWT0]
mean overeducated if size51250==1 [pw=1/SPFWT0]
mean overeducated if size2511000==1 [pw=1/SPFWT0]
mean overeducated if size1000==1 [pw=1/SPFWT0]
mean overeducated if born==1 [pw=1/SPFWT0]
mean overeducated if pared==1 [pw=1/SPFWT0]
logit overeducated manproftech clerical sales supervise size1150 size51250 size2511000 size1000 born pared experience tenure lowersec uppersec highered male spec_arts spec_socsci spec_sci spec_med [pweight=1/SPFWT0]
mfx
summarize size110 size1150 size51250 size2511000 size1000

g advice=0
g plan=0
g infl=0
g negotiate=0
g probsimp=0
g probcomp=0
g reademail=0
g readart=0
g readrep=0
g writeemail=0
g writeart=0
g writerep=0
g calculator=0
g computer=0
replace advice=1 if F_Q02a>=3&F_Q02a<=5
replace plan=1 if F_Q03b>=3&F_Q03b<=5
replace infl=1 if F_Q04a>=3&F_Q04a<=5
replace negotiate=1 if F_Q04b>=3&F_Q04b<=5
replace probsimp=1 if F_Q05a>=3&F_Q05a<=5
replace probcomp=1 if F_Q05b>=3&F_Q05b<=5
replace reademail=1 if G_Q01a>=3&G_Q01a<=5
replace readart=1 if G_Q01c>=3&G_Q01c<=5
replace readrep=1 if G_Q01f>=3&G_Q01f<=5
replace writeemail=1 if G_Q02a>=3&G_Q02a<=5
replace writeart=1 if G_Q02b>=3&G_Q02b<=5
replace writerep=1 if G_Q02c>=3&G_Q02c<=5
replace calculator=1 if G_Q03d>=3&G_Q03d<=5
replace computer=1 if G_Q04==1
mean highered if clerical==1 [pw=1/SPFWT0]
mean uppersec if clerical==1 [pw=1/SPFWT0]
mean advice if clerical==1 [pw=1/SPFWT0]
mean plan if clerical==1 [pw=1/SPFWT0]
mean infl if clerical==1 [pw=1/SPFWT0]
mean negotiate if clerical==1 [pw=1/SPFWT0]
mean probsimp if clerical==1 [pw=1/SPFWT0]
mean probcomp if clerical==1 [pw=1/SPFWT0]
mean reademail if clerical==1 [pw=1/SPFWT0]
mean readart if clerical==1 [pw=1/SPFWT0]
mean readrep if clerical==1 [pw=1/SPFWT0]
mean writeemail if clerical==1 [pw=1/SPFWT0]
mean writeart if clerical==1 [pw=1/SPFWT0]
mean writerep if clerical==1 [pw=1/SPFWT0]
mean calculator if clerical==1 [pw=1/SPFWT0]
mean computer if clerical==1 [pw=1/SPFWT0]
g lnw=ln(wage)
g exp2=experience^2
g overhigh=highered*overeducated
g oversec=0
replace oversec=1 if overeducated==1&overhigh==0
regress lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0]
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.25)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0]
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.75)

use "\\LANCS\homes\58\ecagj\My Documents\PIAAC\prgdeup1.dta" , replace
g male=0
replace male=1 if A_N01_T==1
g noqual=0
replace noqual=1 if B_Q01a==1
g lowersec=0
replace lowersec=1 if B_Q01a>=2&B_Q01a<=5
g uppersec=0
replace uppersec=1 if B_Q01a>=6&B_Q01a<=10
g highered=0
replace highered=1 if B_Q01a>=11
drop if B_Q01a>=15
drop if C_Q01a~=1
g spec_arts=0
replace spec_arts=1 if B_Q01b>=2&B_Q01b<=3
g spec_socsci=0
replace spec_socsci=1 if B_Q01b==4
g spec_sci=0
replace spec_sci=1 if B_Q01b>=5&B_Q01b<=7
g spec_med=0
replace spec_med=1 if B_Q01b==8
g wage=D_Q16b

replace wage=wage/(52*D_Q10) if D_Q16a==6
replace wage=wage/(4*D_Q10) if D_Q16a==5
replace wage=wage/(2*D_Q10) if D_Q16a==4
replace wage=wage/D_Q10 if D_Q16a==3
replace wage=wage/(D_Q10/5) if D_Q16a==2
g experience = C_Q09_C
g age=AGE_R
g tenure=age-D_Q05a1
g size110=0
replace size110=1 if D_Q06a==1
g size1150=0
replace size1150=1 if D_Q06a==2
g size51250=0
replace size51250=1 if D_Q06a==3
g size2511000=0
replace size2511000=1 if D_Q06a==4
g size1000=0
replace size1000=1 if D_Q06a==5
drop if D_Q06a>5
g supervise=0
replace supervise=1 if D_Q08a==1
g overeducated=0
replace overeducated=1 if B_Q01a>D_Q12a|D_Q12b==2
g manproftech=0
destring ISCO1C, replace
replace manproftech=1 if ISCO1C>=1&ISCO1C<=3
g clerical=0
replace clerical=1 if ISCO1C==4
g sales=0
replace sales=1 if ISCO1C==5
g manual=0
g pared=0 if pared~=3
replace pared=1 if pared==3
g born=0
replace born=1 if J_Q04a==1

g tenure05=0
replace tenure05=1 if tenure<=5
g tenure5plus=0
replace tenure5plus=1 if tenure>5
g age1624=0
replace age1624=1 if age>=16&age<=24
g age2549=0
replace age2549=1 if age>=25&age<=49
g age50plus=0
replace age50plus=1 if age>=50
replace manual=1 if ISCO1C<1|ISCO1C>5
drop if male==.|noqual==.| lowersec==.| uppersec==.| highered==.| experience==.| size110==.| size1150==.| size51250==.| size2511000==.| size1000==.| supervise==.| overeducated==.| manproftech==.| clerical==.| sales==.| manual==.
summarize overeducated
mean overeducated [pw=1/SPFWT0]
mean overeducated if male==1 [pw=1/SPFWT0]
mean overeducated if male~=1 [pw=1/SPFWT0]
mean overeducated if manproftech==1 [pw=1/SPFWT0]
mean overeducated if clerical==1 [pw=1/SPFWT0]
mean overeducated if sales==1 [pw=1/SPFWT0]
mean overeducated if manual==1 [pw=1/SPFWT0]
mean overeducated if highered==1 [pw=1/SPFWT0]
mean overeducated if uppersec==1 [pw=1/SPFWT0]
mean overeducated if lowersec==1 [pw=1/SPFWT0]
mean overeducated if spec_arts==1 [pw=1/SPFWT0]
mean overeducated if spec_socsci==1 [pw=1/SPFWT0]
mean overeducated if spec_sci==1 [pw=1/SPFWT0]
mean overeducated if spec_med==1 [pw=1/SPFWT0]
mean overeducated if tenure05==1 [pw=1/SPFWT0]
mean overeducated if tenure5plus==1 [pw=1/SPFWT0]
mean overeducated if age1624==1 [pw=1/SPFWT0]
mean overeducated if age2549==1 [pw=1/SPFWT0]
mean overeducated if age50plus==1 [pw=1/SPFWT0]
mean overeducated if supervise==1 [pw=1/SPFWT0]
mean overeducated if size110==1 [pw=1/SPFWT0]
mean overeducated if size1150==1 [pw=1/SPFWT0]
mean overeducated if size51250==1 [pw=1/SPFWT0]
mean overeducated if size2511000==1 [pw=1/SPFWT0]
mean overeducated if size1000==1 [pw=1/SPFWT0]
mean overeducated if born==1 [pw=1/SPFWT0]
mean overeducated if pared==1 [pw=1/SPFWT0]
logit overeducated manproftech clerical sales supervise size1150 size51250 size2511000 size1000 born pared experience lowersec uppersec highered male spec_arts spec_socsci spec_sci spec_med [pweight=1/SPFWT0]
mfx
summarize size110 size1150 size51250 size2511000 size1000
g advice=0
g plan=0
g infl=0
g negotiate=0
g probsimp=0
g probcomp=0
g reademail=0
g readart=0
g readrep=0
g writeemail=0
g writeart=0
g writerep=0
g calculator=0
g computer=0
replace advice=1 if F_Q02a>=3&F_Q02a<=5
replace plan=1 if F_Q03b>=3&F_Q03b<=5
replace infl=1 if F_Q04a>=3&F_Q04a<=5
replace negotiate=1 if F_Q04b>=3&F_Q04b<=5
replace probsimp=1 if F_Q05a>=3&F_Q05a<=5
replace probcomp=1 if F_Q05b>=3&F_Q05b<=5
replace reademail=1 if G_Q01a>=3&G_Q01a<=5
replace readart=1 if G_Q01c>=3&G_Q01c<=5
replace readrep=1 if G_Q01f>=3&G_Q01f<=5
replace writeemail=1 if G_Q02a>=3&G_Q02a<=5
replace writeart=1 if G_Q02b>=3&G_Q02b<=5
replace writerep=1 if G_Q02c>=3&G_Q02c<=5
replace calculator=1 if G_Q03d>=3&G_Q03d<=5
replace computer=1 if G_Q04==1
mean highered if clerical==1 [pw=1/SPFWT0]
mean uppersec if clerical==1 [pw=1/SPFWT0]
mean advice if clerical==1 [pw=1/SPFWT0]
mean plan if clerical==1 [pw=1/SPFWT0]
mean infl if clerical==1 [pw=1/SPFWT0]
mean negotiate if clerical==1 [pw=1/SPFWT0]
mean probsimp if clerical==1 [pw=1/SPFWT0]
mean probcomp if clerical==1 [pw=1/SPFWT0]
mean reademail if clerical==1 [pw=1/SPFWT0]
mean readart if clerical==1 [pw=1/SPFWT0]
mean readrep if clerical==1 [pw=1/SPFWT0]
mean writeemail if clerical==1 [pw=1/SPFWT0]
mean writeart if clerical==1 [pw=1/SPFWT0]
mean writerep if clerical==1 [pw=1/SPFWT0]
mean calculator if clerical==1 [pw=1/SPFWT0]
mean computer if clerical==1 [pw=1/SPFWT0]
g lnw=ln(wage)
g exp2=experience^2
g overhigh=highered*overeducated
g oversec=0
replace oversec=1 if overeducated==1&overhigh==0
regress lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0]



use "\\LANCS\homes\58\ecagj\My Documents\PIAAC\prgfrap1.dta" , replace
g male=0
replace male=1 if A_N01_T==1
g noqual=0
replace noqual=1 if B_Q01a==1
g lowersec=0
replace lowersec=1 if B_Q01a>=2&B_Q01a<=5
g uppersec=0
replace uppersec=1 if B_Q01a>=6&B_Q01a<=10
g highered=0
replace highered=1 if B_Q01a>=11
drop if B_Q01a>=15
drop if C_Q01a~=1
g spec_arts=0
replace spec_arts=1 if B_Q01b>=2&B_Q01b<=3
g spec_socsci=0
replace spec_socsci=1 if B_Q01b==4
g spec_sci=0
replace spec_sci=1 if B_Q01b>=5&B_Q01b<=7
g spec_med=0
replace spec_med=1 if B_Q01b==8
g wage=D_Q16b

replace wage=wage/(52*D_Q10) if D_Q16a==6
replace wage=wage/(4*D_Q10) if D_Q16a==5
replace wage=wage/(2*D_Q10) if D_Q16a==4
replace wage=wage/D_Q10 if D_Q16a==3
replace wage=wage/(D_Q10/5) if D_Q16a==2
g experience = C_Q09
g age=AGE_R
g tenure=age-D_Q05a1
g size110=0
replace size110=1 if D_Q06a==1
g size1150=0
replace size1150=1 if D_Q06a==2
g size51250=0
replace size51250=1 if D_Q06a==3
g size2511000=0
replace size2511000=1 if D_Q06a==4
g size1000=0
replace size1000=1 if D_Q06a==5
drop if D_Q06a>5
g supervise=0
replace supervise=1 if D_Q08a==1
g overeducated=0
replace overeducated=1 if B_Q01a>D_Q12a|D_Q12b==2
g manproftech=0
destring ISCO1C, replace
replace manproftech=1 if ISCO1C>=1&ISCO1C<=3
g clerical=0
replace clerical=1 if ISCO1C==4
g sales=0
replace sales=1 if ISCO1C==5
g manual=0
g pared=0 if pared~=3
replace pared=1 if pared==3
g born=0
replace born=1 if J_Q04a==1

g tenure05=0
replace tenure05=1 if tenure<=5
g tenure5plus=0
replace tenure5plus=1 if tenure>5
g age1624=0
replace age1624=1 if age>=16&age<=24
g age2549=0
replace age2549=1 if age>=25&age<=49
g age50plus=0
replace age50plus=1 if age>=50
replace manual=1 if ISCO1C<1|ISCO1C>5
drop if male==.|noqual==.| lowersec==.| uppersec==.| highered==.| experience==.| age<16|age>65|age==.| tenure==.| size110==.| size1150==.| size51250==.| size2511000==.| size1000==.| supervise==.| overeducated==.| manproftech==.| clerical==.| sales==.| manual==.
summarize overeducated
mean overeducated [pw=1/SPFWT0]
mean overeducated if male==1 [pw=1/SPFWT0]
mean overeducated if male~=1 [pw=1/SPFWT0]
mean overeducated if manproftech==1 [pw=1/SPFWT0]
mean overeducated if clerical==1 [pw=1/SPFWT0]
mean overeducated if sales==1 [pw=1/SPFWT0]
mean overeducated if manual==1 [pw=1/SPFWT0]
mean overeducated if highered==1 [pw=1/SPFWT0]
mean overeducated if uppersec==1 [pw=1/SPFWT0]
mean overeducated if lowersec==1 [pw=1/SPFWT0]
mean overeducated if spec_arts==1 [pw=1/SPFWT0]
mean overeducated if spec_socsci==1 [pw=1/SPFWT0]
mean overeducated if spec_sci==1 [pw=1/SPFWT0]
mean overeducated if spec_med==1 [pw=1/SPFWT0]
mean overeducated if tenure05==1 [pw=1/SPFWT0]
mean overeducated if tenure5plus==1 [pw=1/SPFWT0]
mean overeducated if age1624==1 [pw=1/SPFWT0]
mean overeducated if age2549==1 [pw=1/SPFWT0]
mean overeducated if age50plus==1 [pw=1/SPFWT0]
mean overeducated if supervise==1 [pw=1/SPFWT0]
mean overeducated if size110==1 [pw=1/SPFWT0]
mean overeducated if size1150==1 [pw=1/SPFWT0]
mean overeducated if size51250==1 [pw=1/SPFWT0]
mean overeducated if size2511000==1 [pw=1/SPFWT0]
mean overeducated if size1000==1 [pw=1/SPFWT0]
mean overeducated if born==1 [pw=1/SPFWT0]
mean overeducated if pared==1 [pw=1/SPFWT0]
logit overeducated manproftech clerical sales supervise size1150 size51250 size2511000 size1000 born pared experience tenure lowersec uppersec highered male spec_arts spec_socsci spec_sci spec_med [pweight=1/SPFWT0]
mfx

summarize size110 size1150 size51250 size2511000 size1000
g advice=0
g plan=0
g infl=0
g negotiate=0
g probsimp=0
g probcomp=0
g reademail=0
g readart=0
g readrep=0
g writeemail=0
g writeart=0
g writerep=0
g calculator=0
g computer=0
replace advice=1 if F_Q02a>=3&F_Q02a<=5
replace plan=1 if F_Q03b>=3&F_Q03b<=5
replace infl=1 if F_Q04a>=3&F_Q04a<=5
replace negotiate=1 if F_Q04b>=3&F_Q04b<=5
replace probsimp=1 if F_Q05a>=3&F_Q05a<=5
replace probcomp=1 if F_Q05b>=3&F_Q05b<=5
replace reademail=1 if G_Q01a>=3&G_Q01a<=5
replace readart=1 if G_Q01c>=3&G_Q01c<=5
replace readrep=1 if G_Q01f>=3&G_Q01f<=5
replace writeemail=1 if G_Q02a>=3&G_Q02a<=5
replace writeart=1 if G_Q02b>=3&G_Q02b<=5
replace writerep=1 if G_Q02c>=3&G_Q02c<=5
replace calculator=1 if G_Q03d>=3&G_Q03d<=5
replace computer=1 if G_Q04==1
mean highered if clerical==1 [pw=1/SPFWT0]
mean uppersec if clerical==1 [pw=1/SPFWT0]
mean advice if clerical==1 [pw=1/SPFWT0]
mean plan if clerical==1 [pw=1/SPFWT0]
mean infl if clerical==1 [pw=1/SPFWT0]
mean negotiate if clerical==1 [pw=1/SPFWT0]
mean probsimp if clerical==1 [pw=1/SPFWT0]
mean probcomp if clerical==1 [pw=1/SPFWT0]
mean reademail if clerical==1 [pw=1/SPFWT0]
mean readart if clerical==1 [pw=1/SPFWT0]
mean readrep if clerical==1 [pw=1/SPFWT0]
mean writeemail if clerical==1 [pw=1/SPFWT0]
mean writeart if clerical==1 [pw=1/SPFWT0]
mean writerep if clerical==1 [pw=1/SPFWT0]
mean calculator if clerical==1 [pw=1/SPFWT0]
mean computer if clerical==1 [pw=1/SPFWT0]
g lnw=ln(wage)
g exp2=experience^2
g overhigh=highered*overeducated
g oversec=0
replace oversec=1 if overeducated==1&overhigh==0
regress lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0]
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.25)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0]
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.75)



use "\\LANCS\homes\58\ecagj\My Documents\PIAAC\prgitap1.dta" , replace
g male=0
replace male=1 if A_N01_T==1
g noqual=0
replace noqual=1 if B_Q01a==1
g lowersec=0
replace lowersec=1 if B_Q01a>=2&B_Q01a<=5
g uppersec=0
replace uppersec=1 if B_Q01a>=6&B_Q01a<=10
g highered=0
replace highered=1 if B_Q01a>=11
drop if B_Q01a>=15
drop if C_Q01a~=1
g spec_arts=0
replace spec_arts=1 if B_Q01b>=2&B_Q01b<=3
g spec_socsci=0
replace spec_socsci=1 if B_Q01b==4
g spec_sci=0
replace spec_sci=1 if B_Q01b>=5&B_Q01b<=7
g spec_med=0
replace spec_med=1 if B_Q01b==8
g wage=D_Q16b

replace wage=wage/(52*D_Q10) if D_Q16a==6
replace wage=wage/(4*D_Q10) if D_Q16a==5
replace wage=wage/(2*D_Q10) if D_Q16a==4
replace wage=wage/D_Q10 if D_Q16a==3
replace wage=wage/(D_Q10/5) if D_Q16a==2
g experience = C_Q09
g age=AGE_R
g tenure=age-D_Q05a1
g size110=0
replace size110=1 if D_Q06a==1
g size1150=0
replace size1150=1 if D_Q06a==2
g size51250=0
replace size51250=1 if D_Q06a==3
g size2511000=0
replace size2511000=1 if D_Q06a==4
g size1000=0
replace size1000=1 if D_Q06a==5
drop if D_Q06a>5
g supervise=0
replace supervise=1 if D_Q08a==1
g overeducated=0
replace overeducated=1 if B_Q01a>D_Q12a|D_Q12b==2
g manproftech=0
destring ISCO1C, replace
replace manproftech=1 if ISCO1C>=1&ISCO1C<=3
g clerical=0
replace clerical=1 if ISCO1C==4
g sales=0
replace sales=1 if ISCO1C==5
g manual=0
g pared=0 if pared~=3
replace pared=1 if pared==3
g born=0
replace born=1 if J_Q04a==1

g tenure05=0
replace tenure05=1 if tenure<=5
g tenure5plus=0
replace tenure5plus=1 if tenure>5
g age1624=0
replace age1624=1 if age>=16&age<=24
g age2549=0
replace age2549=1 if age>=25&age<=49
g age50plus=0
replace age50plus=1 if age>=50
replace manual=1 if ISCO1C<1|ISCO1C>5
drop if male==.|noqual==.| lowersec==.| uppersec==.| highered==.| experience==.| age<16|age>65|age==.| tenure==.| size110==.| size1150==.| size51250==.| size2511000==.| size1000==.| supervise==.| overeducated==.| manproftech==.| clerical==.| sales==.| manual==.
summarize overeducated
mean overeducated [pw=1/SPFWT0]
mean overeducated if male==1 [pw=1/SPFWT0]
mean overeducated if male~=1 [pw=1/SPFWT0]
mean overeducated if manproftech==1 [pw=1/SPFWT0]
mean overeducated if clerical==1 [pw=1/SPFWT0]
mean overeducated if sales==1 [pw=1/SPFWT0]
mean overeducated if manual==1 [pw=1/SPFWT0]
mean overeducated if highered==1 [pw=1/SPFWT0]
mean overeducated if uppersec==1 [pw=1/SPFWT0]
mean overeducated if lowersec==1 [pw=1/SPFWT0]
mean overeducated if spec_arts==1 [pw=1/SPFWT0]
mean overeducated if spec_socsci==1 [pw=1/SPFWT0]
mean overeducated if spec_sci==1 [pw=1/SPFWT0]
mean overeducated if spec_med==1 [pw=1/SPFWT0]
mean overeducated if tenure05==1 [pw=1/SPFWT0]
mean overeducated if tenure5plus==1 [pw=1/SPFWT0]
mean overeducated if age1624==1 [pw=1/SPFWT0]
mean overeducated if age2549==1 [pw=1/SPFWT0]
mean overeducated if age50plus==1 [pw=1/SPFWT0]
mean overeducated if supervise==1 [pw=1/SPFWT0]
mean overeducated if size110==1 [pw=1/SPFWT0]
mean overeducated if size1150==1 [pw=1/SPFWT0]
mean overeducated if size51250==1 [pw=1/SPFWT0]
mean overeducated if size2511000==1 [pw=1/SPFWT0]
mean overeducated if size1000==1 [pw=1/SPFWT0]
mean overeducated if born==1 [pw=1/SPFWT0]
mean overeducated if pared==1 [pw=1/SPFWT0]
logit overeducated manproftech clerical sales supervise size1150 size51250 size2511000 size1000 born pared experience tenure uppersec highered male spec_arts spec_socsci spec_sci spec_med [pweight=1/SPFWT0]
mfx

summarize size110 size1150 size51250 size2511000 size1000
g advice=0
g plan=0
g infl=0
g negotiate=0
g probsimp=0
g probcomp=0
g reademail=0
g readart=0
g readrep=0
g writeemail=0
g writeart=0
g writerep=0
g calculator=0
g computer=0
replace advice=1 if F_Q02a>=3&F_Q02a<=5
replace plan=1 if F_Q03b>=3&F_Q03b<=5
replace infl=1 if F_Q04a>=3&F_Q04a<=5
replace negotiate=1 if F_Q04b>=3&F_Q04b<=5
replace probsimp=1 if F_Q05a>=3&F_Q05a<=5
replace probcomp=1 if F_Q05b>=3&F_Q05b<=5
replace reademail=1 if G_Q01a>=3&G_Q01a<=5
replace readart=1 if G_Q01c>=3&G_Q01c<=5
replace readrep=1 if G_Q01f>=3&G_Q01f<=5
replace writeemail=1 if G_Q02a>=3&G_Q02a<=5
replace writeart=1 if G_Q02b>=3&G_Q02b<=5
replace writerep=1 if G_Q02c>=3&G_Q02c<=5
replace calculator=1 if G_Q03d>=3&G_Q03d<=5
replace computer=1 if G_Q04==1
mean highered if clerical==1 [pw=1/SPFWT0]
mean uppersec if clerical==1 [pw=1/SPFWT0]
mean advice if clerical==1 [pw=1/SPFWT0]
mean plan if clerical==1 [pw=1/SPFWT0]
mean infl if clerical==1 [pw=1/SPFWT0]
mean negotiate if clerical==1 [pw=1/SPFWT0]
mean probsimp if clerical==1 [pw=1/SPFWT0]
mean probcomp if clerical==1 [pw=1/SPFWT0]
mean reademail if clerical==1 [pw=1/SPFWT0]
mean readart if clerical==1 [pw=1/SPFWT0]
mean readrep if clerical==1 [pw=1/SPFWT0]
mean writeemail if clerical==1 [pw=1/SPFWT0]
mean writeart if clerical==1 [pw=1/SPFWT0]
mean writerep if clerical==1 [pw=1/SPFWT0]
mean calculator if clerical==1 [pw=1/SPFWT0]
mean computer if clerical==1 [pw=1/SPFWT0]
g lnw=ln(wage)
g exp2=experience^2
g overhigh=highered*overeducated
g oversec=0
replace oversec=1 if overeducated==1&overhigh==0
regress lnw experience exp2 highered uppersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0]
qreg lnw experience exp2 highered uppersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.25)
qreg lnw experience exp2 highered uppersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0]
qreg lnw experience exp2 highered uppersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.75)



use "\\LANCS\homes\58\ecagj\My Documents\PIAAC\prgjpnp1.dta" , replace
g male=0
replace male=1 if A_N01_T==1
g noqual=0
replace noqual=1 if B_Q01a==1
g lowersec=0
replace lowersec=1 if B_Q01a>=2&B_Q01a<=5
g uppersec=0
replace uppersec=1 if B_Q01a>=6&B_Q01a<=10
g highered=0
replace highered=1 if B_Q01a>=11
drop if B_Q01a>=15
drop if C_Q01a~=1
g spec_arts=0
replace spec_arts=1 if B_Q01b>=2&B_Q01b<=3
g spec_socsci=0
replace spec_socsci=1 if B_Q01b==4
g spec_sci=0
replace spec_sci=1 if B_Q01b>=5&B_Q01b<=7
g spec_med=0
replace spec_med=1 if B_Q01b==8
g wage=D_Q16b

replace wage=wage/(52*D_Q10) if D_Q16a==6
replace wage=wage/(4*D_Q10) if D_Q16a==5
replace wage=wage/(2*D_Q10) if D_Q16a==4
replace wage=wage/D_Q10 if D_Q16a==3
replace wage=wage/(D_Q10/5) if D_Q16a==2
g experience = C_Q09
g age=AGE_R
g tenure=age-D_Q05a1
g size110=0
replace size110=1 if D_Q06a==1
g size1150=0
replace size1150=1 if D_Q06a==2
g size51250=0
replace size51250=1 if D_Q06a==3
g size2511000=0
replace size2511000=1 if D_Q06a==4
g size1000=0
replace size1000=1 if D_Q06a==5
drop if D_Q06a>5
g supervise=0
replace supervise=1 if D_Q08a==1
g overeducated=0
replace overeducated=1 if B_Q01a>D_Q12a|D_Q12b==2
g manproftech=0
destring ISCO1C, replace
replace manproftech=1 if ISCO1C>=1&ISCO1C<=3
g clerical=0
replace clerical=1 if ISCO1C==4
g sales=0
replace sales=1 if ISCO1C==5
g manual=0
g pared=0 if pared~=3
replace pared=1 if pared==3
g born=0
replace born=1 if J_Q04a==1

g tenure05=0
replace tenure05=1 if tenure<=5
g tenure5plus=0
replace tenure5plus=1 if tenure>5
g age1624=0
replace age1624=1 if age>=16&age<=24
g age2549=0
replace age2549=1 if age>=25&age<=49
g age50plus=0
replace age50plus=1 if age>=50
replace manual=1 if ISCO1C<1|ISCO1C>5
drop if male==.|noqual==.| lowersec==.| uppersec==.| highered==.| experience==.| age<16|age>65|age==.| tenure==.| size110==.| size1150==.| size51250==.| size2511000==.| size1000==.| supervise==.| overeducated==.| manproftech==.| clerical==.| sales==.| manual==.
summarize overeducated
mean overeducated [pw=1/SPFWT0]
mean overeducated if male==1 [pw=1/SPFWT0]
mean overeducated if male~=1 [pw=1/SPFWT0]
mean overeducated if manproftech==1 [pw=1/SPFWT0]
mean overeducated if clerical==1 [pw=1/SPFWT0]
mean overeducated if sales==1 [pw=1/SPFWT0]
mean overeducated if manual==1 [pw=1/SPFWT0]
mean overeducated if highered==1 [pw=1/SPFWT0]
mean overeducated if uppersec==1 [pw=1/SPFWT0]
mean overeducated if lowersec==1 [pw=1/SPFWT0]
mean overeducated if spec_arts==1 [pw=1/SPFWT0]
mean overeducated if spec_socsci==1 [pw=1/SPFWT0]
mean overeducated if spec_sci==1 [pw=1/SPFWT0]
mean overeducated if spec_med==1 [pw=1/SPFWT0]
mean overeducated if tenure05==1 [pw=1/SPFWT0]
mean overeducated if tenure5plus==1 [pw=1/SPFWT0]
mean overeducated if age1624==1 [pw=1/SPFWT0]
mean overeducated if age2549==1 [pw=1/SPFWT0]
mean overeducated if age50plus==1 [pw=1/SPFWT0]
mean overeducated if supervise==1 [pw=1/SPFWT0]
mean overeducated if size110==1 [pw=1/SPFWT0]
mean overeducated if size1150==1 [pw=1/SPFWT0]
mean overeducated if size51250==1 [pw=1/SPFWT0]
mean overeducated if size2511000==1 [pw=1/SPFWT0]
mean overeducated if size1000==1 [pw=1/SPFWT0]
mean overeducated if born==1 [pw=1/SPFWT0]
mean overeducated if pared==1 [pw=1/SPFWT0]
logit overeducated manproftech clerical sales supervise size1150 size51250 size2511000 size1000 born pared experience tenure uppersec highered male spec_arts spec_socsci spec_sci spec_med [pweight=1/SPFWT0]
mfx

summarize size110 size1150 size51250 size2511000 size1000
g advice=0
g plan=0
g infl=0
g negotiate=0
g probsimp=0
g probcomp=0
g reademail=0
g readart=0
g readrep=0
g writeemail=0
g writeart=0
g writerep=0
g calculator=0
g computer=0
replace advice=1 if F_Q02a>=3&F_Q02a<=5
replace plan=1 if F_Q03b>=3&F_Q03b<=5
replace infl=1 if F_Q04a>=3&F_Q04a<=5
replace negotiate=1 if F_Q04b>=3&F_Q04b<=5
replace probsimp=1 if F_Q05a>=3&F_Q05a<=5
replace probcomp=1 if F_Q05b>=3&F_Q05b<=5
replace reademail=1 if G_Q01a>=3&G_Q01a<=5
replace readart=1 if G_Q01c>=3&G_Q01c<=5
replace readrep=1 if G_Q01f>=3&G_Q01f<=5
replace writeemail=1 if G_Q02a>=3&G_Q02a<=5
replace writeart=1 if G_Q02b>=3&G_Q02b<=5
replace writerep=1 if G_Q02c>=3&G_Q02c<=5
replace calculator=1 if G_Q03d>=3&G_Q03d<=5
replace computer=1 if G_Q04==1
mean highered if clerical==1 [pw=1/SPFWT0]
mean uppersec if clerical==1 [pw=1/SPFWT0]
mean advice if clerical==1 [pw=1/SPFWT0]
mean plan if clerical==1 [pw=1/SPFWT0]
mean infl if clerical==1 [pw=1/SPFWT0]
mean negotiate if clerical==1 [pw=1/SPFWT0]
mean probsimp if clerical==1 [pw=1/SPFWT0]
mean probcomp if clerical==1 [pw=1/SPFWT0]
mean reademail if clerical==1 [pw=1/SPFWT0]
mean readart if clerical==1 [pw=1/SPFWT0]
mean readrep if clerical==1 [pw=1/SPFWT0]
mean writeemail if clerical==1 [pw=1/SPFWT0]
mean writeart if clerical==1 [pw=1/SPFWT0]
mean writerep if clerical==1 [pw=1/SPFWT0]
mean calculator if clerical==1 [pw=1/SPFWT0]
mean computer if clerical==1 [pw=1/SPFWT0]
g lnw=ln(wage)
g exp2=experience^2
g overhigh=highered*overeducated
g oversec=0
replace oversec=1 if overeducated==1&overhigh==0
regress lnw experience exp2 highered uppersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0]
qreg lnw experience exp2 highered uppersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.25)
qreg lnw experience exp2 highered uppersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0]
qreg lnw experience exp2 highered uppersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.75)



use "\\LANCS\homes\58\ecagj\My Documents\PIAAC\prgusap1.dta" , replace
g male=0
replace male=1 if A_N01_T==1
g noqual=0
replace noqual=1 if B_Q01a==1
g lowersec=0
replace lowersec=1 if B_Q01a>=2&B_Q01a<=5
g uppersec=0
replace uppersec=1 if B_Q01a>=6&B_Q01a<=10
g highered=0
replace highered=1 if B_Q01a>=11
drop if B_Q01a>=15
drop if C_Q01a~=1
g spec_arts=0
replace spec_arts=1 if B_Q01b>=2&B_Q01b<=3
g spec_socsci=0
replace spec_socsci=1 if B_Q01b==4
g spec_sci=0
replace spec_sci=1 if B_Q01b>=5&B_Q01b<=7
g spec_med=0
replace spec_med=1 if B_Q01b==8
g wage=D_Q16b

replace wage=wage/(52*D_Q10) if D_Q16a==6
replace wage=wage/(4*D_Q10) if D_Q16a==5
replace wage=wage/(2*D_Q10) if D_Q16a==4
replace wage=wage/D_Q10 if D_Q16a==3
replace wage=wage/(D_Q10/5) if D_Q16a==2
g experience = C_Q09_C
g age=AGE_R
g tenure=age-D_Q05a1
g size110=0
replace size110=1 if D_Q06a==1
g size1150=0
replace size1150=1 if D_Q06a==2
g size51250=0
replace size51250=1 if D_Q06a==3
g size2511000=0
replace size2511000=1 if D_Q06a==4
g size1000=0
replace size1000=1 if D_Q06a==5
drop if D_Q06a>5
g supervise=0
replace supervise=1 if D_Q08a==1
g overeducated=0
replace overeducated=1 if B_Q01a>D_Q12a|D_Q12b==2
g manproftech=0
destring ISCO1C, replace
replace manproftech=1 if ISCO1C>=1&ISCO1C<=3
g clerical=0
replace clerical=1 if ISCO1C==4
g sales=0
replace sales=1 if ISCO1C==5
g manual=0
g pared=0 if pared~=3
replace pared=1 if pared==3
g born=0
replace born=1 if J_Q04a==1

g tenure05=0
replace tenure05=1 if tenure<=5
g tenure5plus=0
replace tenure5plus=1 if tenure>5
g age1624=0
replace age1624=1 if age>=16&age<=24
g age2549=0
replace age2549=1 if age>=25&age<=49
g age50plus=0
replace age50plus=1 if age>=50
replace manual=1 if ISCO1C<1|ISCO1C>5
drop if male==.|noqual==.| lowersec==.| uppersec==.| highered==.| experience==.|size110==.| size1150==.| size51250==.| size2511000==.| size1000==.| supervise==.| overeducated==.| manproftech==.| clerical==.| sales==.| manual==.
summarize overeducated
mean overeducated [pw=1/SPFWT0]
mean overeducated if male==1 [pw=1/SPFWT0]
mean overeducated if male~=1 [pw=1/SPFWT0]
mean overeducated if manproftech==1 [pw=1/SPFWT0]
mean overeducated if clerical==1 [pw=1/SPFWT0]
mean overeducated if sales==1 [pw=1/SPFWT0]
mean overeducated if manual==1 [pw=1/SPFWT0]
mean overeducated if highered==1 [pw=1/SPFWT0]
mean overeducated if uppersec==1 [pw=1/SPFWT0]
mean overeducated if lowersec==1 [pw=1/SPFWT0]
mean overeducated if spec_arts==1 [pw=1/SPFWT0]
mean overeducated if spec_socsci==1 [pw=1/SPFWT0]
mean overeducated if spec_sci==1 [pw=1/SPFWT0]
mean overeducated if spec_med==1 [pw=1/SPFWT0]
mean overeducated if tenure05==1 [pw=1/SPFWT0]
mean overeducated if tenure5plus==1 [pw=1/SPFWT0]
mean overeducated if age1624==1 [pw=1/SPFWT0]
mean overeducated if age2549==1 [pw=1/SPFWT0]
mean overeducated if age50plus==1 [pw=1/SPFWT0]
mean overeducated if supervise==1 [pw=1/SPFWT0]
mean overeducated if size110==1 [pw=1/SPFWT0]
mean overeducated if size1150==1 [pw=1/SPFWT0]
mean overeducated if size51250==1 [pw=1/SPFWT0]
mean overeducated if size2511000==1 [pw=1/SPFWT0]
mean overeducated if size1000==1 [pw=1/SPFWT0]
mean overeducated if born==1 [pw=1/SPFWT0]
mean overeducated if pared==1 [pw=1/SPFWT0]
logit overeducated manproftech clerical sales supervise size1150 size51250 size2511000 size1000 born pared experience uppersec highered male spec_arts spec_socsci spec_sci spec_med [pweight=1/SPFWT0]
mfx

summarize size110 size1150 size51250 size2511000 size1000
g advice=0
g plan=0
g infl=0
g negotiate=0
g probsimp=0
g probcomp=0
g reademail=0
g readart=0
g readrep=0
g writeemail=0
g writeart=0
g writerep=0
g calculator=0
g computer=0
replace advice=1 if F_Q02a>=3&F_Q02a<=5
replace plan=1 if F_Q03b>=3&F_Q03b<=5
replace infl=1 if F_Q04a>=3&F_Q04a<=5
replace negotiate=1 if F_Q04b>=3&F_Q04b<=5
replace probsimp=1 if F_Q05a>=3&F_Q05a<=5
replace probcomp=1 if F_Q05b>=3&F_Q05b<=5
replace reademail=1 if G_Q01a>=3&G_Q01a<=5
replace readart=1 if G_Q01c>=3&G_Q01c<=5
replace readrep=1 if G_Q01f>=3&G_Q01f<=5
replace writeemail=1 if G_Q02a>=3&G_Q02a<=5
replace writeart=1 if G_Q02b>=3&G_Q02b<=5
replace writerep=1 if G_Q02c>=3&G_Q02c<=5
replace calculator=1 if G_Q03d>=3&G_Q03d<=5
replace computer=1 if G_Q04==1
mean highered if clerical==1 [pw=1/SPFWT0]
mean uppersec if clerical==1 [pw=1/SPFWT0]
mean advice if clerical==1 [pw=1/SPFWT0]
mean plan if clerical==1 [pw=1/SPFWT0]
mean infl if clerical==1 [pw=1/SPFWT0]
mean negotiate if clerical==1 [pw=1/SPFWT0]
mean probsimp if clerical==1 [pw=1/SPFWT0]
mean probcomp if clerical==1 [pw=1/SPFWT0]
mean reademail if clerical==1 [pw=1/SPFWT0]
mean readart if clerical==1 [pw=1/SPFWT0]
mean readrep if clerical==1 [pw=1/SPFWT0]
mean writeemail if clerical==1 [pw=1/SPFWT0]
mean writeart if clerical==1 [pw=1/SPFWT0]
mean writerep if clerical==1 [pw=1/SPFWT0]
mean calculator if clerical==1 [pw=1/SPFWT0]
mean computer if clerical==1 [pw=1/SPFWT0]
g lnw=ln(wage)
g exp2=experience^2
g overhigh=highered*overeducated
g oversec=0
replace oversec=1 if overeducated==1&overhigh==0
regress lnw experience exp2 highered uppersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0]



qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.10)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.11)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.12)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.13)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.14)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.15)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.16)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.17)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.18)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.19)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.20)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.21)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.22)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.23)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.24)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.25)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.26)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.27)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.28)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.29)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.30)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.31)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.32)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.33)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.34)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.35)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.36)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.37)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.38)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.39)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.40)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.41)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.42)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.43)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.44)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.45)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.46)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.47)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.48)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.49)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.50)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.51)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.52)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.53)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.54)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.55)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.56)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.57)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.58)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.59)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.60)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.61)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.62)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.63)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.64)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.65)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.66)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.67)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.68)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.69)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.70)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.71)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.72)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.73)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.74)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.75)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.76)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.77)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.78)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.79)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.80)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.81)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.82)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.83)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.84)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.85)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.86)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.87)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.88)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.89)
qreg lnw experience exp2 highered uppersec lowersec overhigh oversec manproftech clerical sales supervise size1150 size51250 size2511000 size1000 [pw=1/SPFWT0], quantile(.90)