User Community
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: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
JMP Bar Chart

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users

Learning Resources

Find courses, tutorials, and lots of other methods of learning JMP.

view all learning resources

Latest Discussions

  • Column Formula for summary value of group based on values in 2 other columns

    Hi everyone - I'm looking for a column formula that would return the following desired column below.  For simplicity in this post each group has 3 rows, but the dataset I currently have has groups with varying numbers of rows. Any help appreciated!  GroupTimeScoreFirst Time Failed (Desired Column)A1Pass8A3Pass8A8Fail8B1PassPassB2PassPassB6PassPassC1Pass3C3Fail3C7Fail3 

    user8421 user8421
    Discussions |
    Jun 4, 2020 5:08 PM
    3907 views | 2 replies

  • How do use JSL to quickly compare two sets of range columns in order to get the minimum of each column?

    The title is a bit hard to understand. Take this big class as an example:
    1. First, summarize the average values of "height" and "weight" by age.
    2. Then summarize the median of "height" and "weight" by age.
    3. Then compare the mean and median of "height" and take their minimum.
    Finally, compare the mean and median of "body weight" and take their minimum. I'll use the following code and finally loop t...

    lwx228 lwx228
    Discussions |
    Jun 4, 2020 3:49 PM
    3100 views | 4 replies

  • HTML import as data table issue

    I have been using the open() function for a HTML file. I'm now dealing with a column that has values such as "<2.4!".  when I use the open() function, it imports those values as "" in the data table. However, when I do it using prompts in JMP, after opening the html file, I'm able to open the html file using 'Import table as Data Table' and the correct value of "<2.4!" is imported. Is there a way ...

    danielharding0 danielharding0
    Discussions |
    Jun 4, 2020 2:01 PM
    2959 views | 4 replies

  • Unstacking a Stacked Excel Cell or Parsing Free-form Text to Generate Multiple Rows

    We all run into some version of this: Excel table formatted to look nice, no thought given to analyzability.In the free-form text cell, it looks like this: m/d: text [alt+enter]
    m/d: text [alt+enter]
    m/d: text [alt+enter]
    m/d: text [alt+enter]
    ...
    m/d: text [alt+enter] When the data are exported to JMP, the cell gets collapsed into: m/d: text m/d: text m/d: text ... m/d: text.
    I want to parse that long ...

    markschahl markschahl
    Discussions |
    Jun 4, 2020 11:47 AM
    3305 views | 3 replies

  • How to get partitioned sum of squares in ANOVA results of fit model

    Not just CTSS, SSmodel and SSE, I mean SS for individual predictors. How do I get it from fit model results? Thank you.

    ricardor ricardor
    Discussions |
    Jun 4, 2020 5:30 AM
    1740 views | 1 replies

Latest Discussions

  • HTML import as data table issue

    I have been using the open() function for a HTML file. I'm now dealing with a column that has values such as "<2.4!".  when I use the open() function, it imports those values as "" in the data table. However, when I do it using prompts in JMP, after opening the html file, I'm able to open the html file using 'Import table as Data Table' and the correct value of "<2.4!" is imported. Is there a way ...

    danielharding0 danielharding0
    Discussions |
    Jun 4, 2020 2:01 PM
    2959 views | 4 replies

  • How to get partitioned sum of squares in ANOVA results of fit model

    Not just CTSS, SSmodel and SSE, I mean SS for individual predictors. How do I get it from fit model results? Thank you.

    ricardor ricardor
    Discussions |
    Jun 4, 2020 5:30 AM
    1740 views | 1 replies

  • DATA WIDE TO LONG FORMAT

    Hi allI have data in wide format  i.e col  with  three variables: predicted, upper and lower and respective rounding options like round up of predicted, upper and lower, round down of predicted, upper and lower etc. which I want to  reorganize it in long format i.e  some constant rows like date and all of the value has to be reformatted into longer.I have attached the " have" and "want" data.Any h...

    sweetycha sweetycha
    Discussions |
    Jun 2, 2020 12:12 PM
    4389 views | 1 replies

  • Add rows every x rows

    Dear community, i've got a huge table and would like to add one row every 4 rows (4 rows data, adding 1 row, moving the rest of the data downwards, then adding 1 row after 4 rows of data aso).I have no clue how to achieve that with a script. Can anyone kindly help me with this topic?

    Sandra Sandra
    Discussions |
    Jun 2, 2020 11:52 AM
    4221 views | 7 replies

  • Autorunning the JMP script periodically

    Hi, I'm trying to automate my everyday task. I want the following script to run periodically and save the output. Can JMP auto select from the drop down list and save the output?For ex. Selecting a Age then selecting a Name and then saving the output for all the age from 12 - 17 Thanks

    Jackie_ Jackie_
    Discussions |
    Jun 2, 2020 8:54 AM
    2448 views | 4 replies

Latest Discussions

  • How do I have two different chart types in a single graph using two axis?

    While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot?    Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot.     To do this, first clear the row s...

    Bass_Masri Bass_Masri
    Discussions |
    Apr 28, 2020 4:28 PM
    4666 views | 0 replies

  • How do I calculate z-scores at different aggregation levels?

    Hello,  How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...

    Jmsouch Jmsouch
    Discussions |
    Feb 26, 2020 7:04 AM
    2217 views | 0 replies

  • Calling Windows API ImageViewer.dll to display JPG files.

    I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL.   ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...

    DMeakin1 DMeakin1
    Discussions |
    Jan 17, 2020 10:19 AM
    2022 views | 0 replies

  • Running script from command line on MAC

    Not a mac person.  Does anyone know how to run a jsl script from command line on a mac?  I specifically mean WITHOUT "//!" at the top of it.     I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl

    vince_faller vince_faller
    Discussions |
    Jan 10, 2020 2:26 PM
    1669 views | 0 replies

  • how to add confounding variable

    I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomous). 3- Y variables: insurance and practice (dichotomous) and time (continuous)I have one confounding variable Age (continuous). I will have to add random effect to X variable. But I am confused how to add confounding variable to this analysis. Can an...

    billi billi
    Discussions |
    Jan 6, 2020 9:39 AM
    1605 views | 0 replies
view all discussions

JMP Events

Sorrento, Italy 10-12 March
view all events
Latest Blog Post

Revolutionizing Spectral Baseline Correction in JMP: Harness the Power of Python Integration

JMP blog post photo
view all blog articles

Learn more about JMP's premier analytics conference