Date:         Tue, 29 Mar 2011 23:01:52 +0900
Reply-To:     Maurice Vergeer <m.vergeer@maw.ru.nl>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Maurice Vergeer <m.vergeer@maw.ru.nl>
Subject:      Re: loop and do repeat problem with thousands of unique values to
              insert
Comments: To: David Marso <david.marso@gmail.com>
In-Reply-To:  <1301406454793-4269420.post@n5.nabble.com>
Content-Type: text/plain; charset=UTF-8

Dear David,

thanks for your suggestion you provided in the earlier email. I need
to let it sink in what really happens in the example.
True, sorting is nasty in SPSS

now you mention normalizing: the variable later in line (name14) the
more blanks there are.


thanks
Maurice


On Tue, Mar 29, 2011 at 22:47, David Marso <david.marso@gmail.com> wrote:
> Best bet is these cases is to write syntax once against a properly normalized
> data structure (in this a sorted case long format). Â Do the necessary merge
> and then mop up with an aggregate and a final match. Â see my example.
> Sorting the huge file multiple times with all of the variables in the file
> in place is going to kill your hard disk. Â Trust me, I've been doing this
> stuff for over 20 years!
>
>
> --

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