nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

What does "Script sequence of actions" do when using Standardize Attributes/Recode?

JerryFish

In single-column recode, if you specify "Formula Column", you get a nice formula containing your recode script.

The option to Script Sequence of Actions is there when you recode via Standardize Attributes as well, but where does the script end up? There is no "New Column/Formula Column/In Place" option, so what does this option do?

Thanks!

Accepted answers

Ross_Metusalem

Hey Jerry, I believe you can grab the script by publishing to Formula Depot and then choosing [Show/Copy] Script under the RT. That script can be dropped back into a column formula with a couple modifications (copy just the Recode() function portion and specify the column name). Would be a nice addition to be able to save directly to column formulas like in single column recode.

ErnestPasour

The existence of those controls is an oversight. I have removed both Publish and the extra checkboxes in the 15.2 release. The same recode dialog is used for the normal single-column case and for standardize attributes (and for recode in Text Explorer). Those extra UI widgets were left inadvertently.

All comments

Ross_Metusalem

JerryFish

Thanks Ross. Since Formula Depot is Pro only, I'm guessing the Scripting option under Recode must be disabled for standard JMP? So (short of writing a custom script in JSL) there's no way for standard JMP to save the Recode script from Standardize Attributes. Or am I missing it?

Jeff_Perkinson

According to the documentation for Recode:

Script sequence of actions

Attempts to save your actions to a script and omit the data, For example, if you convert all strings to uppercase using the red triangle option, the generated script contains code that converts input strings to uppercase without including the data.

Perhaps @ErnestPasour can shed more light, and @sheila_loring can incorporate that light into the doc.

Ross_Metusalem

That's my take on it too, though it seems like saving the recode script when using Standardize Attributes shouldn't be limited to Pro. I suppose a workaround is to recode a single column to a formula column, copy that formula and use Standardize attributes to drop it a group of empty columns, and then use the Substitute Column Reference option to reference all the other columns that still need recoding. Not the easiest solution, but it should get the job done.

ErnestPasour

Ross_Metusalem

Would it be possible in a future release to include the option to recode to formula columns when recoding from standardize attributes?

ErnestPasour

Perhaps. I have to figure out how it should work in various cases (save to formula column vs. save to script window, for instance). But it should be possible.

mia_stephens

There's an open defect for this: http://sww.sas.com/defects/java/iDefects/WebClient.html?defectid=S1502438

We're past feature freeze for 16, but possible for 17. As this is a feature request, @Ross_Metusalem, can you please post on the Internal Wish List?

Thanks!

Ross_Metusalem

Thanks for the reminder, @mia_stephens. Done!