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-tp4268902.html
dear fellow list visitors,
please help me with this problem.
I have the following syntax which works perfectly.
It 'replaces' strings in old variables (name1 to name14) into
numerical ones in a new variable (newname1 to newname14).
example:
vector name=name1 to name14.
vector newname(14).
loop i=1 to 14.
do repeat a="alpha" "beta" "gamma" / b=1 2 3.
- if name(i) = a newname(i)=b.
end repeat print.
end loop.
However, instead of three values (alpha beta and gamma) I have
thousands of unique string values stored in a separate system file,
each identified with a unique numerical code.
How can I insert these values in the do repeat function (after 'a='
and after 'b=')?
The reason why I want to change these from string to numeric ones is
that I know the system file will be smaller and hopefully also faster
to read.
You help is much appreciated.
sincerely
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. (accepted for publication).
Online social networks and micro-blogging in political campaigning:
The exploration of a new campaign tool and a new campaign style. Party
Politics.
-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