#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;