Visual Binning or Complex Recode?

Discussion in 'SPSS' started by David Wade, Oct 25, 2011.

  1. David Wade

    David Wade Guest

    Hi! I could use some help with syntax to further define multiple
    ranges within an already defined range of values.

    What I'm looking for is a way to automatically separate a range of
    values into 3 equal groups, except the range of values within each
    existing grouping are not identical.

    For example, I have my values set up as...

    Level 1 = 475-643
    Level 2 = 644-662
    Level 3 = 663-693
    Level 4 = 694-780

    I want to split each level further into a High-Medium-Low. I've
    attempted to use the visual binning but I ran into difficulties
    because my cut-points are not identical within each level.

    Is there a way to have SPSS divide each defined range by thirds to
    achieve my H-L ranking? To make it even more complex, each set of
    defined ranges will be different depending on a separate variable.
    David Wade, Oct 25, 2011
    1. Advertisements

  2. David Wade

    Art Kendall Guest

    If you are trying to get 3 groups each with just about the same number
    of cases something like
    RANK variables = myvars by LEVEL /ntiles(3) into newvars.

    Weighting, ties, and the remainder when dividing the number of cases may
    result in some fuzz in the number of cases in each ntile.

    Do you want to use ntiles(12) ?
    RANK variables = myvars /ntiles(12) into newvars.

    Art Kendall
    Social Research Consultants
    Art Kendall, Oct 25, 2011
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.