* Comment This syntax (Nov 2010) uses the same algorithm as that for the 1999/2000 and 2004 sweeps to calculate highest academic and vocational qualifications reported at 2008 sweep. * It then merges the highest qualification information from 2008 with highest qual info from the two previous sweeps to create 'highest quals ever up to 2008' variables. * Load data. Obviously the 'd:\' below may need to be changed (e.g. to 'c:\' depending on which drive or folder the bcs70 age 38 (2008) data file is situated on your computer. * get file='d:\bcs_2008_followup.sav'. **BCS AGE 38 - highest qualification variables freq B8AGELE2 B8ACTAL2 B8FURTD2 B8LFTME2 B8ANYQUL . freq B8WHQU01 B8WHQU02 B8WHQU03 B8WHQU04 B8WHQU05 B8WHQU06 B8WHQU07 B8WHQU08 B8WHQU09 B8WHQU10 B8WHQU11 B8WHQU12 B8WHQU13 B8WHQU14 B8WHQU15 B8WHQU16 B8WHQU17 B8WHQU18 B8WHQU19 B8WHQU20 B8WHQU21 B8WHQU22. freq B8NUMGE1 B8NUMGE2 B8NUMAS1 B8NUMAS2 B8NUMGA1 B8NUMGA2. ** cohort members in final dataset have achieved a qualification. **cohort members who report 'dont know or refused' to level of qualification gained are not included with this syntax. freq B8WHQU01 B8WHQU02 B8WHQU03 B8WHQU04 B8WHQU05 B8WHQU06 B8WHQU07 B8WHQU08 B8WHQU09 B8WHQU10 B8WHQU11 B8WHQU12 B8WHQU13 B8WHQU14 B8WHQU15 B8WHQU16 B8WHQU17 B8WHQU18 B8WHQU19 B8WHQU20 B8WHQU21 B8WHQU22. **GCSEs. freq B8WHQU01 B8NUMGE1 B8NUMGE2. compute gcse1 = 0. if (B8WHQU01 = 1 and B8NUMGE1 > 0) gcse1 = 1. compute gcse2 = 0. if (B8WHQU01 = 1 and B8NUMGE2 > 0) gcse2 = 1. variable labels gcse1 "At least one GCSE grade A-C (good o level)". variable labels gcse2 "At least one CSE grade D-E ( bad o level)". freq gcse1 gcse2. **Scottish Qualifications. ** freq b8scoTQ2 b8scoTQ3 b8scoTQ4 B8NUMSFF1TN B8NUMIN1 B8NUMIN2. **AS Levels. freq B8WHQU02 B8NUMAS1 B8NUMAS2. compute as1 = 0. if (B8WHQU02 = 1 and B8NUMAS1 >=1) as1 = 1. compute as2 = 0. if (B8WHQU02 = 1 and B8NUMAS2 >=1) as2 = 1. variable labels as1 "At least one A/S Level Grades A-C". variable labels as2 "At least one A/S Level Grades D-G". freq as1 as2. **A Levels. freq B8NUMGA1 B8NUMGA2. compute al1 = 0. if (B8WHQU03 = 1 and B8NUMGA1 >=1) al1 =1 . compute al2 = 0. if (B8WHQU03 = 1 and B8NUMGA2 >=1) al2 =1 . variable labels al1 "At least one A Level Grades A-C". variable labels al2 "At least one A Level Grades D-G". freq al1 al2. **BTECs. freq B8WHQU12 B8VLV001 B8VLV002 B8VLV003 B8VLV004 B8VLV005 B8VLV006 . compute bteC1 = 0. compute bteC2 = 0. compute bteC3 = 0. compute bteC4 = 0. compute bteC5 = 0. do repeat x = B8VLV001 B8VLV002 B8VLV003 B8VLV004 B8VLV005 B8VLV006 . if (x = 1) bteC1 = 1. if (x = 2) bteC2 = 1. if (x = 3) bteC3 = 1. if (x = 4) bteC4 = 1. if (x = 5) bteC5 = 1. end repeat. freq bteC1 bteC2 bteC3 bteC4 bteC5. ** CITY & GUILDS . freq B8WHQU13 B8VLV016 B8VLV017 B8VLV018 B8VLV019 B8VLV020 B8VLV021 B8VLV022 B8VLV023 B8VLV024 . **city 6 = don't know. compute city1 = 0. compute city2 = 0. compute city3 = 0. compute city4 = 0. compute city5 = 0. compute city6 = 0. do repeat x = B8VLV016 B8VLV017 B8VLV018 B8VLV019 B8VLV020 B8VLV021 B8VLV022 B8VLV023 B8VLV024. if (x = 1) city1 = 1. if (x = 2) city2 = 1. if (x = 3) city3 = 1. if (x = 4) city4 = 1. if (x = 5) city5 = 1. if (x = 6) city6 = 1. end repeat. freq B8VLV016 city1 city2 city3 city4 city5 city6. **RSA awarded . freq B8WHQU14 B8VLV031 B8VLV032 B8VLV033 B8VLV034 B8VLV035 . compute rsA1 = 0. compute rsA2 = 0. compute rsA5 = 0. do repeat x = B8VLV031 B8VLV032 B8VLV033 B8VLV034 B8VLV035 . if (x = 1) rsA1 = 1. if (x = 2) rsA2 = 1. if (x = 5) rsA5 = 1. end repeat. freq rsA1 rsA2 rsA5. *PITMAN awarded . freq B8WHQU15 B8VLV046 B8VLV047. compute pit1 = 0. compute pit4 = 0. do repeat x = B8VLV046 B8VLV047 . if (x = 1) pit1 = 1. if (x = 4) pit4 = 1. end repeat. freq pit1 pit4. *NVQ awarded - . freq B8WHQU16 B8VLV061 B8VLV062 B8VLV063 B8VLV064 B8VLV065 B8VLV066 B8VLV067 B8VLV068 . compute nvq1 = 0. compute nvq2 = 0. compute nvq3 = 0. compute nvq4 = 0. compute nvq5 = 0. compute nvq6 = 0. compute nvq7 = 0. compute nvq8 = 0. do repeat x = B8VLV061 B8VLV062 B8VLV063 B8VLV064 B8VLV065 B8VLV066 B8VLV067 B8VLV068. if (x = 1) nvq1 = 1. if (x = 2) nvq2 = 1. if (x = 3) nvq3 = 1. if (x = 4) nvq4 = 1. if (x = 5) nvq5 = 1. if (x = 6) nvq6 = 1. if (x = 7) nvq7 = 1. if (x = 8) nvq8 = 1. end repeat. freq nvq1 nvq2 nvq3 nvq4 nvq5 nvq6 nvq7 nvq8. * GNVQ awarded. freq B8WHQU17 B8VLV076 B8VLV077. compute gnvq1 = 0. compute gnvq2 = 0. compute gnvq3 = 0. compute gnvq4 = 0. do repeat x = B8VLV076 B8VLV077 B8VLV078 B8VLV079. if (x = 1) gnvq1 = 1. if (x = 2) gnvq2 = 1. if (x = 3) gnvq3 = 1. if (x = 4) gnvq4 = 1. end repeat. freq gnvq1 gnvq2 gnvq3 gnvq4. ** ONC awarded . freq B8WHQU18 B8VLV091 B8VLV092 . compute onC1 = 0. compute onC2 = 0. compute onC3 = 0. do repeat x = B8VLV091 B8VLV092 B8VLV093 B8VLV094 B8VLV095 B8VLV096 B8VLV097 B8VLV098 B8VLV099 B8VLV100 B8VLV101 B8VLV102 B8VLV103 B8VLV104 B8VLV105. if (x = 1) onC1 = 1. if (x = 2) onC2 = 1. if (x = 3) onC3 = 1. end repeat. freq onC1 onC2 onC3. ***************************************. **HNC / HNDs etc. **************************************. freq B8WHQU19 B8VLV106 B8VLV107 B8VLV108. compute hnC1 = 0. compute hnC2 = 0. compute hnC3 = 0. do repeat x = B8VLV106 B8VLV107 B8VLV108. if (x = 1) hnC1 = 1. if (x = 2) hnC2 = 1. if (x = 3) hnC3 = 1. end repeat. freq hnC1 hnC2 hnC3. ********************************************************************************************************************. **Highest academic qualification reported in 2008: coded to match HIACA 00 variable in 2000 survey. ********************************************************************************************************************. freq B8ANYQUL. **reminder that Scottish Standard, Intermediate 1 qualifications are placed as equivalent to GCSEs. **I THINK this is accurate - investigations refer to grades (foundation, etc) of these but we did not collect grades/levels. **in this variable (bD8achq1) Intermediate 2 is coded as equivalent to an AS Level (code 4) but in recoded bD8anvq1 variable. ** (below) both Intermediate 1 and Intermediate 2 are coded as equivalent to NVQ2 (code 2). **I cannot find exact equivalent framework however - but students take Intermediate 2 prior to a Higher - Intermediate 1 is taken after or instead of a. **Standard grade. compute bD8achq1 = -1. if (B8ANYQUL > 0) bD8achq1 = 0. if (gcse2 = 1) bD8achq1 = 1. if (b8scoTQ1 = 1 or b8scoTQ8 = 1) bD8achq1 = 2. if (gcse1 = 1 or b8scoTQ2 = 1 ) bD8achq1 = 3. if (as1 > 0 or al1> 0 or b8scoTQ3 = 1 or b8scoTQ4) bD8achq1 = 4. if (al2 =1 = 1 or b8scoTQ5 = 1 or b8scoTQ6 = 1 or b8scoTQ7 = 1) bD8achq1 = 5. if (B8WHQU05 = 1 or b8whqu11=1) bD8achq1 = 6. if (any(1,B8WHQU06,B8WHQU07,B8WHQU10)) bD8achq1 = 7. if (B8WHQU08 = 1) bD8achq1 = 8. variable labels bD8achq1 "BCS 2008: Highest Academic Qualification CM obtained in 2008 survey". value labels bD8achq1 0 'No academic qualification' 1 'GCSE D-E' 2 'Other Scottish Quals' 3 'GCSE A-C, Scot Standards/Intermediate 1' 4 'Scot Intermediate 2 / AS Levels or 1 A Level' 5 '2+ A Levels, Scot Higher/6th' 6 'Diploma' 7 'Degree, PGCE, Other Degree qual' 8 'Higher Degree' -1 'Level not calculable'. missing values bD8achq1 (-1). freq bD8achq1. ************************************************************************************************************************. **Highest academic qualification reported in 2008: coded to match NVQACA00 variable in 2000 survey. ************************************************************************************************************************. recode bD8achq1 (-1=-1) (0=0) (1=1) (2=1)(3=2)(4=2)(5=3)(6=4)(7=4)(8=5) into bD8anvq1. variable labels bD8anvq1 '(Derived) BCS 2008: Highest NVQ level from an academic qualification in 2008 survey'. value labels bD8anvq1 0'none' 1'nvq1 level' 2'nvq2 level' 3'nvq3 level' 4'nvq4 level' 5'nvq5 level' -1'Not codeable'. missing values bD8anvq1 (-1). freq bD8anvq1. **************************************************************************************. **If CM obtained any vocational qualifications in 2008 since last interview. **************************************************************************************. compute bD8anyvoc = -1. if (B8ANYQUL > 0) bD8anyvoc = 0. if (any(1,B8WHQU09,B8WHQU12,B8WHQU13,B8WHQU14,B8WHQU15,B8WHQU16,B8WHQU17,B8WHQU18,B8WHQU19,B8WHQU20,B8WHQU21,B8WHQU10,B8WHQU11,B8WHQU22)) bD8anyvoc = 1. missing values bD8anyvoc (-1). variable labels bD8anyvoc '(Derived) BCS 2008: CM has obtained a vocational qualification since last interview'. value labels bD8anyvoc -1'not applicable' 0'no vocational qual' 1'yes, has a vocational qual'. freq bD8anyvoc. ********************************************************************************************************************. **Highest vocational qualification reported in 2008: coded to match HIVOC00 variable in 2000 survey. ********************************************************************************************************************. ** cohort members have 'other vocational' quals (B8WHQU22) and we ask about when awarded, full-time or part-time and who paid. ** but not what the qualification was - in the syntax below I have conservatively graded these as nvq level 1. compute bD8vnvq1 = -1. if (bD8anyvoc = 0) bD8vnvq1= 0. if (pit1=1 or rsA1 = 1 or B8WHQU15 = 1 or nvq1 = 1 or nvq7 = 1 or nvq8 = 1 or gnvq1 = 1 or B8WHQU21 = 1 or B8WHQU22 = 1) bD8vnvq1 = 1. if (hnC2=1 or rsA2 = 1 or city1 = 1 or city2 = 1 or city5 = 1 or city6 = 1 or nvq2 =1 or gnvq2 = 1 or bteC1 = 1 or bteC2 = 1 or bteC5 = 1) bD8vnvq1 = 2. if (city3 = 1 or nvq3 = 1 or gnvq3 = 1 or bteC3 = 1 or B8WHQU18 = 1) bD8vnvq1 = 3. if (pit4=1 or city4 = 1 or nvq4 = 1 or gnvq4 = 1 or B8WHQU11 = 1 or bteC4 = 1 or hnC1 = 1 or hnC3 = 1 or B8WHQU09 = 1) bD8vnvq1 = 4. if (nvq6 = 1 or B8WHQU10 = 1) bD8vnvq1 = 5. variable labels bD8vnvq1 '(Derived) BCS 2008: Highest NVQ Level from a Vocational Qualification in 2008 survey'. value labels bD8vnvq1 0'none' 1'nvq1 level' 2'nvq2 level' 3'nvq3 level' 4'nvq4 level' 5'nvq5 level' -1'Not codeable'. missing values bD8vnvq1 (-1). format bD8achq1 bD8anvq1 bD8anyvoc bD8vnvq1 (F4.0). missing values bD8vnvq1 ( ). ** cross tab bD8vnvq1 by B8WHQU09 B8WHQU12 B8WHQU13 B8WHQU14 B8WHQU15 B8WHQU16 B8WHQU17 B8WHQU18 B8WHQU19 B8WHQU20 B8WHQU21 B8WHQU10 B8WHQU11 B8WHQU22. ***********************************************************************************************************************************. **Highest NVQ Level vocational or academic qualification reported in 2008: coded to match HINVQ00 variable in 2000 survey. ***********************************************************************************************************************************. compute bd8nvq1 = bd8vnvq1. if (bd8anvq1 > bd8vnvq1) bd8nvq1 = bd8anvq1. variable labels bd8nvq1 '(Derived) BCS 2008: Highest NVQ Level from an Academic or Vocational Qualification in 2008 survey'. value labels bd8nvq1 0'none' 1'nvq1 level' 2'nvq2 level' 3'nvq3 level' 4'nvq4 level' 5'nvq5 level' -1'Not applicable'. missing values bd8nvq1 (-9 -8 -1). *format bd8achq1 to hnc3 (f2.0). format bd8nvq1 (f2.0). fre bd8nvq1. * At this point we merge the current active file (i.e. main BCS70 2008 dataset) with the dataset 'd:\Highest_quals_BCS2000_BCS2004.sav', which contains the four 'highest qual up to age 30' * variables derived from the 2000 sweep (hiaca00, nvqaca00, hivoc00 and hinvq00) and the four 'highest qual reported at age 34' variables derived from the 2004 sweep: bd7achq1 bd7anvq1 bd7vnvq1 and bd7nvq1. * Obviously you may need to change 'd:\' in the code below to 'c:\' depending on which drive or folder contains the 'Highest_quals_BCS2000_BCS2004.sav' file on your computer. * MATCH FILES . * /FILE=* . * /FILE='d:\Highest_quals_BCS2000_BCS2004.sav'. * /BY bcsid. * EXECUTE. ********************************************************************************************************************. **Highest academic qualification up to 2008: comparing with HIACA00 variable in 2000 survey and bd7achq1 in 2004. ********************************************************************************************************************. missing values hiaca00 bd7achq1 bd8achq1 ( ). compute bd8hachq = (max(hiaca00, bd7achq1, bd8achq1)). variable labels bd8hachq '(Derived) BCS 2008: Highest Academic Qualification - info from 2000, 2004 and 2008 surveys'. value labels bd8hachq 0 'no academic qualification' 1 'GCSE D-E' 2 'CSEs2-5, other Scottish Quals' 3 'GCSE A-C, good O levels Scot Standards' 4 'AS Levels or 1 A Level' 5 '2+ A Levels, Scot HIgher/6th' 6'Diploma' 7'Degree, PGCE, Other Degree Level qual' 8'Higher Degree' -1'Not applicable' -8 'Don''t know'. missing values bd8hachq (-9 -8 -1). format bd8hachq (f2.0). execute. ************************************************************************************************************************************. **Highest academic qualification reported up to 2008 (NVQ Levels): combining nvqaca00, bd7anvq1 and bd8anvq1 variables. **************************************************************************************************************************************. **combining information from 2000, 2004 and 2008 surveys. missing values nvqaca00 bd7anvq1 bd8anvq1 ( ). compute bd8hanvq = (max(nvqaca00, bd7anvq1, bd8anvq1)). variable labels bd8hanvq '(Derived) BCS 2008: Highest NVQ level from an academic qualification - info from 2000, 2004 and 2008 surveys'. value labels bd8hanvq 0'none' 1'nvq1 level' 2'nvq2 level' 3'nvq3 level' 4'nvq4 level' 5'nvq5 level' -1'Not applicable'. missing values bd8hanvq (-9 -8 -1). format bd8hanvq (f2.0). ******************************************************************************************************************************. **Highest vocational qualification reported up to 2008 (NVQ levels): combining hivoc00, bd7vnvq1 and bd8vnvq1 variables. *******************************************************************************************************************************. **combining information from 2000, 2004 and 2008 surveys. missing values hivoc00 bd7vnvq1 bd8vnvq1( ). compute bd8hvnvq = (max(hivoc00, bd7vnvq1, bd8vnvq1)). variable labels bd8hvnvq '(Derived) BCS 2008: Highest NVQ Level from a Vocational Qualification - info from 2000, 2004 and 2008 surveys'. value labels bd8hvnvq 0'none' 1'nvq1 level' 2'nvq2 level' 3'nvq3 level' 4'nvq4 level' 5'nvq5 level' -1'Not applicable'. missing values bd8hvnvq (-9 -8 -1). format bd8hvnvq (f2.0). **************************************************************************************************************************************************. **Highest NVQ level from an Academic or Vocational qualification reported up to 2008: combining hiinvq00, bd7nvq1 and bd8nvq1 variables. **************************************************************************************************************************************************. missing values hinvq00 bd7nvq1 bd8nvq1 ( ). compute bd8hnvq = (max(hinvq00, bd7nvq1, bd8nvq1)). variable labels bd8hnvq '(Derived) BCS 2008: Highest NVQ Level from an Academic or Vocational Qualification - info from 2000, 2004 and 2008 surveys'. value labels bd8hnvq 0'none' 1'nvq1 level' 2'nvq2 level' 3'nvq3 level' 4'nvq4 level' 5'nvq5 level' -1'Not applicable'. missing values bd8hnvq (-9 -8 -1). execute. format bd8hnvq (f2.0). missing values bD8achq1 bD8anvq1 bD8vnvq1 bd8nvq1 (-1). fre bd8achq1 bd8anvq1 bd8anyvoc bd8vnvq1 bd8nvq1 bd8hachq bd8hanvq bd8hvnvq bd8hnvq. * finally, save file of relevant derived education variables from this sweep, the 2000 sweep and the 2004 sweep, to help with future derivations (i.e. incorporating BCS70 2012 data in due course). * save outfile='d:\Highest_quals_BCS2000_BCS2004_BCS2008.sav'/keep=bcsid hiaca00 nvqaca00 hivoc00 hinvq00 bd7achq1 bd7anvq1 bd7vnvq1 bd7nvq1 bd8achq1 bd8anvq1 bd8vnvq1 bd8nvq1 bd8hachq bd8hanvq bd8hvnvq bd8hnvq.