*/***********************************************************************************/*.
*/  The following syntax is applicable for  1984-6/*.
 	
*/						/*.
*/**********************************************************************************/*.
*******please note that the variable for 1984 is "quala" and for 1985/6 is "qualsm1" *********/*
*********	first to derive the variable 'hedlevel' with 5 categories.

RECODE
  quala
  (14 thru15, -8)=-6) (-9=-9) (1=5)  (2 thru 7=4)  (8thru 10=3)  (11 =2)  (12 thru 13=1) INTO  hedlevel .
VARIABLE LABELS hedlevel 'Education level 5 categories'.
EXECUTE .

VALUE LABELS hedlevel 1 'Level 1' 2 'Level 2'  3 'Level 3'  4 'Level 4'  5 'Level 5' -6 'No qualification'  -9  'Not applicable'. 

***	to check the new variable 'hedlevel' with the original variable "quala".

FREQUENCIES
  VARIABLES=hedlevel quala
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=quala BY hedlevel
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .


*********	second to derive the variable 'degqual' with 3 categories.

RECODE
  quala
  (1 thru 7=1) (8 thru 13=2) (14 thru15, -8=3) (-9=-9)  INTO  degqual .
VARIABLE LABELS degqual 'Whether have degree qualification'.
EXECUTE .

VALUE LABELS  degqual 1 'Degree and above' 2 'Other qualifications'  3 'No qualification'  -9 'Not applicable'. 

***	to check the new variable 'degqual' with the original variable 'quala'.

FREQUENCIES
  VARIABLES=degqual quala
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=quala BY degqual
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .


*/***********************************************************************************/*.
*/  The following syntax is applicable for  1987-8/*.
 	
*/						/*.
*/**********************************************************************************/*.
*******please note that the variable for 1987 is "hiquappj" and for 1088 is "hiquapa" *********/*
*********	first to derive the variable 'hedlevel' with 5 categories.

RECODE
  hiquapa
  (15 thru17=-6) (18=-9) (1=5)  (2 thru 7=4)  (8thru 11=3)  (12 =2)  (13 thru 14=1) INTO  hedlevel .
VARIABLE LABELS hedlevel 'Education level 5 categories'.
EXECUTE .

VALUE LABELS hedlevel 1 'Level 1' 2 'Level 2'  3 'Level 3'  4 'Level 4'  5 'Level 5' -6 'No qualification'  -9  'Not applicable'. 

***	to check the new variable 'hedlevel' with the original variable 'hiquapa'.

FREQUENCIES
  VARIABLES=hedlevel hiquapa
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=hiquapa  BY hedlevel
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .


*********	second to derive the variable 'degqual' with 3 categories.

RECODE
  hiquapa
  (1 thru 7=1) (8 thru 14=2) (15 thru17=3) (18=-9)  INTO  degqual .
VARIABLE LABELS degqual 'Whether have degree qualification'.
EXECUTE .

VALUE LABELS  degqual 1 'Degree and above' 2 'Other qualifications'  3 'No qualification'  -9 'Not applicable'. 

***	to check the new variable 'degqual' with the original variable 'hiquapa' .

FREQUENCIES
  VARIABLES=degqual hiquapa
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=hiquapa BY degqual
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .




*/***********************************************************************************/*.
*/  The following syntax is applicable for  1989-91/*.
 	
*/						/*.
*/**********************************************************************************/*.
*******please note the variable for 1989 is "hiquapb" *********/*
*********	first to derive the variable 'hedlevel' with 5 categories.

RECODE
  hiquap
  (17 thru20, -8=-6) (-9=-9) (1=5)  (2 thru 8=4)  (3 thru 12=3)  (13 =2)  (14 thru 16=1) INTO  hedlevel .
VARIABLE LABELS hedlevel 'Education level 5 categories'.
EXECUTE .

VALUE LABELS hedlevel 1 'Level 1' 2 'Level 2'  3 'Level 3'  4 'Level 4'  5 'Level 5' -6 'No qualification'  -9  'Not applicable'. 

***	to check the new variable 'hedlevel' with the original variable 'hiquap'.

FREQUENCIES
  VARIABLES=hedlevel hiquap
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=hiquap  BY hedlevel
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .


*********	second to derive the variable 'degqual' with 3 categories.

RECODE
  hiquap
  (1 thru 8=1) (9 thru 16=2) (17 thru 20, -8=3) (-9=-9)  INTO  degqual .
VARIABLE LABELS degqual 'Whether have degree qualification'.
EXECUTE .

VALUE LABELS  degqual 1 'Degree and above' 2 'Other qualifications'  3 'No qualification'  -9 'Not applicable'. 

***	to check the new variable 'degqual' with the original variable 'hiquap' .

FREQUENCIES
  VARIABLES=degqual hiquap
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=hiquap BY degqual
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .


*/***********************************************************************************/*.
*/  The following syntax is applicable for  1992/*.
 	
*/						/*.
*/**********************************************************************************/*.

*********	first to derive the variable 'hedlevel' with 5 categories.

RECODE
  hiquap
  (19 thru21, -8=-6) (-9=-9) (1=5)  (2 thru 9=4)  (3 thru 13=3)  (14 =2)  (15 thru 18=1) INTO  hedlevel .
VARIABLE LABELS hedlevel 'Education level 5 categories'.
EXECUTE .

VALUE LABELS hedlevel 1 'Level 1' 2 'Level 2'  3 'Level 3'  4 'Level 4'  5 'Level 5' -6 'No qualification'  -9  'Not applicable'. 

***	to check the new variable 'hedlevel' with the original variable 'hiquap'.

FREQUENCIES
  VARIABLES=hedlevel hiquap
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=hiquap  BY hedlevel
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .


*********	second to derive the variable 'degqual' with 3 categories.

RECODE
  hiquap
  (1 thru 9=1) (10 thru 18=2) (19 thru21, -8=3) (-9=-9)  INTO  degqual .
VARIABLE LABELS degqual 'Whether have degree qualification'.
EXECUTE .

VALUE LABELS  degqual 1 'Degree and above' 2 'Other qualifications'  3 'No qualification'  -9 'Not applicable'. 

***	to check the new variable 'degqual' with the original variable 'hiquap' .

FREQUENCIES
  VARIABLES=degqual hiquap
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=hiquap BY degqual
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .



*/***********************************************************************************/*.
*/  The following syntax is applicable for March-May 1993 --Dec95-Feb 96/*.
 	
*/						/*.
*/**********************************************************************************/*.

*********	first to derive the variable 'hedlevel' with 5 categories.

RECODE
  hiquap
  (32, 33, -8=-6) (-9=-9) (1=5)  (2 thru 12=4)  (13 thru 20=3)  (21 thru 24=2)  (25 thru 31=1) INTO  hedlevel .
VARIABLE LABELS hedlevel 'Education level 5 categories'.
EXECUTE .

VALUE LABELS hedlevel 1 'Level 1' 2 'Level 2'  3 'Level 3'  4 'Level 4'  5 'Level 5' -6 'No qualification'  -9  'Not applicable'. 

***	to check the new variable 'hedlevel' with the original variable 'hiquap'.

FREQUENCIES
  VARIABLES=hedlevel hiquap
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=hiquap  BY hedlevel
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .


*********	second to derive the variable 'degqual' with 3 categories.

RECODE
  hiquap
  (1 thru 12=1) (13 thru 31=2) (32, 33, -8=3) (-9=-9)  INTO  degqual .
VARIABLE LABELS degqual 'Whether have degree qualification'.
EXECUTE .

VALUE LABELS  degqual 1 'Degree and above' 2 'Other qualifications'  3 'No qualification'  -9 'Not applicable'. 

***	to check the new variable 'degqual' with the original variable 'hiquap' .

FREQUENCIES
  VARIABLES=degqual hiquap
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=hiquap BY degqual
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .



*/***********************************************************************************/*.
*/  The following syntax is applicable for March-May 1996-Sept-Nov 2003/*.
 	
*/						/*.
*/**********************************************************************************/*.

*********	first to derive the variable 'hedlevel' with 5 categories.

RECODE
  hiqual
  (40, 41, -8=-6) (-9=-9) (1, 2=5)  (3 thru 14=4)  (15 thru 24=3)  (25 thru 30=2)  (31 thru 39=1) INTO  hedlevel .
VARIABLE LABELS hedlevel 'Education level 5 categories'.
EXECUTE .

VALUE LABELS hedlevel 1 'Level 1' 2 'Level 2'  3 'Level 3'  4 'Level 4'  5 'Level 5' -6 'No qualification'  -9  'Not applicable'. 

***	to check the new variable 'hedlevel' with the original variable 'hiqual'.

FREQUENCIES
  VARIABLES=hedlevel hiqual
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=hiqual  BY hedlevel
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .


*********	second to derive the variable 'degqual' with 3 categories.

RECODE
  hiqual
  (1 thru 14=1) (15 thru 39=2) (40 41 -8=3) (-9=-9)  INTO  degqual .
VARIABLE LABELS degqual 'Whether have degree qualification'.
EXECUTE .

VALUE LABELS  degqual 1 'Degree and above' 2 'Other qualifications'  3 'No qualification'  -9 'Not applicable'. 

***	to check the new variable 'degqual' with the original variable 'hiqual' .

FREQUENCIES
  VARIABLES=degqual hiqual
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=hiqual BY degqual
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .



*/***************************************************************************/*.
*/  The following syntax is applicable between 2004 	/*.
*/								/*.
*/***************************************************************************/*.

*********	first to derive the variable 'hedlevel' with 5 categories.

RECODE
  hiqual4
  (45, 46, -8=-6) (-9=-9) (1, 2=5)  (3 thru 15=4)  (16 thru 26=3)  (27 thru 32=2)  (33 thru 44=1) INTO  hedlevel .
VARIABLE LABELS hedlevel 'Education level 5 categories'.
EXECUTE .

VALUE LABELS hedlevel 1 'Level 1' 2 'Level 2'  3 'Level 3'  4 'Level 4'  5 'Level 5' -6 'No qualification'  -9  'Not applicable'. 

***	to check the new variable 'hedlevel' with the original variable 'hiqual4'.

FREQUENCIES
  VARIABLES=hedlevel hiqual4
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=hiqual4  BY hedlevel
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .


*********	second to derive the variable 'degqual' with 3 categories.

RECODE
  hiqual4
  (1 thru 15=1) (16 thru 44=2) (45 46 -8=3) (-9=-9)  INTO  degqual .
VARIABLE LABELS degqual 'Whether have degree qualification'.
EXECUTE .

VALUE LABELS  degqual 1 'Degree and above' 2 'Other qualifications'  3 'No qualification'  -9 'Not applicable'. 

***	to check the new variable 'degqual' with the original variable 'hiqual4' .

FREQUENCIES
  VARIABLES=degqual hiqual4
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=hiqual4 BY degqual
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .


*/***************************************************************************/*.
*/  The following syntax is applicable between Feb-2005/06 	/*.
*/								/*.
*/***************************************************************************/*.

*********	first to derive the variable 'hedlevel' with 5 categories.

RECODE
  hiqual5
  (48, 49=-6) (-9=-9) (1, 2=5)  (3 thru 15=4)  (16 thru 28=3)  (29 thru 35=2)  (36 thru 47=1) INTO  hedlevel .
VARIABLE LABELS hedlevel 'Education level 5 categories'.
EXECUTE .

VALUE LABELS hedlevel 1 'Level 1' 2 'Level 2'  3 'Level 3'  4 'Level 4'  5 'Level 5' -6 'No qualification'  -9  'Not applicable'. 

***	to check the new variable 'hedlevel' with the original variable 'hiqual5'.

FREQUENCIES
  VARIABLES=hedlevel hiqual5
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=hiqual5  BY hedlevel
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .


*********	second to derive the variable 'degqual' with 3 categories.

RECODE
  hiqual5
  (1 thru 15=1) (16 thru 47=2) (48 49=3) (-9=-9)  INTO  degqual .
VARIABLE LABELS degqual 'Whether have degree qualification'.
EXECUTE .

VALUE LABELS  degqual 1 'Degree and above' 2 'Other qualifications'  3 'No qualification'  -9 'Not applicable'. 

***	to check the new variable 'degqual' with the original variable 'hiqual5' .

FREQUENCIES
  VARIABLES=degqual hiqual5
  /ORDER=  ANALYSIS .

CROSSTABS
  /TABLES=hiqual5 BY degqual
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .