I have to work on a big data, including several countries and variables.
I wish to explore within a specific country before looking for variations/differences between all the countries. All countries have been attributed a value in the data file. Thus, I "selected cases" and computed "if..." condition with the specific value suiting the country of interest. It does work as to provide descriptive statistics. However, when I want to run multiple linear regression, it indicates that the variable is constant or has missing correlation. I thought of creating a dummy variable so that spss can work with values (1 and 0), but couldn't compute further as it would not exclude the non-corresponding countries.
I am a bit stuck, do you have any suggestion? I am fairly un-experimented with SPSS (and stats overall), sorry if this seems like a trivial question. I try to find solution as most as possible before asking for help.
Thank you in advance