Eins, there’s some things missing in your problem description. I’ve seen what Ruben said and agree. In addition, I wonder if the two files have a common key. I also wonder if there is a one to one correspondence between rows in the excel file and rows in the spss file. If there were a 1-to-1 correspondance you could create a key using $casenum. Or, use match files without a BY subcommand (I think I recall that I did this and it worked and yielded no errors.)
Gene Maguin
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Eins Bernardo
Sent: Wednesday, October 17, 2012 10:51 PM
To: [hidden email]
Subject: importing codes/values from excel to spss
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
| Free forum by Nabble | Edit this page |