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;
Related Posts with conditionally check if 2 column clusters have no missing values
How to avoid duplicates using rangejoin?- Filling a time-invariant dummy variable down for new years in panel data after expanding a dataset
- Creating treatment and control groups for regression model
- Transpose (rotating) data by group (variable)
- Latent class analysis (LCA) plugin - assertion is false -error
Subscribe to:
Post Comments (Atom)
0 Response to conditionally check if 2 column clusters have no missing values
Post a Comment