******************************************************************.
*First I need to prepare the variables I need for identifying third-agers.
*That would be information on gender, country, age, care-responsibilities, health status, employment status.
******************************************************************.
*A variable describing whether the repondent's children are minors.
*Persons reach the age of majority when they turn 18 in all countries in this sample.
*That means that persons born in 1990 reach the age of majority in the year where the data was collected.
compute minor=0.
execute.
var lab minor 'kids are minors'.
val lab minor 0 'no'
1 'yes'
99 'no valid answer'.
do if rshipa2=2 and yrbrn2<6666 and yrbrn2>1991.
compute minor=1.
else if rshipa3=2 and yrbrn3<6666 and yrbrn3>1991.
compute minor=1.
else if rshipa4=2 and yrbrn4<6666 and yrbrn4>1991.
compute minor=1.
else if rshipa5=2 and yrbrn5<6666 and yrbrn5>1991.
compute minor=1.
else if rshipa6=2 and yrbrn6<6666 and yrbrn6>1991.
compute minor=1.
else if rshipa7=2 and yrbrn7<6666 and yrbrn7>1991.
compute minor=1.
else if rshipa8=2 and yrbrn8<6666 and yrbrn8>1991.
compute minor=1.
else if rshipa9=2 and yrbrn9<6666 and yrbrn9>1991.
compute minor=1.
else if rshipa10=2 and yrbrn10<6666 and yrbrn10>1991.
compute minor=1.
else if rshipa11=2 and yrbrn11<6666 and yrbrn11>1991.
compute minor=1.
else if rshipa12=2 and yrbrn12<6666 and yrbrn12>1991.
compute minor=1.
else if rshipa13=2 and yrbrn13<6666 and yrbrn13>1991.
compute minor=1.
else if rshipa14=2 and yrbrn14<6666 and yrbrn14>1991.
compute minor=1.
else if rshipa15=2 and yrbrn15<6666 and yrbrn15>1991.
compute minor=1.
else if rshipa16=2 and yrbrn16<6666 and yrbrn16>1991.
compute minor=1.
end if.
execute.
freq minor.
RECODE rshipa2 rshipa3 rshipa4 rshipa5 rshipa6 rshipa7 rshipa8 rshipa9 rshipa10 rshipa11 rshipa12 rshipa13 rshipa14 rshipa15 rshipa16 (70 thru Highest=99) INTO minor minor minor minor minor minor minor minor minor minor minor minor minor minor minor.
EXECUTE.
freq minor.
do if rshipa2=2 and yrbrn2>7000.
compute minor=99.
else if rshipa3=2 and yrbrn3>7000.
compute minor=99.
else if rshipa4=2 and yrbrn4>7000.
compute minor=99.
else if rshipa5=2 and yrbrn5>7000.
compute minor=99.
else if rshipa6=2 and yrbrn6>7000.
compute minor=99.
else if rshipa7=2 and yrbrn7>7000.
compute minor=99.
else if rshipa8=2 and yrbrn8>7000.
compute minor=99.
else if rshipa9=2 and yrbrn9>7000.
compute minor=99.
else if rshipa10=2 and yrbrn10>7000.
compute minor=99.
else if rshipa11=2 and yrbrn11>7000.
compute minor=99.
else if rshipa12=2 and yrbrn12>7000.
compute minor=99.
else if rshipa13=2 and yrbrn13>7000.
compute minor=99.
else if rshipa14=2 and yrbrn14>7000.
compute minor=99.
else if rshipa15=2 and yrbrn15>7000.
compute minor=99.
else if rshipa16=2 and yrbrn16>7000.
compute minor=99.
end if.
execute.
freq minor.
*Employment status.
*The problem here is that persons were allowed to give multipe answers to this question.
*So I need to create a new variable, that names the main employment status, if multiple answers were given.
*If only once answer was given, then this answer is kept.
do if pdwrk=1.
compute empl=2.
else if rtrd=1.
compute empl=1.
else if uempla=1.
compute empl=3.
else if uempli=1.
compute empl=3.
else if edctn=1.
compute empl=4.
else if cmsrv=1.
compute empl=5.
else if hswrk=1.
compute empl=6.
else if dsbld=1.
compute empl=7.
else if dngoth=1.
compute empl=8.
end if.
execute.
freq empl.
recode mainact (1=2) (2=4) (3=3) (4=3) (5=7) (6=1) (7=5) (8=6) (9=8) into empl.
execute.
var lab empl 'employment status'.
val lab empl 1 'retired'
2 'paid work'
3 'unemployed'
4 'education'
5 'community or military service'
6 'housework'
7 'permanently sick or disabled'
8 'other'.
freq empl.
******************************************************************.
*Now I can construct a variable identifying third ager.
******************************************************************.
compute third=99.
execute.
var lab third 'person is third ager'.
val lab third 0 'no'
1 'yes'
99 'no valid answer'.
freq third.
recode empl (2=0) (3=0) (4=0) (5=0) (7=0) (1=1) into third.
execute.
freq third.
*With home-maker, one needs to have a look at age (do determine whether they can be considered quasi-retirees) and health status.
*To decide about the cut-off age for homemakers, I will use the mandatory retirement age in a country.
*Where no mandatory retirement age exists, I will use the normal retirement age in a country.
***************************************.
*Information on the mandatory and the normal retirement age in a country was obtained from several sources.
*The sources are.
*Organisation for Economic Cooperation and Development, 2009, Pensions at a glance 2009, Paris, OECD Publishing.
*European Commission, 2007, MISSOC Tables 2007, Luxembourg, Office for Official Publications of the European Communities.
*International Social Security Association, Country profiles.
***************************************.
do if (cntry='CY' or cntry='CZ' or cntry='DK' or cntry='FI' or cntry='GR' or cntry='NL' or cntry='PT' or cntry='ES' or cntry='SE') and empl=6 and agea<65.
compute third=0.
else if (cntry='CY' or cntry='CZ' or cntry='DK' or cntry='FI' or cntry='GR' or cntry='NL' or cntry='PT' or cntry='ES' or cntry='SE') and empl=6 and agea>64.
compute third=1.
end if.
execute.
freq third.
do if (cntry='DE' or cntry='NO') and empl=6 and agea<67.
compute third=0.
else if (cntry='DE' or cntry='NO') and empl=6 and agea>66.
compute third=1.
end if.
execute.
freq third.
do if cntry='HU' and empl=6 and agea<62.
compute third=0.
else if cntry='HU' and empl=6 and agea>61.
compute third=1.
end if.
execute.
freq third.
do if cntry='LA' and empl=6 and agea<64.
compute third=0.
else if cntry='LA' and empl=6 and agea>63.
compute third=1.
end if.
execute.
freq third.
do if (cntry='BE' or cntry='PL' or cntry='CH' or cntry='GB') and empl=6 and gndr=1 and agea<65.
compute third=0.
else if (cntry='BE' or cntry='PL' or cntry='CH' or cntry='GB') and empl=6 and gndr=1 and agea>64.
compute third=1.
end if.
execute.
freq third.
do if (cntry='BE' or cntry='CH') and gndr=2 and empl=6 and agea<64.
compute third=0.
else if (cntry='BE' or cntry='CH') and gndr=2 and empl=6 and agea>63.
compute third=1.
end if.
execute.
freq third.
do if (cntry='BG' or cntry='EE' or cntry='RO' or cntry='SI') and gndr=1 and empl=6 and agea<63.
compute third=0.
else if (cntry='BG' or cntry='EE' or cntry='RO' or cntry='SI') and gndr=1 and empl=6 and agea>62.
compute third=1.
end if.
execute.
freq third.
do if (cntry='BG' or cntry='HR') and gndr=2 and empl=6 and agea<59.
compute third=0.
else if (cntry='BG' or cntry='HR') and gndr=2 and empl=6 and agea>58.
compute third=1.
end if.
execute.
freq third.
do if cntry='HR' and gndr=1 and empl=6 and agea<64.
compute third=0.
else if cntry='HR' and gndr=1 and empl=6 and agea>63.
compute third=1.
end if.
execute.
freq third.
do if (cntry='EE' or cntry='PL' or cntry='GB') and gndr=2 and empl=6 and agea<60.
compute third=0.
else if (cntry='EE' or cntry='PL' or cntry='GB') and gndr=2 and empl=6 and agea>59.
compute third=1.
end if.
execute.
freq third.
do if cntry='IL' and gndr=1 and empl=6 and agea<67.
compute third=0.
else if cntry='IL' and gndr=1 and empl=6 and agea>66.
compute third=1.
end if.
execute.
freq third.
do if cntry='IL' and gndr=2 and empl=6 and agea<62.
compute third=0.
else if cntry='IL' and gndr=2 and empl=6 and agea>61.
compute third=1.
end if.
execute.
freq third.
do if (cntry='RO' or cntry='TR') and gndr=2 and empl=6 and agea<58.
compute third=0.
else if (cntry='RO' or cntry='TR') and gndr=2 and empl=6 and agea>57.
compute third=1.
end if.
execute.
freq third.
do if (cntry='RU' or cntry='TR' or cntry='UA') and gndr=1 and empl=6 and agea<60.
compute third=0.
else if (cntry='RU' or cntry='TR' or cntry='UA') and gndr=1 and empl=6 and agea>59.
compute third=1.
end if.
execute.
freq third.
do if (cntry='RU' or cntry='UA') and gndr=2 and empl=6 and agea<55.
compute third=0.
else if (cntry='RU' or cntry='UA') and gndr=2 and empl=6 and agea>54.
compute third=1.
end if.
execute.
freq third.
do if cntry='SK' and gndr=1 and empl=6 and agea<62.
compute third=0.
else if cntry='SK' and gndr=1 and empl=6 and agea>61.
compute third=1.
end if.
execute.
freq third.
do if (cntry='SK' or cntry='SI') and gndr=2 and empl=6 and agea<61.
compute third=0.
else if (cntry='SK' or cntry='SI') and gndr=2 and empl=6 and agea>60.
compute third=1.
end if.
execute.
freq third.
*Now I will categorize everybody who has minors as children or who is in poor health as non-third-agers.
recode hlthhmp (1=0) (2=0) into third.
execute.
recode minor (1=0) into third.
execute.
freq third.