Dear All,

I have six variables. Based on them I want t create a new variable which would be based on these 6 variables. The condition that if:

if at least 2 domains/questions (Any from dm33 to dm38) are coded SOME DIFFICULTY or any 1 domain/question (any from dm33 to dm38) is coded A LOT OF DIFFICULTY or CANNOT DO AT ALL then the new variable should take the value 1 or else it will take the value 0.

Thank you in advance

An example of my data set

----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input byte(dm33 dm34 dm35 dm36 dm37 dm38)
1 2 2 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 4 3 1 1 1
1 1 1 1 1 1
2 2 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 2 2 1 1
1 3 1 2 2 1
1 1 2 1 2 1
1 1 1 2 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 4 1 1 1 4
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 2 1 1
1 1 1 2 1 1
1 1 1 2 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 2 1 1
1 1 2 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 2 2 1 2 1
1 2 2 1 2 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
3 1 1 1 1 1
3 1 2 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 2 1 1 1
1 1 1 1 1 1
3 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
2 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
2 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 2 1 1 2
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
2 2 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
end
label values dm33 DM33
label def DM33 1 "No-no difficulty", modify
label def DM33 2 "Yes_some difficulty", modify
label def DM33 3 "Yes_alot of difficulty", modify
label values dm34 DM34
label def DM34 1 "No-no difficulty", modify
label def DM34 2 "Yes_some difficulty", modify
label def DM34 3 "Yes_alot of difficulty", modify
label def DM34 4 "Cannot hear at all", modify
label values dm35 DM35
label def DM35 1 "No-no difficulty", modify
label def DM35 2 "Yes_some difficulty", modify
label def DM35 3 "Yes_alot of difficulty", modify
label values dm36 DM36
label def DM36 1 "No-no difficulty", modify
label def DM36 2 "Yes_some difficulty", modify
label values dm37 DM37
label def DM37 1 "No-no difficulty", modify
label def DM37 2 "Yes_some difficulty", modify
label values dm38 DM38
label def DM38 1 "No-no difficulty", modify
label def DM38 2 "Yes_some difficulty", modify
label def DM38 4 "Cannot do at all", modify