I am trying to compare correlations between subgroups of a variable. For instance, I am trying to compare the income of group 1 v. income of group 2 v. income of group 3 v. income of group 4, where the groups are specified by another categorical variable.
What I did was create new variables separating out the income variable into four new variables (i.e. income_1, income_2, income_3, income_4). Naturally, there are missing values that look something like this (each bracketed portion represents a new line where the '.' represents missing values):
[income_1 income_2 income_3 income_4] [1 . . . ] [1 . . .] [. 2 . .] [. 2 . .] [. . 1 .] [. . 1 .] [. . . 2] [. . . 2]
So when I try to perform
correlate on these four values, I get an error that says 'no observations' probably because
correlate performs listwise or pairwise deletion.
How can I fix this problem? I don't know how to get rid of the missing values.