Hi, I'm trying to set the values of a variable to MISSING ('') using the create format task. the original table looks somewhat like Name Gender Wally U Walter M Violeta F Viktor M Viktoria Victoria F Victoria Tim M The Gender is classified as F for female, M for male, U or MISSING value for undefined. I like to set all gender values of 'F' to 'female', 'M' to 'male' and 'U' or MISSING value to MISSING. Afterwards the table should look like this Name Gender Wally Walter male Violeta female Viktor male Viktoria Victoria female Victoria Tim male I tried to do so by using the create format task but if I leave the label for "all other values" empty I get two single quotaion marks ('') instead of empty entries. My table looks like Name Gender Wally '' Walter male Violeta female Viktor male Viktoria '' Victoria female Victoria '' Tim male I wonder if it is possible to do this with the create format task or do ii have to use a CASE-WHEN-THEN-ELSE statement?
... View more