Many to many merge in SPSS

[Shiri Bogomolny]

Hi,

I am looking to combine two files on SPSS. The first (with over 1 million cases) has program participants and the program code that they participated in. The second file has the program codes and the program group, so many program codes are tagged to each group (there are about 400 programs). I am trying to merge so that next to each program participant's program number the program group shows up. The program numbers repeat and the program groups repeat so I am not sure how to merge the two files with duplicate variables on both as when I try a basic merge variables it says it can't because of it.

Thank you for your help in advance!

Shiri

[David Marso]

How is this a 'many to many' merge?

Presumably each program code would belong to a single program group.
AGGREGATE the program code file then do the merge as a TABLE to the first file.

If program codes are not nested within single program groups then flatten the file using CASESTOVARS and then carry on as usual.

HTH

Post by Shiri Bogomolny
Hi,
I am looking to combine two files on SPSS. The first (with over 1 million cases) has program participants and the program code that they participated in. The second file has the program codes and the program group, so many program codes are tagged to each group (there are about 400 programs). I am trying to merge so that next to each program participant's program number the program group shows up. The program numbers repeat and the program groups repeat so I am not sure how to merge the two files with duplicate variables on both as when I try a basic merge variables it says it can't because of it.
Thank you for your help in advance!
Shiri

[Rich Ulrich]

On Wed, 8 Mar 2017 09:14:12 -0800 (PST), Shiri Bogomolny

Post by Shiri Bogomolny
Hi,
I am looking to combine two files on SPSS. The first (with over 1 million cases) has program participants and the program code that they participated in. The second file has the program codes and the program group, so many program codes are tagged to each group (there are about 400 programs). I am trying to merge so that next to each program participant's program number the program group shows up. The program numbers repeat and the program groups repeat so I am not sure how to merge the two files with duplicate variables on both as when I try a basic merge variables it says it can't because of it.

I must be reading this differently than David does -- because
I don't grok the AGGREGATE.

In fact, I get bogged down before a solution by noticing
1) program code
2) program group
3) program number

and being unsure whether there are supposed to be 3
variables or if "number" is another name for "code"

Possibilities.
Given: Program Groups 1-10 (say); program Codes 1-40 (more or
less, say) under each Group. Just to be concrete, for a change.

I am assuming that the second file is a table with the 400 records,
and "match" is a better description than "merge."


Each participant only has "Code" to work from.
1) If the Codes go 1-n under each group => no way to recover Group.
2) If the Codes go 1-n for Group 1, and sequentially higher numbers
for each other Group, then you sort the participants on Code and match
the other file as Table.

Each participant has "Code" alongside "Number".
3) If there is a separate "Program number" that works like (2),
then sort and match on that in the Table-file.

4) If codes are all 1-n for varying n, then the highests codes
have a restricted set of groups they could represent.


Please let us know.

[v***@gmail.com]

If you want to merge multiple PST files into a single file then you can use Softknoll Merge PST software. This tool will merge unlimited Outlook PST file into a single file. Visit at @ : http://www.softknoll.com/merge-pst/

[David Marso]

Nobody said anything re pst flies.

[h***@gmail.com]

The Outlook applying all their messages and another important database in PST file format and we use these email files according to your requirement. But many times while using Outlook PST file one by one we have to face many difficulties and wasting time, software hanging and others. If you having lots of PST files and want to make all of them readable at one time then use PST Merge software. Merge PST tool will help you to merge your multiple PST files into one single file and use them without wasting time. You can move your files before merging to one place to another place or folders. You can select your files before merging and install at a specified location or folder.
Visit here:- https://www.osttopstapp.com/pst-merge.html