JMP Scripts

Latest Posts

• Simulation of "Fit All" for Normally Distributed Samples

  This script creates random samples from a normal distribution and finds the best-fitting distribution for each one, using the "Continuous Fit > All" option in the Distribution platform. The output is a data table with one row for each sample, showing the size of the sample and the continuous distribution with the best fit, as determined by lowest AICc value.See accompanying blog post: Is that the ...

  Jordan_Hiller

  JMP Scripts |

  Oct 1, 2016 5:09 PM

  3699 views | 0 replies

• PNMImport

  Years ago I worked with some file formats that were collectively known as PNM. They included PBM - Portable Bit Map, PGM - Portable Gray Map and PPM - Portable Pixel map, which is RGB pixels. Although those formats don't seem very popular these days, I recently came across a JMP user who is still using them and they wanted to read the files into JMP. JMP currently supports image formats like PNG a...

  JohnPonte

  JMP Scripts |

  Jun 1, 2016 12:40 PM

  2950 views | 0 replies

• Script to Insert Column(s) into the Middle of a Table

  Finally checked to see if someone had already posted something like this and didn't see it. It's an irritant to me (maybe not a rational one) that you have to use >Cols > Add Multiple Columns... dialog to simply add a column in the middle of a table. This script mimics Excel's long-time approach: select a number of columns, click a command to insert that same number of columns adjacent to the sele...

  jay_holavarri

  JMP Scripts |

  May 20, 2016 3:00 PM

  3234 views | 0 replies

• A Simple Script to Illustrate Axis Changes in One Chart Controling the Axis in a Different Chart

  // This Simple script illustrate a method to allow the axis settings from // one platform, to replicate the same settings in a different platform's // graph.// This example places both platform's utput in the same window, but// they could reside in separate window is that is what is desiredNames Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" );// Initialize Flagging Variables// Thes...

  txnelson

  JMP Scripts |

  May 10, 2016 10:45 AM

  4433 views | 1 replies

• Gauge Performance Curve Script

  This is a simple script to produce a Gauge Performance Curve.  This is a very useful visual way to show the results of a Measurement System Analysis.  The limits are usually your specification limits.  s comes from your MSA.

  wilkap

  JMP Scripts |

  Mar 25, 2016 9:32 AM

  3017 views | 0 replies

• Delete Empty Columns

  This JSL script will delete empty data columns.

  robot

  JMP Scripts |

  Jan 27, 2016 1:51 PM

  12584 views | 4 replies

• Delete Duplicate Rows

  This JSL script will delete duplicate rows in a data table.  The first unique occurrence of each row is preserved.

  robot

  JMP Scripts |

  Jan 27, 2016 1:48 PM

  8484 views | 1 replies

• Parse Column

  This JSL script will parse a selected column by user specified delimeter(s).

  robot

  JMP Scripts |

  Jan 27, 2016 1:42 PM

  3465 views | 1 replies

• historicalDate.jsl

  //*****************************************************FUNCTION*****************************************************************//// Title: returnhistoricalDate //// Description: return date x years //// Inputs: numYears //// Output: Date - x years //// class: date //// version 1.0 //// //// developed by: alex.cook0 ////==============================================================================...

  

  JMP Scripts |

  Jan 22, 2016 3:05 AM

  2674 views | 2 replies

• Control Chart Report by Exception: Sort through many charts to find the few with test alarms

  Report by Exception using IR Control ChartsReporting by exception may be just a little counterintuitive for checking control charts?A key concept of control chart review is that a person actually looks at each chart. This howevergets a little tedious with the daunting task of frequently reviewing hundreds of process variablesthat typically contain few special cause events. For reviewing many contr...

  Byron_JMP

  JMP Scripts |

  Sep 4, 2015 1:48 PM

  3453 views | 1 replies

• Error trapping for Oracle ODBC SQL

  The log_execute_sql utility executes Oracle SQL statements and looks in the log for any errors.  If errors are found they are displayed in a message box.  There is a debug flag that, when turned on, will display the SQL statement before execution.  For JMP 11 and above needs the log window open, settable via a preference (see comments below).Function Name: log_execute_sqlDescription:       Execute...

  pmroz

  JMP Scripts |

  Jul 2, 2015 6:41 AM

  3397 views | 0 replies

• Data Table Support for Images in JMP 12 (Supporting Files)

  After unzipping the files, open the data table and run the script. A summary table will be created, with an expression column that houses a different graph in each row. Since the graph column has the label property turned on, hovering on a given row's point in a graph will display the row's image.NOTE: Requires JMP 12.

  brady_brady

  JMP Scripts |

  Jun 2, 2015 12:03 PM

  3368 views | 0 replies

• Demo Hough transform 2

  Demonstrate how the Hough transform accumulates hotspots at given angles and positions. You click in points in an x-y space and it accumulates the Hough transform for those points. Click points in a line, and it creates a hot spot.

  John_Sall

  JMP Scripts |

  Mar 26, 2015 12:59 PM

  2881 views | 0 replies

• Demo Hough Transform 1

  The script demonstrates the fixed points of a curve that is the Hough transform for points you click on. Cllick and drag around an x-y space, and it shows the Hough function. As you drag in staight lines, you understand that the function is fixed at a certain angle and position.

  John_Sall

  JMP Scripts |

  Mar 26, 2015 12:55 PM

  3261 views | 0 replies

• JSON Parsing Functions

  This JSL file contains functions for converting JSON text into either a JSL data structure or a JMP data table. JSON represents a structure of nested "arrays" and "objects". JSON types/values are represented as follows in JSL:    JSON   JSLNotesarraylistsequence of valuesobjectassociative arrayset of named valuesnumbernumberstringstringtrue1.0false0.0null.missing valueWhen converted to a JMP data ...

  XanGregg

  JMP Scripts |

  Dec 29, 2014 2:15 PM

  12773 views | 2 replies

• Robust statistics for interlaboratory comparison data processing

  This script was developed for the processing of interlaboratory comparison data by robust statistics.It calculates the robust mean, the robust standard deviation, the standard uncertainty of the robust mean and the statistics of performance according to ISO 13528 standard.

  cedric_rivier

  JMP Scripts |

  Nov 19, 2014 1:53 AM

  2734 views | 0 replies

• Fill in Missing Cells

  Report tables often end up having incomplete columns where labels need to be copied to the sequential cells below until the next label where the process is repeated again and again. The Excel Import Wizard has an option to deal with spans of missing cells that are merged. This script can be used after the data is imported and it doesn't require the spans of missing cells to be merged.I've been usi...

  Byron_JMP

  JMP Scripts |

  Jul 28, 2014 8:35 PM

  17870 views | 13 replies

• Solving a Problem with the JSL Debugger Demo Script

  This is a sample script used in a JMP blog post about the JSL Debugger (Solving a Problem with the JSL Debugger). Please read the blog post for more information. This script has no use outside of the blog post.

  Melanie_J_Drake

  JMP Scripts |

  May 30, 2014 1:17 PM

  2578 views | 0 replies

• Sample Size to Achieve Normality

  A common rule of thumb is that a sample size of 30 is sufficient to assure that the sum of random variables is normally distributed by the Central Limit Theorem (CLT). The sample size depends on the skew of the population. So the uniform distribution, which is neither normal nor skewed, requires a relative small sample size for the sum of the sample to be approximately normally distributed. This s...

  Mark_Bailey

  JMP Scripts |

  May 29, 2014 12:55 PM

  4538 views | 1 replies

• Visualize Reliability Distribution Models

  This script presents many distributions that are used to model life data in a reliability or survival analysis. Most of them are available in the Life Distribution platform (Analyze > Reliability and Survival > Life Distribution).Simply run the script to begin. The four important distribution functions are presented in separate plots of the graph of each function: Failure (CDF), Survival (1-CDF), ...

  Mark_Bailey

  JMP Scripts |

  May 29, 2014 12:46 PM

  5168 views | 2 replies

• Loan Comparison Script using SAS PROC LOAN

  Originally created for demonstration at the 2007 JMP User Conference, this script is intended as an example and not as a full-fledged loan comparison tool. Be sure you understand how it works and its limitations before relying on any information produced. It does not reflect the full capabilities or features of PROC LOAN.This sample demonstrates:Creating a JSL-based user interfaceGenerating SAS co...

  jschroedl

  JMP Scripts |

  May 29, 2014 5:58 AM

  3093 views | 0 replies

• Report Template Tutorial

  ​Learn how to create report templates that link to graphics files produced from JMP reports. Each time you open the template, the most recent version of the graphics files are used.Goes along with this blog.

  brady_brady

  JMP Scripts |

  May 28, 2014 10:07 PM

  6855 views | 2 replies

• JSL for R Interface

  Two scripts generated using JMP interface to R by Chris Kirchberg chris.kirchberg.  Also see a short demo by Kelci Miclaus kelci.miclaus on JMP integration with R.

  Chris_Kirchberg

  JMP Scripts |

  May 28, 2014 12:21 PM

  3779 views | 0 replies

• Pseudo Failure Time Script

  PurposeThis script takes a repeated measures data table (a table with multiple rows per unit)and turns it into a data table with 1 row per unit and a Pseudo Failure time. The original data table must contain:1) A column that identifies each unit, 2) a variable that measures time (can be use such as miles driven), and 3) a response column.
  UsageSimply run this script by any one of these methods:  E...

  melinda_thielba

  JMP Scripts |

  May 27, 2014 10:18 AM

  3952 views | 1 replies

• Nonlinear Degradation Mixed Model

  JMP does not have a facility for fitting nonlinear mixed models, but this script can be helpful in invoking the SAS PROC NLMIXED to do the work, using the model formulas in from JMP. With degradation analysis you need to import back the estimates and plug them into a model , and invert the model to produce crossing times.  The documents include a journal, the script, and sample data sufficient to ...

  John_Sall

  JMP Scripts |

  May 27, 2014 10:00 AM

  3350 views | 0 replies