cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
JC7
JC7
Level I

How do I automatically exclude rows including outliers as identified by the "Explore Outliers" function?

Created: Jan 21, 2021 08:59 AM  |  Last Modified: Jun 9, 2023 3:03 PM (4424 views)

Hi there,

 

I am looking to replicate what I do manually in JSL script.

I know how to run the "Explore Outliers" function in JSL but I still have to manually select the rows with outliers identified by the "Explore Outliers" then press 'select rows' then press 'exclude'.

I am trying to build a script which I run and automatically excludes the outliers identified without me having to do anything else (ideally does not even open up the Explore Outliers window.

 

Anyone got any ideas?

 

Thanks!

0 Kudos
10 REPLIES 10
txnelson
Super User txnelson
Super User

Re: How do I automatically exclude rows including outliers as identified by the "Explore Outliers" function?

Jan 28, 2021 08:54 AM (444 views)  |  Posted in reply to message from JC7 01-28-2021

You have made a very common error.  The first time you run 

el = Explore Outliers(

it is pointing to  the "dt" data table. However, by the time you go to run the second time, you have created a new data table "dtQuant", which is not the current data table as far as JMP knows.  And of course, it will not find outliers.  To fix this, all you need to do, is to force JMP to make sure it is pointing to the correct data table.

el = dt << Explore Outliers(

On another topic, using "j" as a variable name can sometimes run one into issues.  JMP has a function called j.  Even though you can have a variable called j, it can make reading the code confusing.

Jim