cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
hogi
Level XII

"apply" value labels

When I remove a formula from a column, the calculated values stay.

When I remove a Value Labels Property from a column, the values switch back to the original values.

 

Is there an alternative remove (~ "apply") function for value Labels, which converts the data type of the column to character and keeps the Value Labels?

 

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

dt << New Column( "sex2",
	Formula(Recode(:sex,{Map Value( _rcOrig, {"F", "female", "M", "male"} )}));
);
dt:sex 2 << Delete Formula;

dt:sex << Value Labels( {"F" = "female", "M" = "male"} ) << Use Value Labels( 1 );
dt:sex << delete property( Value Labels );
1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: "apply" value labels

After you have Value Labels set

jthi_0-1683199060445.png

and you go to recode columns you will have an option for recoding them

jthi_2-1683199195598.png

jthi_3-1683199234242.png

this seems to replace the values with labels

 

-Jarmo

View solution in original post

3 REPLIES 3
txnelson
Super User

Re: "apply" value labels

Removed to reduce confusion.

 

Jim
jthi
Super User

Re: "apply" value labels

After you have Value Labels set

jthi_0-1683199060445.png

and you go to recode columns you will have an option for recoding them

jthi_2-1683199195598.png

jthi_3-1683199234242.png

this seems to replace the values with labels

 

-Jarmo
hogi
Level XII

Re: "apply" value labels

wonderful, thanks!