exporting to SPSS

[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'???

 

[Tom Ogilvy]

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