I have a practical question about SPSS that is really important to me. I want to combine several datasets into one dataset and I am wondering if someone can advise me on how to do that.
Description of my data:
[*] I have 30 datasets/datafiles (every one of them is a similar dataset for the years 1981, 1982, ... , 2010).
[*] In every dataset there are about 1000 entries. It is a yearly survey on 1000 people (different people every year) and you have variables such as age, gender, education etc. etc.
Description of what I want to do with the datasets:
[*] In every dataset there are about 100 variables, but I want to use only 6 of them.
[*] I want to create 1 single large dataset in which for all the 30 years, from all 30 datasets, all entries come together in 1 dataset for the specific variables that I want to use.
[*] Because I want to do time series analysis, it is necessary that in the new dataset all entries per yearly dataset get an extra variable: the year (1981, 1982, ... , 2010). The variable 'year' is not listed in the 30 individual datasets (it is onlye in the title of every individual dataset).
Example to clarify what I want to do:
[*] I now have 30 datasets in which every time 1000 people are asked about their age, gender, education etc. I want to combine all these datasets into 1 dataset in which I have all the (ca. 30.000) entries for all the variables that I need, including the variable 'year' (that is not in any individual dataset yet). I want to create this dataset with the goal to examine if I can find a trend in these 30 years in the relation between a couple of these variables.
Thank you for helping me out. All advice is very welcome (I am a bit in hurry with carrying out this research but I am stuck with my data). If my post here is not clear, then please ask me more and I will answer it asap.