Merging datasets from several years

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 1
Joined: Thu Apr 30, 2015 7:45 pm

Merging datasets from several years

Postby Entrepreneurial » Thu Apr 30, 2015 7:57 pm


I have three datasets from three different years. All the respondent ID's are the same and I want to merge them together.
I know the steps to merge by doing: Data->merge files->add variables. But by doing this, the data will paste at the end of the other data.
I would like to know how I can get the data sorted by years like this:

Respondent ID Year gender
1 2008 m
1 2009 m
1 2010 m
2 2008 f
2 2009 f
2 2010 f
3 2008 f
3 2009 f
3 2010 f

Thanks in forward!
Posts: 1477
Joined: Tue Jun 10, 2008 4:50 pm

Re: Merging datasets from several years

Postby GerineL » Tue May 05, 2015 8:55 am

not entirely clear what your 2 files look like, but it sounds like you might need to use add cases instead of add variables.

Who is online

Users browsing this forum: No registered users and 2 guests