** user=**** ** password=**** ** package=stata ** project=les #delimit; * Hungary LES 1993 : Example CAMSIS matching ; use $hu93e; * Current occ unit (isco88's)=fj04; gen isco88=-999; replace isco88=fj04 if (fj04 >= 0 ); * Employment status info from fj02; gen empst=fj02; recode empst 1 2=1 3 5=2 *=0; label define stat 0 "Unknown status" 1 "Self-employed" 2 "Employee" ; label values empst stat; label variable empst "Employment status"; tab empst db02; * Key indexing variables are isco88 and empst; tabulate empst if (fj04 > 0 ), summarize(isco88) mean standard freq ; sort isco88 empst; save cstemp, replace; clear; infile isco88 empst mcam fcam siops isei using $mydata\camsis\cshues93.dat; summarize; sort isco88 empst; merge isco88 empst using cstemp; gen occinfo=_merge; tab occinfo; drop if (occinfo==1); * (this removes those iscobst values which are not represented in the LES sample); tab occinfo db02; * Current values are within gender; * also can make a cross-gender CAMSIS variable : ; gen cgentcs=-999; replace cgentcs=mcam if (db02==1); replace cgentcs=fcam if (db02==2); summarize isco88 empst cgentcs siops isei ; summarize isco88 empst cgentcs siops isei if fj04 > 0; summarize isco88 empst cgentcs siops isei if (fj04 > 0 & siops > 0); * a fair number (approx 10%) of cases have occs but don't * have camsis or isei sucessfully matched due to an isco code * on the les file not being in the camsis index file; **********************************************; * Quick assessment: compare values by an education recode; gen educ=et01; recode educ 1 2=1 3=2 4 5 6 7=3 *=-9; label define edu 1 "Primary or less" 2 "Vocational" 3 "High or Degree level "; label values educ edu; label variable educ "education categories"; tab educ ; sort db02; by db02: summarize educ cgentcs siops isei if fj04 > 0; by db02: oneway cgentcs educ if (fj04 > 0), tabulate; by db02: oneway siops educ if (fj04 > 0 & siops > 0), tabulate; by db02: oneway isei educ if (fj04 > 0 & isei > 0), tabulate; *****************************************;