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

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

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!