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

[David Marso]

Only 25 pages? ;-)
I don't believe there is any hard limit to the number of recode clauses.  
It might take awhile to process and might even appear to go AWOL and then come back.
Someone at SPSS might be able to answer this definitely.
Certainly more than several 1000.  I've thrown some pretty nasty stuff at SPSS over the years.
What we have discovered today is there are many ways to solve such a problem.
The problem with tons of IF statements is the need to test every variable against every IF statement for every case.  RECODE will be more efficient.

<quote author="Albert-Jan Roskam">
;-)
Hmmm, the good ol' WRITE OUTFILE. I remember I generated 25 pages of IF
statements and my colleague printed that syntax. *sigh* so many trees.


I wonder if there's a limit to the number of recodes within one RECODE though.

 Cheers!!
Albert-Jan


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public
order, irrigation, roads, a fresh water system, and public health, what have the
Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


<SNIP previous threads>

[Maurice Vergeer]

Dear all,

my apologies for my delayed reply on this matter. I got side tracked
by other business.

Anyhow, thanks for all your creative thinking. In the end I used 14
separate match files, which was easiest and quickest in the short run.

Indeed the sorting was the hard part, but we know that from SPSS.
Although, the 14 files to match had increasingly fewer cases, as well
as removing all redundant variables .

thanks to David Marso for his extensive example. I'll look further
into it, because my problem won't be the last one.
The same holds for Albert-Jan and his solution, reminding me to get
into python again, if time allows.
As well as Art Kendall's suggestions and all the others.


Best wishes,
Maurice











--
___________________________________________________________________
Maurice Vergeer
Department of communication, Radboud University�  (www.ru.nl)
PO Box 9104, NL-6500 HE Nijmegen, The Netherlands

Visiting Professor Yeungnam University, Gyeongsan, South Korea

Recent publications:
-Vergeer, M., Hermans, L., & Sams, S. (forthcoming). Online social
networks and micro-blogging in political campaigning: The exploration
of a new campaign tool and a new campaign style. Party Politics.
-Pleijter, A., Hermans, L. & Vergeer, M. (forthcoming). Journalists
and journalism in the Netherlands. In D. Weaver & L. Willnat, The
Global Journalist in the 21st Century. London: Routledge.
-Eisinga, R., Franses, Ph.H., & Vergeer, M. (2010). Weather conditions
and daily television use in the Netherlands, 1996–2005. International
Journal of Meteorology.

Webspace
www.mauricevergeer.nl
http://blog.mauricevergeer.nl/
www.journalisteninhetdigitaletijdperk.nl
maurice.vergeer (skype)
___________________________________________________________________

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

[Kelly Vander Ley]

I will be out of the office from Tuesday April 12th  -April 18th, returning to the office on April 19th. I will not have regular access to email.  If you need immediate assistance please call the main office number 503/223-8248 or 800/788-1887 and the receptionist will ensure that I get the message.  Thank you. Kelly