#delimit;
clear;
set more off;
capture log close;
log using Table2.log, replace;

/*TABLE 2:  SAMPLE MEANS BY INTERNET SEARCH ACTIVITY*/;

use H:\public_html\Data\NetSearch\udur.dta;

gen nomthobs=0;
forval i = 1/10 {;
replace nomthobs=nomthobs+1 if [lf`i'!=. & (badmat==.|badmat>`i')];
};

gen empin1 = [lf1==1] if [lf1!=.&(badmat==.|badmat>1)];
gen empin2 = [lf2==1] if [lf2!=.&(badmat==.|badmat>2)];
gen empin7 = [lf7==1] if [lf7!=.&(badmat==.|badmat>7)];
gen anyemp = [lf1==1|lf2==1|lf3==1|lf4==1|lf5==1|lf6==1|lf7==1|lf8==1|
lf9==1|lf10==1] if [nomthobs>0];

sum dur1 sup00 onlayoff stateur occupur preuwork preuscul 
lostjob tempjob private public selfemp age1625 age2635 
age3645 age4655 male married maridman spem primscul nohiscul 
hiscul nocolege asdegree black hispanic homeownr imigrant 
cofi copu copr cofr cosc sent chec uads otac noofmeth iacc
empin1 empin2 empin7 anyemp if anylook==1;

sum dur1 sup00 onlayoff stateur occupur preuwork preuscul 
lostjob tempjob private public selfemp age1625 age2635 
age3645 age4655 male married maridman spem primscul nohiscul 
hiscul nocolege asdegree black hispanic homeownr imigrant 
cofi copu copr cofr cosc sent chec uads otac noofmeth iacc
empin1 empin2 empin7 anyemp if anylook==0;

sum dur1 sup00 onlayoff stateur occupur preuwork preuscul 
lostjob tempjob private public selfemp age1625 age2635 
age3645 age4655 male married maridman spem primscul nohiscul 
hiscul nocolege asdegree black hispanic homeownr imigrant 
cofi copu copr cofr cosc sent chec uads otac noofmeth iacc
empin1 empin2 empin7 anyemp;


*the bit for the meta people:

*keep only people who were re-interviewed a year later:;
keep if empin7~=.;

tab age0;

sum age0 empin7;
corr age0 empin7;

sum age0 empin7  if age0<=45;
corr age0 empin7 if age0<=45;

sum  age0 empin7 if age0>=46 & age0<=.;
corr age0 empin7 if age0>=46 & age0<=.;