I have a data fields with value options "unknown", 1,2,3,4,5,6, or "more than 6". I'd like to sum the numeric value, replacing "unknown" with 0, and "more than 6" with 7.
I thought I could assign values to numeric variables based on the data field values but just can't get the engine to start.
I've tried several things, for example, if one of the data fields is field_a
generate field_a_temp = 0
replace field_a_temp = 7 if (field_a == "more than 6")
and I get a type mismatch error. Same with generate field_a_temp = "", or generate field_a_temp = .

I am a beginner. Thanks for any guidance.