How to recode the values of non-numbers? | Experience Community
Skip to main content
JoseS
Administrator
1 year ago
Solved

How to recode the values of non-numbers?

  • Jun 14, 2022 8:58 PM UTC
  • 5 replies
  • 57 views
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
  • MatthewM
  • Level 6 ●●●●●●
  • Answer
  • Jun 15, 2022 1:38 PM UTC

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
  • SunnyHills
  • Author
  • Jun 16, 2022 1:57 AM UTC

image.pngThen what next? Many thanks in advance!

MatthewM
Level 6 ●●●●●●
Forum|alt.badge.img+30
  • MatthewM
  • Level 6 ●●●●●●
  • Jun 16, 2022 1:38 PM UTC

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

Forum|alt.badge.img
  • SunnyHills
  • Author
  • Jun 17, 2022 1:18 AM UTC

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 ●●●●●●
  • Jun 20, 2022 1:54 PM UTC

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