SPSS Statistics

 View Only
Expand all | Collapse all

Select subset nominal variable to run multiple linear regression

  • 1.  Select subset nominal variable to run multiple linear regression

    Posted Sun January 09, 2022 03:41 PM

    Hello everyone,

    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

    Christopher



    ------------------------------
    Christopher Jönck
    ------------------------------


  • 2.  RE: Select subset nominal variable to run multiple linear regression

    Posted Sun January 09, 2022 05:04 PM
    It sounds like split files (Data > Split files) would be helpful here.  That would give you tables for each country.  However, the regression result suggests that you have at least one country where a variable is constant, including the possibility that all the values are missing for some variable and country.

    If you do descriptives split by country, that should help you spot the problem.

    --





  • 3.  RE: Select subset nominal variable to run multiple linear regression

    Posted Mon January 10, 2022 08:44 AM
    Edited by Rick Marcantonio Mon January 10, 2022 08:44 AM
    If you just want one country:

    GET FILE <whatever your SAV file is>.
    TEMPORARY.
    SELECT IF <country_variable_name_here>=<whatever_value_you_want - be sure to use quotes if this is a string variable>.
    REGRESSION <etc>.

    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------