Thanks everyone for your help! All sorted! Sinéad O Neill PhD Scholar NPEC, ANU Research Centre Dept of Obstetrics & Gynaecology 5th Floor CUMH Wilton, Cork. (+353-21-492-0656) (+353-86-3586895) On 18 Sep 2013, at 12:46, Sinead O Neill <[log in to unmask]> wrote: > Hi. > > I want to make one variable called 'Gross Income'. > > I currently have a variable for gross income for each year, > e.g. Gross_Income1980, > Gross_Income1981, > Gross_Income1982, > etc. right up to Gross_Income2010. > > I want to make one variable for 'Gross Income' which is equal to a woman's gross_income in the year before she gave birth. > > For example, if I have a woman who gives birth in 1982 (variable name Birth_1982), I want to use the gross_income variable from 1981 (Gross_Income1981) > > How do I make a single variable for 'Gross Income' which is equal to a woman's gross income the year before she gave birth? > This is for a Cox regression analyses. > > Thanking you!! > > Sinead > > You may leave the list at any time by sending the command > > SIGNOFF allstat > > to [log in to unmask], leaving the subject line blank. You may leave the list at any time by sending the command SIGNOFF allstat to [log in to unmask], leaving the subject line blank.