Efficient way for converting Yes/No to 1/0 in Excel or SPSS

excel converter spss
JavaLeave picture JavaLeave · Oct 27, 2013 · Viewed 32.3k times · Source

I am trying to find an efficient way for converting yes/no to 1/0 in Excel. Since I am doing the data analyzing at SPSS. Or if there is a way converting YES/NO to 1/0 in SPSS directly?

Answer

stobin picture stobin · Oct 27, 2013

Try this syntax in SPSS:

This will create a new field with 1 and 0. Also keep in mind that it's case sensitive.

numeric boolFieldName(f1).

recode ynFieldName ("YES" = 1) ("NO" = 0) into boolFieldName.
execute.

Related questions

Convert xlsx to csv in Linux with command line

I'm looking for a way to convert xlsx files to csv files on Linux. I do not want to use PHP/Perl or anything like that since I'm looking at processing several millions of lines, so I need something quick. …

Read More
How to convert a double value to a DateTime in c#?

I have the value 40880.051388 and am storing it as a double, if I open Excel and paste in a cell and apply the following custom format "m/d/yyyy h:mm" to that cell, I get "12/3/2011 1:14" How can I do …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More