Merging files

[Jignesh Sutar]

Hello,

I am attempting to merge files which isn't so straight forward...

My task is to merge variables.

Data1 contains 100 respondents.
Data2 contains 100 unique respondents but each with 2 rows of information.

I would like to add variables from data1 to data2 but for both rows of each
unique respondent.

Currently the standard 'merge variables' option only adds the new variables
to the first row of each unique respondent.

Could somebody please guide me how it is possible to execute what I require?

Many thanks in advance
Jigs

=====================
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

[Jignesh Sutar]

Problem solved,

On the Merge Variable box, "Non-active dataset is keyed table" needs to be
selected.

This copies data to multiple cases.


On 03/12/2007, J Sutar <[hidden email]> wrote:

>
> Hello,
>
> I am attempting to merge files which isn't so straight forward...
>
> My task is to merge variables.
>
> Data1 contains 100 respondents.
> Data2 contains 100 unique respondents but each with 2 rows of information.
>
> I would like to add variables from data1 to data2 but for both rows of
> each unique respondent.
>
> Currently the standard 'merge variables' option only adds the new
> variables to the first row of each unique respondent.
>
> Could somebody please guide me how it is possible to execute what I
> require?
>
> Many thanks in advance
> Jigs
>

=====================
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