Creating new variables by grouping existing variable

[nematullah17]

Hi

I have a dataset that has variables such as basketball baseball football swimming chess softball. I want to categorize the various sports under “high” or “low” risk sport under a new variable risklevel; basketball baseball football=high and swimming chess softball=low.

dataset looks something like below

     basketball baseball football swimming chess softball

          1              0            0             1              0        1

          1              1            1             0              0        1

          1               0           1            0              1         0

          1               1           0            1              0         1

Any help is greatly appreciated!

[andreas_lds]

Not clear how the result should look like, please explain.