JMP Scripts

Latest Posts

• Tab structured layout in a Journal

  JMP Journal files are very handy for presentations  and that is what I’m using for each of my seminars. Sometimes they can be very long and overwhelming.  An idea would be to have a tab structured layout. I mean by that to have several Tabs in a Journal file so that the presentation can be separated in different sections. Here an example. This is simple to do: 1. Write a script as you would do a ...

  Valerie_Nedbal

  JMP Scripts |

  Oct 20, 2022 5:01 AM

  2113 views | 1 replies

• Integrating Google Drive with JMP using HTTP Request

  The hardest part of integrating with Google Drive is creating a web application using the Google Console.   It is well documented. However, since the scope required for accessing Google Drive is more sensitive than say, JMP’s Google Sheet integration, integrating with Google Drive is not currently part of JMP as of JMP 17. That being said, I ran into a JMP user during the recent JMP Discovery tha...

  bryan_boone

  JMP Scripts |

  Sep 16, 2022 2:25 PM

  1590 views | 0 replies

• Grubbs' Outlier Test (Version 2)

  (This script is a new version that provides By group processing. Finally! Note that the p-value reported in the first version is no longer available.)This script adds the two-tailed outlier test by Grubbs to the Distribution platform. The normal quantile plot and Goodness of Fit test are opened to help assess the assumption that the sample was drawn from a normal population.Simply open the data ta...

  Mark_Bailey

  JMP Scripts |

  Sep 12, 2022 7:44 AM

  21322 views | 5 replies

• Run queries in background, wait for them to complete, and reference them in the remaining JSL script

  You want to run queries in the background but need to interact with the results.  This method lets multiple background queries complete before interacting with the results.

  ih

  JMP Scripts |

  Aug 30, 2022 9:49 AM

  4900 views | 5 replies

• Delete Empty Columns

  This JSL script will delete empty data columns.

  robot

  JMP Scripts |

  Apr 7, 2022 1:58 PM

  11819 views | 4 replies

• JMP and MATLAB White Paper Sample Scripts

  2018-04-06 Added a .zip file, which includes the journal, data sets and samples scripts, which can be run directly from JMP with a version of MATLAB installed.   These sample files are the .jsl and .m files referenced in the white paper: JMP and MATLAB Info Kit.   Abstract:
  Extensibility is one of the hallmarks of JMP. Beginning with JMP 11, the provisions exist for integrating JMP with MATLAB. ...

  Daniel_Valente

  JMP Scripts |

  Mar 21, 2022 12:00 PM

  10249 views | 7 replies

• Fisherのz変換にて相関係数のp値や信頼区間を求めるプログラム例

  添付の資料では、JMPスクリプト言語の概要をまず説明し、そして、Fisherのz変換近似を行う方法を概説しています。   添付のスクリプトは、その一例です。   日本語版JMPでしか動作しません。

  yusuke_ono

  JMP Scripts |

  Mar 16, 2022 1:10 AM

  1584 views | 0 replies

• Confidence Interval for the Coefficient of Variation (CV)

  (Please note that this script is a new version that provides an optional By role as of 10Jul2014.)This script opens a Distribution platform and adds the confidence interval for the coefficient of variation to the report. Simply open the data table with the columns to be analyzed and then open and run the script. Select the columns for analysis and click Y, Response. Select the grouping column and ...

  Mark_Bailey

  JMP Scripts |

  Dec 30, 2021 12:48 PM

  10535 views | 3 replies

• Example p'-prime chart script (Constructing p'-charts or Laney p-charts)

  Constructing p'-charts or Laney p-charts in JMP   The attached script will calculate the control chart sigma and generate a p-chart with the calculated sigma. The p-chart platform in JMP has a default 3 sigma set in the launch dialog. In certain cases sigma of 3 is too restrictive and larger values of sigma are prefered. The p'-chart is used for cases where the proportion of defects is low, becaus...

  Byron_JMP

  JMP Scripts |

  Dec 6, 2021 11:41 AM

  22579 views | 4 replies

• Parse Column

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

  robot

  JMP Scripts |

  Sep 28, 2021 3:46 AM

  3357 views | 1 replies

• Find & Replace for Column Names

  A stupid little script to replace/remove text from the names of selected columns. Select columns to change, run script, follow prompts.

  MarkDayton

  JMP Scripts |

  Aug 16, 2021 10:44 AM

  5395 views | 6 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 |

  Aug 14, 2021 7:44 AM

  4196 views | 1 replies

• Anaconda Environments Integration

  Using Anaconda virtual environments to access your Python dependencies.

  nascif_jmp

  JMP Scripts |

  May 25, 2021 11:34 AM

  5283 views | 5 replies

• Combine multiple txt or csv files

  This script will combine multiple txt or csv files into one file. The script asks for a target directory, opens the first file and then iteratively adds the subsequent files to the first using the Table Concatenate function.  One new column is created in the final file: this column will contain the name of the file that each row came from. If all the the text files have the same (identical) column...

  Byron_JMP

  JMP Scripts |

  Apr 30, 2021 4:06 PM

  35375 views | 21 replies

• In List Select Where Script

  In List to select a variable length list of items from a column.  Similar to the In function in SQL.

  Jim_Gillard

  JMP Scripts |

  Mar 3, 2021 8:54 PM

  2712 views | 2 replies

• Seaborn-Inspired Modern Styling

  Beige is totally out! A color theme for JMP that mimics the Seaborn library from Python.

  Michael_MXAK

  JMP Scripts |

  Mar 3, 2021 8:52 PM

  1795 views | 1 replies

• Export to HTML with Pass/Fail Coloring

  This script exports the data table to HTML setting the cell's background color based on a threshold value (2000). Green > 2000; Red <=2000.Only cells in columns 3 and above are colored, but this number is commented in the script so it can easily be adjusted. The colors and threshold values are also marked with comments so they can be changed.The output is sent to the log. To create an HTML file, c...

  John_Powell_JMP

  JMP Scripts |

  Jan 28, 2021 3:53 AM

  7893 views | 3 replies

• LP Solver

  Use JMP Linear programming (LP) Solver to optimise a function subject to a set of linear constraints.

  David_Burnham

  JMP Scripts |

  Jan 15, 2021 9:55 AM

  12274 views | 5 replies

• Box Plot Line Color Black

  This is the script referenced in step 9 of ISQC Example 6.1 Flow Width New Data Added, in Chapter 3 of the book Douglas Montgomery's Introduction to Statistical Quality Control: A JMP.

  ZenEos

  JMP Scripts |

  Dec 1, 2020 5:12 AM

  829 views | 0 replies

• How to write self-updating JMP add-ins

  Setting up an ‘Add-in Depot’ makes it easy to administer a collection of self-updating JMP add-ins. In this example, the Depot is nothing more than a folder containing:The JMP add-in file “com.jmp.brady.addin1.jmpaddin”.A metadata file, “File Metadata.jmp”.In a typical case, the add-in depot will reside on a server folder where add-in users have read access.The metadata file is a JMP table that st...

  Jeff_Perkinson

  JMP Scripts |

  Oct 13, 2020 11:49 AM

  11206 views | 3 replies

• Word Counts to Columns

  This script counts the number of occurrences of each provided word, then creates individual columns with the number of occurrences for each word.UsageFirst download wordCountsv005.jsl from the bottom of this page1. With your data table open, run the attached script2. Select your column of text in the list of columns, then click "Text Column" to enter it in that role3. Enter the words you wish to c...

  julian

  JMP Scripts |

  Sep 3, 2020 2:15 AM

  11545 views | 1 replies

• Kappa Study for VI operators.

  Hai everyone, here I attached the JMP script and one PDF document to learn how create an attribute chart. it will be useful for the beginners.

  Raj

  JMP Scripts |

  Aug 28, 2020 6:46 AM

  1017 views | 0 replies

• Census Data Import Example via HTTP Request

  JMP intern Katherine Li developed this script to read in public census data tables.  You can extend this script to read in whatever updated census information that you'd like.  This particular example loads data from the American Community Survey of demographics that is done every 10 years.   You will need an API key from the Census Bureau to run this sample.    Also, there is a JSON file included...

  briancorcoran

  JMP Scripts |

  Aug 24, 2020 6:28 AM

  867 views | 0 replies

• Open JMP Data Table from Microsoft OneDrive

  JMP intern Katherine Li developed this script to connect to a personal Microsoft OneDrive folder, download a .JMP file using the built in browser download facility, and then open it in JMP taking advantage of the file associations with .jmp files.   To use this, though, you will need to obtain a client ID and secret for your organization.  For a personal account, this might not be a problem.  For ...

  briancorcoran

  JMP Scripts |

  Aug 21, 2020 6:26 AM

  1529 views | 0 replies

• Querying World Bank Data through HTTP Request

  JMP intern Katherine Li developed this script to query CO2 levels from the World Bank. The World Bank does not require an API Key. This shows the usage of JMP's HTTP Request service. The World Bank includes some regional data that JMP does not understand, so you'll need to delete the top rows until and including "World". Then you can run the attached Graph Builder script to create a map with Colum...

  briancorcoran

  JMP Scripts |

  Aug 19, 2020 8:28 AM

  1406 views | 1 replies