Date:         Fri, 28 May 2004 08:51:22 -0700
Reply-To:     Brian Moore <bmoore@worldatwork.org>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Brian Moore <bmoore@worldatwork.org>
Subject:      Matching Files with Transactional and customer data
Content-Type: text/plain; charset="iso-8859-1"

Hi all-

I have a transactional data file (record per transaction) to which I would
like to append customer data.

Merge files does not like the duplicate key, but I think technically worked.
The first record of each customer in the transactional data was successfully
appended to, all other records in the transactional file for the same
customer number show up as $sysmis.

I solved this by restructuring the transactional file (case to vars), but am
less comfortable working with the data that way.

Is there a way to get all records of a customer to reflect their customer
data.

Begin Data
File 1 (transactional)
Cust
1
1
2
2
3
4


File 2 (customer data)
Cust    Class
1       8
2       88
3       888
4       8888

To yield
File 1
Cust    Class
1       8
1       8
2       88
2       88
3       888
4       8888

Any guidance much appreciated.
Regards,
Brian