Date:         Mon, 21 May 2012 16:13:32 -0700
Reply-To:     David Marso <david.marso@gmail.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         David Marso <david.marso@gmail.com>
Subject:      Re: One to many merge of large dataset
In-Reply-To:  <1337641187382-5713200.post@n5.nabble.com>
Content-Type: text/plain; charset=us-ascii

"table file does not have a unique identifier "..
That means that you have one or more duplicate keys in the file you
designate as TABLE.
After the sort try:

MATCH FILES / FILE * / FIRST=@TOP@/LAST=@BOT@ / BY TSTNO .
COMPUTE @UNIQUE@=@TOP@ AND @BOT@.
FREQ @UNIQUE@.



jredshaw wrote
>
> I'm a relatively new SPSS user. I am trying to add several variables from
> one dataset with only one entry per ID number
> (https://www.dropbox.com/s/1jzaxcmjswdz7w0/Veh%20Data%20Reduced.sav) to
> another larger dataset that has several entries per ID number
> (https://www.dropbox.com/s/lguvj3n6ceezkzs/Inst%20Data.sav)
>
> -ID number is TSTNO and I am trying to use variations on the following
> code thinking that this should be a one to many merge, however, I can't
> seem to get it to work. I keep getting error 5132 (I think, sorry I don't
> actually have it in front of me) - table file does not have a unique
> identifier
>
> GET
>   FILE='/Users/Jeff/Desktop/Veh Data Reduced.sav'.
> DATASET NAME DataSet4 WINDOW=FRONT.
> SORT CASES BY TSTNO.
>
> GET
>   FILE='/Users/Jeff/Desktop/Inst Data.sav'.
> DATASET NAME DataSet1 WINDOW=FRONT.
> SORT CASES BY TSTNO.
>
> Match files file='/Users/Jeff/Desktop/Inst Data.sav'
> /TABLE='/Users/Jeff/Desktop/Veh Data Reduced.sav'
> /BY TSTNO.
>
> Any thoughts? I have tried it both ways and get the same error. Any help
> would be greatly appreciated. Thanks.
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/One-to-many-merge-of-large-dataset-tp5713200p5713207.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (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