exporting to SPSS

  • Thread starter Thread starter lnadams
  • Start date Start date
L

lnadams

There have been a lot of questions about this, but I need to get excel
data into SPSS --IN A PARTICULAR FORMAT-- because I will be appending
it to an existing master dbase that has variables defined already.

I can make SPSS read my excel data, I just can't make it read as string
vs. numerical.

Does excel have a function where I can define value labels ie., male=1,
female=2 so that if the string in excel is 'male' then SPSS will read
it as '1'???
 
No. Unless SPSS supports reading in either values or lables, You would have
to convert your labels to the values SPSS stores.

You can do this conversion by selecting the column and using Edit=>Replace
 
Back
Top