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

How to recode the values of non-numbers?

  • June 14, 2022
  • 5 replies
  • 28 views
S
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

5 replies

MatthewM
Level 6 ●●●●●●
Forum|alt.badge.img+30
  • MatthewM
  • Level 6 ●●●●●●
  • 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

S
Forum|alt.badge.img
  • SunnyHills
  • Author
  • June 16, 2022

image.pngThen what next? Many thanks in advance!

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

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

S
Forum|alt.badge.img
  • SunnyHills
  • Author
  • 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
  • MatthewM
  • Level 6 ●●●●●●
  • 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?

Terms & ConditionsAccessibility statement