I have a dataset for the years 2000-2005 and another for 2006-2008.
In the first dataset, I have the following age groups: 0-14 years, 15-29, 30-39, 40-49, 50-59 and 60 and above. In the second one, I have: 0-5 years, 5-14, 15-24, 25-34, 35-44, 45-54, 55-64, 65-74, 75 and above. The data under these categories is binary (0-1). In the first dataset, I have another variable providing the age of all the subjects. I don't have such information in the second dataset (I just have the age groups mentioned above with 0-1 entries).
I wish to merge both datasets. I need to recategorize the age groups into maybe: 15-24, 22-34, 35-64, 65 and above. I could merge the categories in the years 2006-2008, and use the age variable to create these categories in the first dataset.
How is this done on spss? I need step-by-step instructions please.
I am looking forward to your reply. Many many thanks.
