Hello fellow users,
My research focuses on investigating whether financial stress leads to lower self-confidence mediated by connectedness, with financial stress measured in a parent/married spouse/unmarried spouse/parent-in-law/housemate/family member. Self-confidence and connectedness are measured in the child living at home. Therefore, if the child living at home did not fill in the 'financial stress' variable, that is okay and I do not want to remove this. However, what I do want to remove are:
1. Any participant who has not filled in anything, resulting in missing values for financial stress, self-confidence, and connectedness.
2. The participant who is the child living at home (position=5) with missing values for self-confidence and connectedness.
3. The participant who is a parent (position=1)/married spouse(2)/unmarried spouse(3)/parent-in-law(4)/housemate(6)/family member(7) with missing values for financial stress.
What I have already tried is using `Select Cases -> If` and entering the condition `NMISSING(financial stress, self-esteem, connectedness) < 1`.
Alternatively, I also tried `Select Cases -> If` with the condition `NMISSING(financial stress) < 1 AND NMISSING(self-esteem) < 1 AND NMISSING(connectedness) < 1`. However, SPSS still selects participants who are missing values on any of these variables, rather than only selecting those missing values on all of these variables.
And I tried this: Syntax ->SELECT IF (positie = 5 AND MISSING(self-esteem)) OR
(positie = 1 AND MISSING(financiele_stress)) OR
(positie = 2 AND MISSING(financiele_stress)) OR
(positie = 3 AND MISSING(financiele_stress)) OR
(positie = 4 AND MISSING(financiele_stress)) OR
(positie = 6 AND MISSING(financiele_stress)) OR
(positie = 7 AND MISSING(financiele_stress)).
but spss didn't want to run it, it said:2 SELECT IF Incorrect variable name: either the name is more than 64 characters, or it is not defined by a previous command.