Good day everyone,

i am trying to make a cross tab analysis and I have a question regarding one of my variables.
i have a multiple choice variable and would like to convert them into a likert scale format.
Question: Which of the COVID-19 preventive measures have you followed during the pandemic?
Answers
1. Self-isolation
2. Social distancing
3. Wearing facemasks in public settings or transport
4. Wearing gloves
5. Use of hand sanitizers
I would like to classify them as the following:
1 scale: if respondents selected any one the results above
2 scale: if respondents selected any two the results above
3 scale: if respondents selected any three the results above
4 scale: if respondents selected any four the results above
5 scale: if respondents selected any five the results above
This is what it looks like now with 17 sets of options, but will like to break it down to those 5 scales.
Which of the COVID-19 |
preventive measures |
have you followed | Sex
during the pandemic? | Female Male | Total
----------------------+----------------------+----------
Self-isolation | 1 4 | 5
| 0.58 1.99 | 1.34
----------------------+----------------------+----------
Self-isolation, Socia | 2 0 | 2
| 1.16 0.00 | 0.54
----------------------+----------------------+----------
Self-isolation, Socia | 0 2 | 2
| 0.00 1.00 | 0.54
----------------------+----------------------+----------
Self-isolation, Socia | 1 0 | 1
| 0.58 0.00 | 0.27
----------------------+----------------------+----------
Self-isolation, Socia | 24 26 | 50
| 13.95 12.94 | 13.40
----------------------+----------------------+----------
Self-isolation, Socia | 1 0 | 1
| 0.58 0.00 | 0.27
----------------------+----------------------+----------
Self-isolation, Socia | 95 118 | 213
| 55.23 58.71 | 57.10
----------------------+----------------------+----------
Self-isolation, Weari | 1 0 | 1
| 0.58 0.00 | 0.27
----------------------+----------------------+----------
Social distancing | 1 1 | 2
| 0.58 0.50 | 0.54
----------------------+----------------------+----------
Social distancing, We | 2 2 | 4
| 1.16 1.00 | 1.07
----------------------+----------------------+----------
Social distancing, We | 24 17 | 41
| 13.95 8.46 | 10.99
----------------------+----------------------+----------
Social distancing, We | 15 23 | 38
| 8.72 11.44 | 10.19
----------------------+----------------------+----------
Social distancing, We | 0 1 | 1
| 0.00 0.50 | 0.27
----------------------+----------------------+----------
Use of hand sanitizer | 1 2 | 3
| 0.58 1.00 | 0.80
----------------------+----------------------+----------
Wearing facemasks in | 2 1 | 3
| 1.16 0.50 | 0.80
----------------------+----------------------+----------
Wearing facemasks in | 1 1 | 2
| 0.58 0.50 | 0.54
----------------------+----------------------+----------
Wearing facemasks in | 1 3 | 4
| 0.58 1.49 | 1.07
----------------------+----------------------+----------
Total | 172 201 | 373
| 100.00 100.00 | 100.00

Pearson chi2(16) = 14.7440 Pr = 0.543

Will be grateful for the assistance
Thank you.