Re: loop and do repeat problem with thousands of unique values to insert

Posted by Maurice Vergeer on
URL: http://spssx-discussion.165.s1.nabble.com/loop-and-do-repeat-problem-with-thousands-of-unique-values-to-insert-tp4268902p4269458.html

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 <[hidden email]> 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
[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