gen educa=200 recode educa 200=0 if v0602 == 2 & v6003 == 1 & v6030==3 & v0605 == 1 recode educa 200=0 if v0602 == 2 & v6003 == 1 & v6030==3 & v0605 == 2 recode educa 200=1 if v0602 == 2 & v6003 == 1 & v6030==3 & v0605 == 3 recode educa 200=2 if v0602 == 2 & v6003 == 1 & v6030==3 & v0605 == 4 recode educa 200=3 if v0602 == 2 & v6003 == 1 & v6030==3 & v0605 == 5 recode educa 200=4 if v0602 == 2 & v6003 == 1 & v6030==3 & v0605 == 6 recode educa 200=5 if v0602 == 2 & v6003 == 1 & v6030==3 & v0605 == 7 recode educa 200=6 if v0602 == 2 & v6003 == 1 & v6030==3 & v0605 == 8 recode educa 200=7 if v0602 == 2 & v6003 == 1 & v6030==3 & v0605 == 0 recode educa 200=0 if v0602 == 2 & v6003 == 1 & v6030==1 & v0605 == 1 recode educa 200=1 if v0602 == 2 & v6003 == 1 & v6030==1 & v0605 == 2 recode educa 200=2 if v0602 == 2 & v6003 == 1 & v6030==1 & v0605 == 3 recode educa 200=3 if v0602 == 2 & v6003 == 1 & v6030==1 & v0605 == 4 recode educa 200=4 if v0602 == 2 & v6003 == 1 & v6030==1 & v0605 == 5 recode educa 200=5 if v0602 == 2 & v6003 == 1 & v6030==1 & v0605 == 6 recode educa 200=6 if v0602 == 2 & v6003 == 1 & v6030==1 & v0605 == 7 recode educa 200=7 if v0602 == 2 & v6003 == 1 & v6030==1 & v0605 == 8 recode educa 200=8 if v0602 == 2 & v6003 ==2 & v0605 == 1 recode educa 200=9 if v0602 == 2 & v6003 == 2 & v0605 == 2 recode educa 200=10 if v0602 == 2 & v6003 == 2 & v0605 == 3 recode educa 200=10 if v0602 == 2 & v6003 ==2 & v0605 == 4 recode educa 200=0 if v0602 == 2 & v6003 == 3 & v0604== 2 & v0605== 1 recode educa 200=1 if v0602 == 2 & v6003 == 3 & v0604== 2 & v0605== 2 recode educa 200=2 if v0602 == 2 & v6003 == 3 & v0604== 2 & v0605== 3 recode educa 200=3 if v0602 == 2 & v6003 == 3 & v0604== 2 & v0605== 4 recode educa 200=4 if v0602 == 2 & v6003 == 3 & v0604== 2 & v0605== 5 recode educa 200=5 if v0602 == 2 & v6003 == 3 & v0604== 2 & v0605== 6 recode educa 200=6 if v0602 == 2 & v6003 == 3 & v0604== 2 & v0605== 7 recode educa 200=7 if v0602 == 2 & v6003 == 3 & v0604== 2 & v0605== 8 recode educa 200=4 if v0602 == 2 & v6003 == 3 & v0604== 4 recode educa 200=8 if v0602 == 2 & v6003 == 4 & v0604== 2 & v0605== 1 recode educa 200=9 if v0602 == 2 & v6003 == 4 & v0604== 2 & v0605== 2 recode educa 200=10 if v0602 == 2 & v6003 == 4 & v0604== 2 & v0605== 3 recode educa 200=8 if v0602 == 2 & v6003 == 4 & v0604== 4 recode educa 200=11 if v0602 == 2 & v6003 == 5 & v0605== 1 recode educa 200=12 if v0602 == 2 & v6003 == 5 & v0605== 2 recode educa 200=13 if v0602 == 2 & v6003 == 5 & v0605== 3 recode educa 200=14 if v0602 == 2 & v6003 == 5 & v0605== 4 recode educa 200=15 if v0602 == 2 & v6003 == 5 & v0605== 5 recode educa 200=16 if v0602 == 2 & v6003 == 5 & v0605== 6 recode educa 200=0 if v0602 == 2 & v6003 ==6 recode educa 200=0 if v0602 == 2 & v6003 == 7 recode educa 200=0 if v0602 == 2 & v6003 == 8 recode educa 200=0 if v0602 == 2 & v6003 == 9 recode educa 200=11 if v0602 == 2 & v6003 == 10 recode educa 200=17 if v0602 == 2 & v6003 == 11 recode educa 200=1 if v0602 ==4 & v0606 == 2 & v6007 == 1 & v0609 == 1 & v0610 == 1 recode educa 200=2 if v0602 ==4 & v0606 == 2 & v6007 == 1 & v0609 == 1 & v0610 == 2 recode educa 200=3 if v0602 ==4 & v0606 == 2 & v6007 == 1 & v0609 == 1 & v0610 == 3 recode educa 200=4 if v0602 ==4 & v0606 == 2 & v6007 == 1 & v0609 == 1 & v0610 == 4 recode educa 200=4 if v0602 ==4 & v0606 == 2 & v6007 == 1 & v0609 == 1 & v0610 == 5 recode educa 200=4 if v0602 ==4 & v0606 == 2 & v6007 == 1 & v0609 == 1 & v0610 == 6 recode educa 200=0 if v0602 ==4 & v0606 == 2 & v6007 == 1 & v0609 ==3 recode educa 200=5 if v0602 ==4 & v0606 == 2 & v6007 ==2 & v0608 ==2 & v0609 == 1 & v0610==1 recode educa 200=6 if v0602 ==4 & v0606 == 2 & v6007 ==2 & v0608 ==2 & v0609 == 1 & v0610 == 2 recode educa 200=7 if v0602 ==4 & v0606 == 2 & v6007 ==2 & v0608 ==2 & v0609 == 1 & v0610 == 3 recode educa 200=8 if v0602 ==4 & v0606 == 2 & v6007 ==2 & v0608 ==2 & v0609 == 1 & v0610 == 4 recode educa 200=8 if v0602 ==4 & v0606 == 2 & v6007 ==2 & v0608 ==2 & v0609 == 1 & v0610 ==5 recode educa 200=4 if v0602 ==4 & v0606 == 2 & v6007 ==2 & v0608 ==2 & v0609 == 3 recode educa 200=8 if v0602 ==4 & v0606 == 2 & v6007 ==2 & v0608 ==4 & v0611 == 1 recode educa 200=4 if v0602 ==4 & v0606 == 2 & v6007 ==2 & v0608 ==4 & v0611 == 3 recode educa 200=9 if v0602 ==4 & v0606 == 2 & v6007 ==3 & v0608 ==2 & v0609 == 1 & v0610 == 1 recode educa 200=10 if v0602 ==4 & v0606 == 2 & v6007 ==3 & v0608 ==2 & v0609 == 1 & v0610 ==2 recode educa 200=11 if v0602 ==4 & v0606 == 2 & v6007 ==3 & v0608 ==2 & v0609 == 1 & v0610 == 3 recode educa 200=11 if v0602 ==4 & v0606 == 2 & v6007 ==3 & v0608 ==2 & v0609 == 1 & v0610 == 4 recode educa 200=11 if v0602 ==4 & v0606 == 2 & v6007 ==3 & v0608 ==2 & v0609 == 1 & v0610 == 5 recode educa 200=8 if v0602 ==4 & v0606 == 2 & v6007 ==3 & v0608 ==2 & v0609 == 3 recode educa 200=11 if v0602 ==4 & v0606 == 2 & v6007 ==3 & v0608 ==4 & v0611 == 1 recode educa 200=8 if v0602 ==4 & v0606 == 2 & v6007 ==3 & v0608 ==2 & v0611 == 3 recode educa 200=1 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==1 & v0610 == 1 recode educa 200=2 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==1 & v0610 == 2 recode educa 200=3 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==1 & v0610 == 3 recode educa 200=4 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==1 & v0610 == 4 recode educa 200=5 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==1 & v0610 == 5 recode educa 200=6 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==1 & v0610 == 6 recode educa 200=7 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==1 & v0610 == 7 recode educa 200=8 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==1 & v0610 == 8 recode educa 200=0 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==3 & v0610 == 1 recode educa 200=1 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==3 & v0610 == 2 recode educa 200=2 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==3 & v0610 == 3 recode educa 200=3 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==3 & v0610 == 4 recode educa 200=4 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==3 & v0610 == 5 recode educa 200=5 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==3 & v0610 == 6 recode educa 200=6 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==3 & v0610 == 7 recode educa 200=7 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==3 & v0610 == 8 recode educa 200=8 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 1 & v6070==3 & v0610 == 0 recode educa 200=0 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==2 & v0609 == 3 recode educa 200=8 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==4 & v0611 == 1 recode educa 200=4 if v0602 ==4 & v0606 == 2 & v6007 ==4 & v0608 ==4 & v0611 ==3 recode educa 200=9 if v0602 ==4 & v0606 == 2 & v6007 ==5 & v0608 ==2 & v0609 == 1 & v0610 == 1 recode educa 200=10 if v0602 ==4 & v0606 == 2 & v6007 ==5 & v0608 ==2 & v0609 == 1 & v0610 == 2 recode educa 200=11 if v0602 ==4 & v0606 == 2 & v6007 ==5 & v0608 ==2 & v0609 == 1 & v0610 == 3 recode educa 200=11 if v0602 ==4 & v0606 == 2 & v6007 ==5 & v0608 ==2 & v0609 == 1 & v0610 == 4 recode educa 200=11 if v0602 ==4 & v0606 == 2 & v6007 ==5 & v0608 ==2 & v0609 == 1 & v0610 == 5 recode educa 200=8 if v0602 ==4 & v0606 == 2 & v6007 ==5 & v0608 ==2 & v0609 == 3 recode educa 200=11 if v0602 ==4 & v0606 == 2 & v6007 ==5 & v0608 ==4 & v0611 == 1 recode educa 200=8 if v0602 ==4 & v0606 == 2 & v6007 ==5 & v0608 ==4 & v0611 == 3 recode educa 200=1 if v0602 ==4 & v0606 == 2 & v6007 ==6 & v0609 == 1 & v0610 == 1 recode educa 200=2 if v0602 ==4 & v0606 == 2 & v6007 ==6 & v0609 == 1 & v0610 == 2 recode educa 200=3 if v0602 ==4 & v0606 == 2 & v6007 ==6 & v0609 == 1 & v0610 == 3 recode educa 200=4 if v0602 ==4 & v0606 == 2 & v6007 ==6 & v0609 == 1 & v0610 == 4 recode educa 200=5 if v0602 ==4 & v0606 == 2 & v6007 ==6 & v0609 == 1 & v0610 == 5 recode educa 200=6 if v0602 ==4 & v0606 == 2 & v6007 ==6 & v0609 == 1 & v0610 == 6 recode educa 200=7 if v0602 ==4 & v0606 == 2 & v6007 ==6 & v0609 == 1 & v0610 == 7 recode educa 200=8 if v0602 ==4 & v0606 == 2 & v6007 ==6 & v0609 == 1 & v0610 == 8 recode educa 200=8 if v0602 ==4 & v0606 == 2 & v6007 ==6 & v0609 == 1 & v0610 == 0 recode educa 200=9 if v0602 ==4 & v0606 == 2 & v6007 ==7 & v0608 ==2 & v0609 == 1 & v0610 == 1 recode educa 200=10 if v0602 ==4 & v0606 == 2 & v6007 ==7 & v0608 ==2 & v0609 == 1 & v0610 == 2 recode educa 200=11 if v0602 ==4 & v0606 == 2 & v6007 ==7 & v0608 ==2 & v0609 == 1 & v0610 == 3 recode educa 200=11 if v0602 ==4 & v0606 == 2 & v6007 ==7 & v0608 ==2 & v0609 == 1 & v0610 == 4 recode educa 200=11 if v0602 ==4 & v0606 == 2 & v6007 ==7 & v0608 ==2 & v0609 == 1 & v0610 == 5 recode educa 200=8 if v0602 ==4 & v0606 == 2 & v6007 ==7 & v0608 ==2 & v0609 == 3 recode educa 200=8 if v0602 == 4 & v0606 == 2 & v6007 == 7 & v0608== 4 & v0611== 3 recode educa 200=11 if v0602 == 4 & v0606 == 2 & v6007 == 7 & v0608== 4 & v0611== 1 recode educa 200=12 if v0602 ==4 & v0606 == 2 & v6007 ==8 & v0609 == 1 & v0610 == 1 recode educa 200=13 if v0602 ==4 & v0606 == 2 & v6007 ==8 & v0609 == 1 & v0610 == 2 recode educa 200=14 if v0602 ==4 & v0606 == 2 & v6007 ==8 & v0609 == 1 & v0610 == 3 recode educa 200=15 if v0602 ==4 & v0606 == 2 & v6007 ==8 & v0609 == 1 & v0610 == 4 recode educa 200=16 if v0602 ==4 & v0606 == 2 & v6007 ==8 & v0609 == 1 & v0610 == 5 recode educa 200=17 if v0602 ==4 & v0606 == 2 & v6007 ==8 & v0609 == 1 & v0610 == 6 recode educa 200=11 if v0602 ==4 & v0606 == 2 & v6007 ==8 & v0609 == 3 recode educa 200=18 if v0602 ==4 & v0606 == 2 & v6007 ==9 & v0611 == 1 recode educa 200=16 if v0602 ==4 & v0606 == 2 & v6007 ==9 & v0611 == 3 recode educa 200=1 if v0602 ==4 & v0606 == 2 & v6007 ==10 & v0611 == 1 recode educa 200=0 if v0602 ==4 & v0606 == 2 & v6007 ==10 & v0611 == 3 recode educa 200=0 if v0602 ==4 & v0606 == 2 & v6007 == 11 recode educa 200=0 if v0602 ==4 & v0606 == 2 & v6007 == 12 recode educa 200=0 if v0602 ==4 & v0606 == 2 & v6007 == 13 recode educa 200=0 if v0602 ==4 & v0606 == 4 recode educa 200 = . gen educa2= v4803-1 replace educa2=. if educa2==16 replace educa=educa2 if educa==.