Merging two files with table lookup

[rana-7]

Hi all,
i have a question about merging files. When i try to do the merging i got
this error : Error#5131.
I use an old version of SPSS in my university V12 :lol: . So i hope someone
can help me to fix this error.

P.S : I don't have all variables.

Many ragards.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Maguin, Eugene]

Uhhh, Rana,

Like, what does Error 5131 say? More specifically, how about pasting the
exact text of the error message along with your syntax in your reply. Also,
what are we supposed to know from your postscript message?

Gene Maguin


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
rana
Sent: Wednesday, June 23, 2010 8:40 PM
To: [hidden email]
Subject: Merging two files with table lookup

Hi all,
i have a question about merging files. When i try to do the merging i got
this error : Error#5131.
I use an old version of SPSS in my university V12 :lol: . So i hope someone
can help me to fix this error.

P.S : I don't have all variables.

Many ragards.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[rana-7]

Thanks Gene for your reply,

You can see the error on this link :
http://img532.imageshack.us/img532/7985/screenspss.png

Thnks.

Many regards.

Rana.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Maguin, Eugene]

Rana,

The error is the (in)famous duplicate key error, in your case, in table
file. So, your 'table' file has multiple records with the same value on the
'by' variable (or combination of values on the by variables). You have find
and fix the problem.

Can you work the problem from here or would you like more advice? If more
advice, then when you respond, we need to know more details. Practically,
you should just post your match files statement or, if you don't want to do
that, the minimum is to post the complete 'by' subcommand. Let me also add
that the only fix is do something to make the problem records unique. Maybe
delete some records; maybe add another by variable. It depends on your
specific situation.

Gene Maguin


-----Original Message-----
From: rana [mailto:[hidden email]]
Sent: Friday, June 25, 2010 7:30 AM
To: [hidden email]; [hidden email]
Cc: rana
Subject: Re: Merging two files with table lookup

Thanks Gene for your reply,

You can see the error on this link :
http://img532.imageshack.us/img532/7985/screenspss.png

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD