*******************************************************************************
*********************** UK2014 survey file for MTUSX **************************
*******************************************************************************

* country*

gen country= "UK"

* survey*
gen survey= 2014

*swave*
gen swave=0

* msamp*
gen msamp=0

* hldid *
gen hldid=serial

* persid*
gen persid=pnum


* incorig *

gen incorig = Income
recode incorig (-9=-8)

* region *

gen region = dgorpaf

label define region ///
           1 "North East" ///
           2 "North West (incl merseyside)" ///
           3 "Yorkshire & Humberside" ///
           4 "East Midlands" ///
           5 "West Midlands" ///
           6 "East of England" ///
           7 "London" ///
           8 "South East" ///
          10 "South West" ///
          11 "Wales" ///
          12 "Scotland" ///
          13 "Northern Ireland"

label val region region

*empinclm *

gen empinclm = SENetPay
recode empinclm (-9=-8) (-1=-7)

*occupo *

gen occupo=dnssec8
recode occupo (-9=-8) (-1=-7)

label define occupo ///
           1 "1.1 Large employers and higher managerial occupations" ///
           2 "1.2 Higher professional occupations" ///
           3 "2 Lower managerial and professional occupations" ///
           4 "3 Intermediate occupations" ///
           5 "4 Small employers and own account workers" ///
           6 "5 Lower supervisory and technical occupations" ///
           7 "6 Semi-routine occupations" ///
           8 "7 Routine occupations"
label val occupo occupo

* educa * 

gen educa = HiQual
recode HiQual (-1 -2=-7) (-9=-8) (33 34=-8)

label define educa ///
           1 "Degree level qualification incl. foundation degrees, graduat" ///
           2 "Diploma in higher education" ///
           3 "HNC / HND" ///
           4 "ONC / OND" ///
           5 "BTEC/BEC/TEC/EdExcel/LQL" ///
           6 "DSCOTVEC/SCOTEC/SCOTBEC (Scotland)" ///
           7 "Teaching qualification (excluding PGCE)" ///
           8 "Nursing or other medical qualification not yet mentioned" ///
           9 "Other higher education qualification below degree level" ///
          10 " A level/GCE in Applied Subjects or equivalent" ///
          11 "New Diploma" ///
          12 "Welsh Baccalaureate" ///
          13 "International Baccalaureate" ///
          14 "NVQ / SVQ" ///
          15 "GNVQ / GSVQ" ///
          16 "AS level or equivalent" ///
          17 "Certificate of sixth years studies (CSYS) (Scotland)" ///
          18 "Leaving certificate (Republic of Ireland)" ///
          19 "Access to HE" ///
          20 "O level or equivalent" ///
          21 "Standard Grade or Ordinary Grade / Lower (Scotland)" ///
          22 "GCSE/Vocational GCSE" ///
          23 "cse" ///
          24 "Advanced Higher/Higher/Intermediate/Access qualifications (S" ///
          25 "Junior certificate (Republic of Ireland)" ///
          26 "RSA/OCR" ///
          27 "City and Guilds" ///
          28 "YT certificate / YTP" ///
          29 "Key Skills (Eng., W and NI)/Core Skills (Scotland)" ///
          30 "Entry Level Qualifications" ///
          31 "Award, Certificate or Diploma, at entry level and level 1 to" ///
          32 "Any other professional/vocational/foreign qualifications" 
         
label val educa educa

* ethnic *

gen ethnic = -9


* migrantd *

gen migrantd = PlBornC 

label val migrantd PlBornC

* migrantm *

gen migrantm =-9

* migrantf *

gen migrantf=-9



keep country survey swave msamp hldid persid incorig region empinclm occupo ///
educa ethnic migrantd migrantm migrantf
sort country survey swave msamp hldid persid incorig region empinclm occupo ///
educa ethnic migrantd migrantm migrantf