Create a new column and populate it with recoded variables
Hi All, Here is my question:
I have uploaded an excel file where there is a column with a list of email addresses and a column called ''answers''. In this column there are numerical values from 1 to 100. Now, I know that those who answered giving a value equal or greater to 54 gave the correct answer, while the others answered wrong
What I want to do is to create a new column, called ''answers recoded'' where I simply put CORRECT when the person answered =>54 and WRONG for all the other values.
Please kindly let me know if you have any ideas. Since I am a very beginner, please also tell me if I have to write the ''If-else'' conditions in the script or somewhere else.
Re: Create a new column and populate it with recoded variables
Thanks for your swift reply,
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);