On Wed, 8 Mar 2017 09:14:12 -0800 (PST), Shiri Bogomolny
Post by Shiri Bogomolny
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"
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.