How to 'replace' categorical data with entries that have multiple options?

[Daniel Ta]

Hi everyone, does anyone know how I can replace "CurrentPast" and "PastCurrent"?

[Rich Goldstein]

there appears to be an extra space for each of those; if it is really a space (rather than some strange character), you can use the trim function to get rid of it:

replace p1s7_q2_constipation=trim(p1s7_q2_constipation

note that since you pasted a picture, I was unable to copy-and-paste from #1 and there might be typos - please read the FAQ on how to show results

if it is some strange character, you can either discover what it is or you can use the substr function to eliminate it; see

help strtrim()
help substr()