Publication date: 04/12/2021

Explore Outliers

The Explore Outliers platform provides options to identify, explore, and manage outliers in your univariate or multivariate data.

In the sample data table, several columns contain outlier values of 9999. Many industries use nines as a missing value code. The following example selects VDP_PCOLL, VDP_PINNBASE, and VDP_PINPBASE, the columns with the highest number of 9s, and adds the Missing Value Codes column property to the columns. The script then rescans the columns and removes these columns from the report.

dt = Open( "$SAMPLE_DATA/" );
obj = Explore Outliers(
	Quantile Range Outliers( 1 ),
	Show only columns with outliers( 1 ),
obj << Add Highest Nines to Missing Value Codes( :VDP_PCOLL, :VDP_PINNBASE, :VDP_PINPBASE );
obj << Rescan;
Want more information? Have questions? Get answers in the JMP User Community (