Letter to numerb: Create a new 'if' variable to change 'Y' and 'N' to 1 and 0

I would like to create a new variable and change those 'N's and 'Y's to 0 (N) and 1 (Y).

Does someone know an easy way to solve the problem?

Best regards

Max

Answer 1

[dpb]

>> categorical({'Y';'N';'Y'},{'N';'Y'},{'0';'1'})
ans = 
  3×1 categorical array
     1 
     0 
     1 
>> matches({'Y';'N';'Y'},'Y')
ans =
  3×1 logical array
   1
   0
   1
>> categorical(matches({'Y';'N';'Y'},'Y'))
ans = 
  3×1 categorical array
     true 
     false 
     true 
>> 

[Max]

I´m not able to use it in my editor..

[dpb]

What does that mean, pray tell? What is "it" and what are you trying to accomplish?

Above is three slightly different approaches to converting a string variable Y/N to a logical one...

BTW, there's no data in the attached spreadsheet that shows anything that appears to be at all related to the question asked...