To label outliers and export to Excel spreadsheet

[#1]

Good day, can you help with a question in exporting/labeling ourliers?

As the screenshot, the Outliers were identified by using Analyze > Screening > Explore Outliers. They are excluded in the table. How can I export the data into an Excel spreadsheet with these Outliers identified, (for example in a new column)

Thank you.

[#2]

This script shows the steps:

NamesDefaultToHere(1);

// Get some data and make some 'outliers'
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << selectRandomly(10) << Exclude;
dt << ClearSelect;

// Maake a new 'row state' column
oc = dt << NewColumn("Outliers", Row State);

// Copy the current row states to this column
oc << CopyFromRowStates;

// Export to the desktop
dt << Save("$DESKTOP/Big Class.xlsx");

Interactively, you need 'Cols > New Columns...', then click on the star next to the column name (in the Columns Panel) and 'Copy from Row States'.

[#3]

@ian_jmp , thank you!

but seems I don't have a star next to the column name?

[#4]

Change the 'Data Type' of the column to 'Row State' using the drop down list.

[#5]

To add to Ian's reply, once you have the row state column and have copied the row states to that column using the red star in the columns panel and Copy from row states, you might want to make one more column that reads the row state column and returns a 1 or 0 based on the Excluded state.  

The formula Excluded under the Rows State group in the formula editor will return a 1 or 0 based on the row state column having the Excluded option. 

Otherwise, when I tried to copy JMP data back to Excel it gives a code of the color or the color and excluded property that was not as easy to interpret as a 1 and 0. 

[#6]

@ian_jmp @ledi_trutna thank you both so much for the help.

however I still don't able to get it. it gives an empty solumn when "save as...".

[#7 · Accepted solution]

Sorry to not be sufficiently clear.

Once you have made your 'Row State' column ('Column 3' in your case), did you actually move the current row states to this column using the 'star' icon mentioned above? From your screenshot, it looks like, for example, row 6 has been excluded, yet this row for 'Column 3' might be empty (shown as a '.') - But it's a bit hard to tell because the column name is truncated in the middle image . . .

[#8]

@ian_jmp not at all and thanks again! finally I got it.

left clicked the new column, choose "Copy from Row States", the marks appear in the column. Saved it as Excel, the rows are labled with "2".