How to change variable value to character

HowTo
#1

Dear all,

I’m thinking to use Exploratory to analyse and visualise a survey data. May I please ask how to assign text character to numeric value for my variables? For example one variable we have either value of 0 or 1, I wanted to show ‘no’ and ‘yes’ instead in the analysis output.
Similarly for scale value (1 2 3 4 5) how do I change it to strongly disagree, disagree, neither nor, agree, strongly agree?

Many thanks for your help.
Lee

#2

Hi Lee,

For 0 (No), 1 (Yes) case, you can try Convert to Logical column menu.

image
image.png1216×1416 139 KB

This will create Logical Column (TRUE for yes and FALSE for no your case) like this.

image
image.png464×888 25.2 KB

For Scale Value, you can try Replace Values menu like below.

image
image.png990×1336 122 KB

Then type in values like below.

image
image.png1804×1246 126 KB

And you can replace values like this.

image
image.png616×890 41.5 KB

1 Like
#3

Thank you Hide, this is very useful!

Lee