exporting to SPSS

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top