Arbitrary Recode Script

Paul_J

I have a character variable with an unknown number of levels.  The levels have long text names and I'd like to recode them into something shorter, such as just 1, 2, 3, etc... 

I understand how to use Match to recode a given set of levels to other specific values, but would like to ask how to do this if the initial set is unknown.  That is, for each new data file the variable to recoded may have a different number of different entries.

Thanks!

 

txnelson

Here is a small piece of JSL that gives an example of creating a numerical value from the character values found in a column

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

dt = New Column( "Animal Category",
	formula(
		If( Row() == 1,
			Summarize( bygroup = by( :species ) )
		);
		Loc( bygroup, :species )[1];
	)
);