cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
UserID16644
Level V

How to recode without prompt

Hi all, 

How can I use recode in JSL without this prompt?

UserID16644_0-1652335444233.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: How to recode without prompt

Let JMP script for you. If you have JMP16 run recode once and use enhanced log to capture the script:

jthi_0-1652341971922.png

or you could check if red triangle option allows you to save the script to script window for example:

jthi_1-1652342016924.png

 


Names Default To Here(1);
dt = Data Table("Big Class");
dt << Begin Data Update;
col1 = dt << New Column(dt:sex);
col1 << Set Name("sex 2");
dt << Move Selected Columns({col1}, after(dt:sex));
dt << Recode Column(
	dt:sex,
	{Map Value(_rcOrig, {"F", "FF", "M", "MM"}, Unmatched(_rcNow))},
	Update Properties(1),
	Target Column(col1)
);
dt << End Data Update;
-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: How to recode without prompt

Let JMP script for you. If you have JMP16 run recode once and use enhanced log to capture the script:

jthi_0-1652341971922.png

or you could check if red triangle option allows you to save the script to script window for example:

jthi_1-1652342016924.png

 


Names Default To Here(1);
dt = Data Table("Big Class");
dt << Begin Data Update;
col1 = dt << New Column(dt:sex);
col1 << Set Name("sex 2");
dt << Move Selected Columns({col1}, after(dt:sex));
dt << Recode Column(
	dt:sex,
	{Map Value(_rcOrig, {"F", "FF", "M", "MM"}, Unmatched(_rcNow))},
	Update Properties(1),
	Target Column(col1)
);
dt << End Data Update;
-Jarmo