Hello,
I am a little confused to create a dummy variable for mental disability from the CESD questionnaire. Can someone help me to command the stats?
Here is my dataex.
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str8 hhid14 double(kp02A kp02B kp02C kp02D kp02E kp02F kp02G kp02H kp02I kp02J)
"0010600" 1 1 1 1 3 1 1 4 3 3
"0010651" 1 2 2 2 2 1 2 2 1 1
"0010600" 1 3 3 2 3 2 2 3 2 2
"0010600" 3 3 2 1 3 1 1 2 1 1
"0010651" 2 2 1 1 2 1 1 2 2 1
"0010851" 1 4 4 4 4 4 4 4 4 1
"0010800" 2 2 2 2 2 2 2 2 1 1
"0010851" 1 1 1 1 3 1 1 3 1 1
"0012200" 2 3 1 2 2 2 3 2 3 1
"0012200" 2 3 3 1 1 1 2 1 1 1
"0012241" 2 2 2 3 2 2 1 2 3 2
"0012200" 2 2 1 4 4 1 1 4 1 1
"0012242" 3 2 2 1 4 2 2 4 3 1
"0012251" 3 3 2 2 3 1 2 3 2 4
"0012241" 2 2 1 1 3 1 1 2 1 1
"0012241" 2 2 2 2 2 2 2 2 2 2
"0012400" 1 1 1 1 1 1 2 1 4 1
"0012400" 1 4 1 1 3 1 1 2 1 4
"0012400" 3 2 3 2 3 1 1 3 2 3
"0012451" 3 4 1 3 4 1 3 3 1 3
"0012400" 1 2 2 2 2 3 2 2 2 2
"0012452" 3 1 1 1 1 1 1 1 1 4
"0012400" 2 3 2 3 4 1 1 3 3 2
"0012400" 3 2 2 3 4 3 1 4 3 3
"0012400" 1 1 1 2 2 1 1 3 2 1
"0012400" 1 1 1 1 1 1 1 1 3 1
"0012400" 1 2 1 2 4 3 2 3 1 1
"0012400" 2 2 2 2 3 1 2 1 3 2
"0012451" 1 4 1 4 2 1 4 1 1 1
"0012452" 1 2 1 2 4 1 1 2 2 2
"0012500" 1 2 3 1 2 2 1 4 3 3
"0012500" 1 3 1 2 4 1 3 2 1 1
"0012900" 1 1 1 1 1 1 4 1 4 4
"0012951" 1 1 1 4 4 1 1 2 1 1
"0012952" 1 1 1 4 4 1 2 1 1 1
"0012953" 3 3 3 3 3 3 3 3 3 3
"0012900" 1 2 2 2 1 2 2 2 2 3
"0012951" 3 3 3 3 3 3 4 4 1 1
"0020100" 2 1 1 1 1 1 1 4 1 1
"0020100" 1 1 3 1 3 3 3 3 1 1
"0020100" 2 2 1 2 3 1 1 3 1 1
"0020100" 1 1 1 1 2 1 1 4 1 1
"0020151" 1 1 1 2 4 1 1 4 1 1
"0020152" 1 1 3 1 4 1 1 1 1 1
"0020100" 1 1 1 2 3 3 1 3 3 2
"0020151" 2 2 2 3 3 2 1 1 1 2
"0020200" 1 1 1 1 1 1 1 2 1 1
"0020200" 2 1 1 1 4 4 2 3 3 1
"0020400" 3 3 3 2 3 4 4 3 3 3
"0020400" 1 3 3 4 4 3 1 3 1 1
"0020441" 1 1 1 1 4 1 1 1 1 1
"0020400" 2 3 4 4 3 2 4 3 1 1
"0020451" 1 1 1 1 4 1 2 2 1 1
"0020400" 1 3 1 4 4 2 1 2 1 1
"0020500" 1 1 1 1 2 1 1 4 1 1
"0020600" 1 1 1 1 1 1 1 4 1 1
"0020651" 1 1 1 2 4 1 1 4 1 3
"0020600" 1 1 2 4 4 2 4 4 1 1
"0020600" 2 4 4 2 4 2 2 2 2 2
"0020651" 2 1 2 4 4 2 1 2 1 3
"0021143" 4 3 1 4 4 3 2 1 1 2
"0021143" 1 4 4 1 1 1 4 1 1 4
"0021143" 1 1 2 1 2 1 1 2 1 2
"0021500" 1 3 4 4 2 1 4 1 2 4
"0021500" 4 2 1 2 4 1 1 2 2 4
"0021800" 1 4 3 3 2 1 1 1 1 1
"0021800" 4 3 1 1 4 1 1 4 1 4
"0021800" 3 3 1 1 3 1 1 3 3 3
"0021841" 2 2 2 2 2 1 1 2 1 1
"0021800" 1 1 1 1 4 1 2 3 1 1
"0021831" 1 2 1 1 1 1 1 1 1 1
"0021900" 1 1 2 1 1 1 1 1 1 1
"0021900" 1 1 1 1 1 2 1 2 1 1
"0021900" 1 2 1 1 2 1 1 4 1 3
"0021951" 3 1 1 3 2 2 3 3 1 4
"0021900" 2 2 1 1 2 1 1 2 1 1
"0021900" 3 4 4 3 4 3 3 3 3 3
"0021900" 3 2 2 2 2 2 1 1 1 1
"0022000" 3 3 3 3 3 2 2 3 2 4
"0022000" 4 4 2 3 2 4 4 4 3 3
"0022000" 1 2 3 1 4 1 1 2 1 1
"0022000" 1 2 2 2 2 2 2 2 2 2
"0022100" 1 1 1 1 1 1 4 3 1 4
"0022100" 1 1 3 3 4 1 1 2 1 4
"0022200" 2 3 2 3 2 1 1 4 1 3
"0022200" 1 1 1 1 1 1 4 4 1 1
"0022200" 1 1 1 1 3 2 2 4 1 1
"0022500" 1 2 2 2 4 1 4 3 4 4
"0022500" 3 2 2 2 3 2 2 3 1 1
"0022500" 2 1 1 4 4 1 2 3 1 1
"0022541" 3 3 3 3 4 3 3 3 3 3
"0022500" 3 1 1 2 4 1 1 4 1 1
"0022600" 1 1 1 1 3 1 4 1 1 1
"0022600" 4 4 4 4 1 4 2 1 2 1
"0022600" 3 3 3 1 2 3 3 3 3 3
"0022600" 1 1 1 1 4 1 3 1 1 1
"0022750" 1 1 1 1 4 3 3 3 3 1
"0022942" 1 1 1 1 4 1 1 3 1 1
"0022942" 3 3 3 4 3 2 2 3 3 3
"0022942" 2 3 2 2 2 1 2 2 2 1
end
label values kp02A kp02
label values kp02B kp02
label values kp02C kp02
label values kp02D kp02
label values kp02E kp02
label values kp02F kp02
label values kp02G kp02
label values kp02H kp02
label values kp02I kp02
label values kp02J kp02
label def kp02 1 "1:Rarely or none (<= 1 day)", modify
label def kp02 2 "2:Some days (1-2 days)", modify
label def kp02 3 "3:Occasionally (3-4 days)", modify
label def kp02 4 "4:Most of the time (5-7 days)", modify
kp02E and kp02h are positives on the same scale.
The cutoff score is 16.

Thank you in advance!