Re: importing codes/values from excel to spss

Posted by Ruben Geert van den Berg on Oct 18, 2012; 7:21am
URL: http://spssx-discussion.165.s1.nabble.com/importing-codes-values-from-excel-to-spss-tp5715703p5715707.html

Dear Eins,

This sounds like you basically need a "match files" command with one file and one table. IIRC (but I usually mess up this part) the Excel file will be the file (unique keys) and the SPSS file the table (possibly duplicate keys, there can be multiple respondents with the same city code).

You may first need to read the xls into SPSS and apply a bit of editing, depending on the exact format.

HTH,

Ruben

---

Date: Thu, 18 Oct 2012 10:50:46 +0800
From: [hidden email]
Subject: importing codes/values from excel to spss
To: [hidden email]

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