**GHS 2004**
USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  edlev00
  (13=6)  (1=5)  (6=3)  (11=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 10, 12=1)  (-9, -8, -6=SYSMIS) 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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev00
  /ORDER=  ANALYSIS .



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

RECODE
  edlev00
  (13=3) (-9=3) (1 thru 5=1)  (6 thru 12=2) (-8=-9) (-6=-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 'edlev00' .

FREQUENCIES
  VARIABLES=degqual edlev00
  /ORDER=  ANALYSIS .

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

**GHS 2003**
USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  edlev00
  (13=6)  (1=5)  (6=3)  (11=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 10, 12=1)  (-9, -8, -6=SYSMIS) 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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev00
  /ORDER=  ANALYSIS .



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

RECODE
  edlev00
  (13=3) (-9=3) (1 thru 5=1)  (6 thru 12=2) (-8=-9) (-6=-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 'edlev00' .

FREQUENCIES
  VARIABLES=degqual edlev00
  /ORDER=  ANALYSIS .

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


**GHS 2002**
USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  edlev00
  (13=6)  (1=5)  (6=3)  (11=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 10, 12=1)  (-9, -8, -6=SYSMIS) 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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev00
  /ORDER=  ANALYSIS .


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

RECODE
  edlev00
  (13=3) (-9=3) (1 thru 5=1)  (6 thru 12=2) (-8=-9) (-6=-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 'edlev00' .

FREQUENCIES
  VARIABLES=degqual edlev00
  /ORDER=  ANALYSIS .

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

**GHS 2001**
USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  edlev00
  (13=6)  (1=5)  (6=3)  (11=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 10, 12=1)  (-9, -8, -6=SYSMIS) 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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev00
  /ORDER=  ANALYSIS .

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

RECODE
  edlev00
  (13=3) (-9=3) (1 thru 5=1)  (6 thru 12=2) (-8=-9) (-6=-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 'edlev00' .

FREQUENCIES
  VARIABLES=degqual edlev00
  /ORDER=  ANALYSIS .

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


**GHS 2000**
USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  edlev00
  (13=6)  (1=5)  (6=3)  (11=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 10, 12=1)  (-9, -8, -6=SYSMIS) 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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev00
  /ORDER=  ANALYSIS .

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

RECODE
  edlev00
  (13=3) (-9=3) (1 thru 5=1)  (6 thru 12=2) (-8=-9) (-6=-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 'edlev00' .

FREQUENCIES
  VARIABLES=degqual edlev00
  /ORDER=  ANALYSIS .

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

**GHS 1998/9**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  edlev
  (17=6)  (1=5)  (6=3)   (13=2)  (2 thru 5=4)  (7 thru 9=2)  (10 thru 12=1)  (14
  thru 16=1)   (-9, -8=SYSMIS)  (-6=SYSMIS)  (18 thru 19=SYSMIS)  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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .


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

RECODE
  edlev
  (17=3) (-9=3) (1 thru 5=1) (6 thru 16=2) (18 thru 19=-9) (-8=-9) (-6=-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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

**GHS 1996/7**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  edlev
  (17=6)  (1=5)  (7=3)  (13=2)  (2 thru 5=4)  (6, 8 thru 9=2)  (10 thru 12=1)  (14
  thru 16=1)  (18 thru 19=SYSMIS) (-9, -8=SYSMIS) (-6=SYSMIS) 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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .


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

RECODE
  edlev
  (17=3) (-9=3) (1 thru 5=1) (6 thru 16=2) (18 thru 19=-9) (-8=-9) (-6=-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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


**GHS 1995/6**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  edlev
  (17=6)  (1=5)  (7=3)  (13=2)  (2 thru 5=4)  (6, 8 thru 9=2)  (10 thru 12=1)  (14
  thru 16=1)  (18 thru 19=SYSMIS) (-9, -8=SYSMIS) (-6=SYSMIS) 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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .


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

RECODE
  edlev
  (17=3) (-9=3) (1 thru 5=1) (6 thru 16=2) (18 thru 19=-9) (-8=-9) (-6=-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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


**GHS 1994/5**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  edlev
  (17=6)  (1=5)  (7=3)  (13=2)  (2 thru 5=4)  (6, 8 thru 9=2)  (10 thru 12=1)  (14
  thru 16=1)  (18 thru 19=SYSMIS) (-9, -8=SYSMIS) (-6=SYSMIS) 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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .


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

RECODE
  edlev
  (17=3) (-9=3) (1 thru 5=1) (6 thru 16=2) (18 thru 19=-9) (-8=-9) (-6=-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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

**GHS 1993/4**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  edlev
  (17=6)  (1=5)  (7=3)  (13=2)  (2 thru 5=4)  (6, 8 thru 9=2)  (10 thru 12=1)  (14
  thru 16=1)  (18 thru 19=SYSMIS) (-9, -8=SYSMIS) (-6=SYSMIS) 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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .


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

RECODE
  edlev
  (17=3) (-9=3) (1 thru 5=1) (6 thru 16=2) (18 thru 19=-9) (-8=-9) (-6=-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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

**GHS 1992/3**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  edlev
  (17=6)  (1=5)  (7=3)  (13=2)  (2 thru 5=4)  (6, 8 thru 9=2)  (10 thru 12=1)  (14
  thru 16=1)  (18 thru 19=SYSMIS) (-9, -8=SYSMIS) (-6=SYSMIS) 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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .


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

RECODE
  edlev
  (17=3) (-9=3) (1 thru 5=1) (6 thru 16=2) (18 thru 19=-9) (-8=-9) (-6=-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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

**GHS 1991/2**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  edlev
  (17=6)  (1=5)  (7=3)  (13=2)  (2 thru 5=4)  (6, 8 thru 9=2)  (10 thru 12=1)  (14
  thru 16=1)  (18 thru 19=SYSMIS) (-9, -8=SYSMIS) (-6=SYSMIS) 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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .


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

RECODE
  edlev
  (17=3) (-9=3) (1 thru 5=1) (6 thru 16=2) (18 thru 19=-9) (-8=-9) (-6=-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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


**GHS 1990/1**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  edlev
  (17=6)  (1=5)  (7=3)  (13=2)  (2 thru 5=4)  (6, 8 thru 9=2)  (10 thru 12=1)  (14
  thru 16=1)  (18 thru 19=SYSMIS) (-9, -8=SYSMIS) (-6=SYSMIS) 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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .


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

RECODE
  edlev
  (17=3) (-9=3) (1 thru 5=1) (6 thru 16=2) (18 thru 19=-9) (-8=-9) (-6=-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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


**GHS 1989/90**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  edlev
  (17=6)  (1=5)  (7=3)  (13=2)  (2 thru 5=4)  (6, 8 thru 9=2)  (10 thru 12=1)  (14
  thru 16=1)  (18 thru 19=SYSMIS) (-9, -8=SYSMIS) (-6=SYSMIS) 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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .


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

RECODE
  edlev
  (17=3) (-9=3) (1 thru 5=1) (6 thru 16=2) (18 thru 19=-9) (-8=-9) (-6=-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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


**GHS 1988/9**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  edlev
  (17=6)  (1=5)  (7=3)  (13=2)  (2 thru 5=4)  (6, 8 thru 9=2)  (10 thru 12=1)  (14
  thru 16=1)  (18 thru 19=SYSMIS) (-9, -8=SYSMIS) (-6=SYSMIS) 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'. 


FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .


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

RECODE
  edlev
  (17=3) (-9=3) (1 thru 5=1) (6 thru 16=2) (18 thru 19=-9) (-8=-9) (-6=-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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

**GHS 1987**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  edlev
  (17=6)  (1=5)  (7=3)   (13=2)  (2 thru 5=4)  (6 thru 9=2)  (10 thru 12=1)  (14
  thru 16=1)  (18 thru 20=SYSMIS) (-9, -8, -6=SYSMIS) 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'. 

FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .


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

RECODE
  edlev
  (17=3) (20=3) (1 thru 5=1) (6 thru 16=2) (18 thru 19=-9) (-9, -8, -6=-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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


**GHS 1986**
USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  edlev
  (16=6)  (1=5)  (6=3)  (13=2)  (2 thru 5=4)  (7 thru 9=2)  (10 thru 12=1)  (14
  thru 15=1) (17 thru 20=SYSMIS) (-9=SYSMIS) 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'. 

FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .



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

RECODE
  edlev  
  (16=3) (20=3) (1 thru 5=1)  (6 thru 15=2) (17 thru 19=-9) (-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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

**GHS 1985**
USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  edlev
  (16=6)  (1=5)  (6=3)  (13=2)  (2 thru 5=4)  (7 thru 9=2)  (10 thru 12=1)  (14
  thru 15=1) (17 thru 20=SYSMIS) (-9=SYSMIS) 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'. 

FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .




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

RECODE
  edlev  
  (16=3) (20=3) (1 thru 5=1)  (6 thru 15=2) (17 thru 19=-9) (-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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

**GHS 1984**
USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  edlev
  (16=6)  (1=5)  (6=3)  (13=2)  (2 thru 5=4)  (7 thru 9=2)  (10 thru 12=1)  (14
  thru 15=1) (17 thru 20=SYSMIS) (-9=SYSMIS) 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'. 

FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .


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

RECODE
  edlev  
  (16=3) (20=3) (1 thru 5=1)  (6 thru 15=2) (17 thru 19=-9) (-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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


**GHS 1983**
USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  edlev
  (16=6)  (1=5)  (6=3)  (13=2)  (2 thru 5=4)  (7 thru 9=2)  (10 thru 12=1)  (14
  thru 15=1) (17 thru 20=SYSMIS) (-9=SYSMIS) 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'. 

FREQUENCIES
  VARIABLES=hedlevel edlev
  /ORDER=  ANALYSIS .



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

RECODE
  edlev  
  (16=3) (20=3) (1 thru 5=1)  (6 thru 15=2) (17 thru 19=-9) (-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 'edlev' .

FREQUENCIES
  VARIABLES=degqual edlev
  /ORDER=  ANALYSIS .

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

**GHS 1982**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  hedqual
  (15=6)  (1=5)  (6=3)  (12=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 11=1)  (13
  thru 14=1)  (16 thru 99=SYSMIS) (-1, -9=SYSMIS) 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'. 

FREQUENCIES
  VARIABLES=hedlevel hedqual
  /ORDER=  ANALYSIS .


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

RECODE
  hedqual 
  (15=3)  (1 thru 5=1)  (6 thru 14=2) (16 thru 99=-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 'hedqual' .

FREQUENCIES
  VARIABLES=degqual hedqual
  /ORDER=  ANALYSIS .

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



**GHS 1981**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  hedqual
  (15=6)  (1=5)  (6=3)  (12=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 11=1)  (13
  thru 14=1)  (16 thru 99=SYSMIS) (-1, -9=SYSMIS) 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'. 

FREQUENCIES
  VARIABLES=hedlevel hedqual
  /ORDER=  ANALYSIS .



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

RECODE
  hedqual 
  (15=3)  (1 thru 5=1)  (6 thru 14=2) (16 thru 99=-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 'hedqual' .

FREQUENCIES
  VARIABLES=degqual hedqual
  /ORDER=  ANALYSIS .

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

**GHS 1980**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  hedqual
  (15=6)  (1=5)  (6=3)  (12=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 11=1)  (13
  thru 14=1)  (16 thru 99=SYSMIS) (-1, -9=SYSMIS) 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'. 

FREQUENCIES
  VARIABLES=hedlevel hedqual
  /ORDER=  ANALYSIS .

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

RECODE
  hedqual 
  (15=3)  (1 thru 5=1)  (6 thru 14=2) (16 thru 99=-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 'hedqual' .

FREQUENCIES
  VARIABLES=degqual hedqual
  /ORDER=  ANALYSIS .

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


**GHS 1979**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  hedqual
  (15=6)  (1=5)  (6=3)  (12=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 11=1)  (13
  thru 14=1)  (16 thru 99=SYSMIS) (-1, -9=SYSMIS) 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'. 

FREQUENCIES
  VARIABLES=hedlevel hedqual
  /ORDER=  ANALYSIS .


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

RECODE
  hedqual 
  (15=3)  (1 thru 5=1)  (6 thru 14=2) (16 thru 99=-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 'hedqual' .

FREQUENCIES
  VARIABLES=degqual hedqual
  /ORDER=  ANALYSIS .

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


**GHS 1978**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  hedqual
  (15=6)  (1=5)  (6=3)  (12=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 11=1)  (13
  thru 14=1)  (16 thru 99=SYSMIS) (-1, -9=SYSMIS) 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'. 

FREQUENCIES
  VARIABLES=hedlevel hedqual
  /ORDER=  ANALYSIS .


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

RECODE
  hedqual 
  (15=3)  (1 thru 5=1)  (6 thru 14=2) (16 thru 99=-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 'hedqual' .

FREQUENCIES
  VARIABLES=degqual hedqual
  /ORDER=  ANALYSIS .

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



**GHS 1977**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

RECODE
  hedqual
  (15=6)  (1=5)  (6=3)  (12=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 11=1)  (13
  thru 14=1)  (16 thru 99=SYSMIS) (-1, -9=SYSMIS) 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'. 

FREQUENCIES
  VARIABLES=hedlevel hedqual
  /ORDER=  ANALYSIS .

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

RECODE
  hedqual 
  (15=3)  (1 thru 5=1)  (6 thru 14=2) (16 thru 99=-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 'hedqual' .

FREQUENCIES
  VARIABLES=degqual hedqual
  /ORDER=  ANALYSIS .

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


**GHS 1976**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  hedqual
  (0=6)  (1=5)  (6=3)  (12=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 11=1)  (13
  thru 14=1)  (16 thru 99=SYSMIS)  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'. 

FREQUENCIES
  VARIABLES=hedlevel hedqual
  /ORDER=  ANALYSIS .


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

RECODE
  hedqual 
  (0=3)  (1 thru 5=1)  (6 thru 14=2)  (16 thru 99=-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 'hedqual' .

FREQUENCIES
  VARIABLES=degqual hedqual
  /ORDER=  ANALYSIS .

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


**GHS 1975**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  hedqual
  (0=6)  (1=5)  (6=3)  (12=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 11=1)  (13
  thru 14=1)  (16 thru 99=SYSMIS)  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'. 

FREQUENCIES
  VARIABLES=hedlevel hedqual
  /ORDER=  ANALYSIS .


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

RECODE
  hedqual 
  (0=3)  (1 thru 5=1)  (6 thru 14=2)  (16 thru 99=-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 'hedqual' .

FREQUENCIES
  VARIABLES=degqual hedqual
  /ORDER=  ANALYSIS .

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



**GHS 1974**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  hedqual
  (0=6)  (1=5)  (6=3)  (12=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 11=1)  (13
  thru 14=1)  (16 thru 99=SYSMIS)  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'. 

FREQUENCIES
  VARIABLES=hedlevel hedqual
  /ORDER=  ANALYSIS .


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

RECODE
  hedqual 
  (0=3)  (1 thru 5=1)  (6 thru 14=2)  (16 thru 99=-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 'hedqual' .

FREQUENCIES
  VARIABLES=degqual hedqual
  /ORDER=  ANALYSIS .

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


**GHS 1973**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  hedqual
  (0=6)  (1=5)  (6=3)  (12=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 11=1)  (13
  thru 14=1)  (16 thru 99=SYSMIS)  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'. 

FREQUENCIES
  VARIABLES=hedlevel hedqual
  /ORDER=  ANALYSIS .


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

RECODE
  hedqual 
  (0=3)  (1 thru 5=1)  (6 thru 14=2)  (16 thru 99=-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 'hedqual' .

FREQUENCIES
  VARIABLES=degqual hedqual
  /ORDER=  ANALYSIS .

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


**GHS 1972**

USE ALL.
COMPUTE filter_$=(age >= 16 & age <= 74).
VARIABLE LABEL filter_$ 'age >= 16 & age <= 74 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .


RECODE
  hedqual
  (0=6)  (1=5)  (6=3)  (12=2)  (2 thru 5=4)  (7 thru 8=2)  (9 thru 11=1)  (13
  thru 14=1)  (16 thru 99=SYSMIS)  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'. 

FREQUENCIES
  VARIABLES=hedlevel hedqual
  /ORDER=  ANALYSIS .


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

RECODE
  hedqual 
  (0=3)  (1 thru 5=1)  (6 thru 14=2)  (16 thru 99=-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 'hedqual' .

FREQUENCIES
  VARIABLES=degqual hedqual
  /ORDER=  ANALYSIS .

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