How to recode the values of non-numbers? | XM Community
Skip to main content
Solved

How to recode the values of non-numbers?


Forum|alt.badge.img

In qualtrics, I know how to recode if the values are numbers. But currently I have a question: what state are you live in the U.S.? So there are 50 states. And what I want recode is AL, AK, AZ,... These are letters not numbers. I don't know how to do.

Best answer by MatthewM

In the Data & Analysis tab, you can use the Field Editor to create a new field in your data. Set the new field to equal the abbreviation for each state found in the original field.
image.pngThis can be done in the "Bucketing" option.
image.png

View original

5 replies

MatthewM
Level 6 ●●●●●●
Forum|alt.badge.img+30
  • Level 6 ●●●●●●
  • 1069 replies
  • Answer
  • June 15, 2022

In the Data & Analysis tab, you can use the Field Editor to create a new field in your data. Set the new field to equal the abbreviation for each state found in the original field.
image.pngThis can be done in the "Bucketing" option.
image.png


Forum|alt.badge.img
  • Author
  • 5 replies
  • June 16, 2022

image.pngThen what next? Many thanks in advance!


MatthewM
Level 6 ●●●●●●
Forum|alt.badge.img+30
  • Level 6 ●●●●●●
  • 1069 replies
  • June 16, 2022

It will create a new variable in your dataset with state abbreviation.


Forum|alt.badge.img
  • Author
  • 5 replies
  • June 17, 2022

I didn't figure it out. This is my attempt. But this doesn't work.
image.png


MatthewM
Level 6 ●●●●●●
Forum|alt.badge.img+30
  • Level 6 ●●●●●●
  • 1069 replies
  • June 20, 2022

Can you provide a little more detail about the result? What do the data in your new state abbreviation field look like?


Leave a Reply