510310_en-US

liliconcom

Nested Recode

Is there a way to nest a Recode on a single column based on multiple columns using JSL?

 

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");

dt << New Column( "Stature",
  Character( 40 ),
  "Nominal",
  Formula(
   Recode(
    :age & :height,
    {Map Value(
     _rcOrig, {
     "12" & "59", "short tween",
     "12" & "66", "Tall tween",
     "17" & "70", "Tall teenager"
     },
     Unmatched( empty() )
    )}
   )
  ),
 Set Display Width( 56 )
);

Data TableScriptingRe: Nested Recode

This worked perfectly. Should have gone with an if() function to begin with. Thank you.

Re: Nested Recode

I am not aware of the Recode having the capability you are asking about, however it is easily handled in an If() function

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << New Column( "Stature",
 Character( 40 ),
 "Nominal",
 Formula(
  If(
   :age == 12 & :Height == 59, "short tween",
   :age == 12 & :height == 66, "Tall tween",
   :age == 17 & :height == 70, "Tall teenager",
   ""
  )
 )
);