Hi, I have a dataset below that has 6 columns .

I would like to check if [ not missing in any of the columns in A B C] and [not missing X Y Z ] then a new column should be created which get a value 1, otherwise it get a value 0.

input str10(A B C X Y Z)
"Yes" " " "No" "Yes" "Maybe" "Sometimes"
"No" "No" "Maybe" "Yes" "Yes" "Yes"
" " "Yes" "No" "Sometimes" "No" " "
"Yes" "No" " " "No" "Sometimes" "No"
"Yes" "Yes" "Sometimes" "No" "No" "No"
" " " " " " " " "" ""
"Sometimes" "No" " " " " " " " "
end;