One to Many Merge

[angelini]

How do I merge a variable (Zipcode and median income) into my active
data base. The shared variable in each of my data bases is Zipcode. The
problem I have is that the active data base has many cases that share
the same Zipcode. Not sure how to do it except to manually plug in the
income variable.

Any  help would be appreciated.

[Beadle, ViAnn]

Take a look at the TABLE subcommand on MERGE FILES which does the one to many merge.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of angelini
Sent: Wednesday, April 25, 2007 2:44 AM
To: [hidden email]
Subject: One to Many Merge

How do I merge a variable (Zipcode and median income) into my active
data base. The shared variable in each of my data bases is Zipcode. The
problem I have is that the active data base has many cases that share
the same Zipcode. Not sure how to do it except to manually plug in the
income variable.

Any  help would be appreciated.

[Richard Ristow]

At 10:25 AM 4/25/2007, Beadle, ViAnn wrote:

>Take a look at the TABLE subcommand on MERGE FILES which does the one
>to many merge.

Exactly. Except, of course, the command is MATCH FILES, not MERGE
FILES.