topic Re: Nested Recode in Discussions

Nested Recode

sciguy — Sat, 10 Jun 2023 23:49:39 GMT

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 )
);

Re: Nested Recode

txnelson — Wed, 15 Jun 2022 05:38:05 GMT

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",
			""
		)
	)
);

Re: Nested Recode

sciguy — Thu, 16 Jun 2022 00:06:26 GMT

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