Hi
In my survey, I had a ranked order question. I asked the participants to rank 6 variables from 1 to 6.
The dataset is arranged like bellow for this specific question: ("- - - - -" indicates missing)
ranking
4 - 6 - 2 - 3 - 5 - 1
6 - 4 - 5 - 2 - 3 - 1
- - - - -
2 - 4 - 6 - 5 - 3 - 1
6 - 2 - 4 - 5 - 3 - 1
- - - - -
- - - - -
- - - - -
5 - 4 - 6 - 2 - 3 - 1
Currently, Stata considers its storage type as str21 and I need to change it to a numeric type.

How can I break the variable ranking into six different variables: R_var1, R_var2, ..., R_var6 (which means the ranking of var1, ranking of var2, and so on)

Thanks for the recommendations.