Re: importing codes/values from excel to spss

Posted by David Marso on Oct 18, 2012; 1:11pm
URL: http://spssx-discussion.165.s1.nabble.com/importing-codes-values-from-excel-to-spss-tp5715703p5715710.html

It is not entirely clear what you require.
If I am reading your mind correctly then I suspect you want to create a VALUE LABELS command.
Consult the FM for the required content and build a formula (=A2 & " '" & B2 & "'") in Excel.  Drag it and populate the remaining rows. Then copy/paste the result into a syntax window and run it against your data file.
VALUE LABELS city
        1 'city1'
        2 'city2'
.....
.

Eins Bernardo wrote

Dear SPSS Experts,

I have two different files now: Excel and SPSS files. The excel file contains the list of 1500 "city address" with corresponding values/codes(e.g., 1= city1,  2=city2, 3=city3, ....1500=city1500).  Now, I will add the "city address" to my SPSS file. Is there a way to input the codes/values to SPSS without encoding manually the 1500 codes/values?

Your help is highly solicited.

Thank you.
Eins