cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest Discussions

  • How to interchange columns using JSL?

    Hi all, I have a CSV file that is being used in JMP. However, I need to interchange columns 1 & 2 with Columns 7 & 8. How to do it using JSL. It looks something like this:  Original File123456789 Interchanged columns783456129

    UserID16644 UserID16644
    Discussions |
    Nov 11, 2024 6:27 PM
    981 views | 3 replies
  • Formula to check if any of a list of items is contained in the rows of a column

    JMP for Mac Version 17.2.0 (701896) I have a column "Data" with rows of number_number like this:1_33_76_5... I want to test this column to see if some of the rows contain values from a list of values and then flag or label the rows which do. I know I could construct an elaborate formula like this:If( :Die X_Y == "3_9" | :Die X_Y == "3_4", 1, 0 )But that's very laborious for long lists of differe...

    datanaut datanaut
    Discussions |
    Nov 11, 2024 2:14 PM
    3520 views | 11 replies
  • How do I use the Col Maximum Formula with a "where" condition

    Hi, I have a problem where I want to formulate a new column as a benchmark to all other countries. If there are more rows for the country, I want to take the max value of it as the benchmark. See the example below for clarification. Data kind of looks like this:
    Country       Value         period       A                  10              201301         A                  30              201301      ...

    apploarcher apploarcher
    Discussions |
    Nov 11, 2024 2:03 PM
    21622 views | 19 replies
  • Script command to check whether a selection criteria returns >0 selected rows

    I'm looking for a scripting command that checks whether a selection contains >0 selected rows. The issue: subsetting a table of selected rows when none are selected, stops the script and returns an error message. I circumvent this problem by creating a column that sets selected rows to 1, then take col sum and run the if command (if col sum > 0, subset, don't subset). But that's clunky and for loo...

    Monomorphist Monomorphist
    Discussions |
    Nov 11, 2024 1:23 PM
    1190 views | 4 replies
  • Open JMP took longer time in JMP18.1 compared to JMP17.2

    Hello expert,   We have 5 PCs with JMP license - JMP 17.2. We just upgraded 1 license to JMP 18.1 for software & system testing. Observed that JMP 18.1 took longer time to open compared to JMP 17.2. The difference is almost 20 secs. (It's really troublesome because I need to open JMP during meeting with our management & they cannot wait additional 20 secs) Anyone else having this issue?   Why does...

    WebDesignesCrow WebDesignesCrow
    Discussions |
    Nov 11, 2024 10:12 AM
    3036 views | 9 replies

Latest Discussions

  • How to interchange columns using JSL?

    Hi all, I have a CSV file that is being used in JMP. However, I need to interchange columns 1 & 2 with Columns 7 & 8. How to do it using JSL. It looks something like this:  Original File123456789 Interchanged columns783456129

    UserID16644 UserID16644
    Discussions |
    Nov 11, 2024 6:27 PM
    981 views | 3 replies
  • How do I pass in a variable number of variables to a function as an array?

    I am hoping to make some functions I have a little more reusable as an example, I am creating a summary table with specific columns from my data set. I would like to pass in the columns list as an argument to allow me to have one "GetSummary" function rather than a "GetExperimentsSummary" and "GetCompoundsSummary" , but as these need different numbers of columns I need to be able to package the li...

    chappe chappe
    Discussions |
    Nov 11, 2024 9:46 AM
    580 views | 1 replies
  • Wait(0) vs Wait(n) vs Run vs Finish

    I have very large, and constantly growing data tables so I have issues with formulas not finishing. I wish JMP would just build in a mechanism to stop scripts from continuing until each line has finished but perhaps there is a reason for not doing this I'm not thinking of. I typically use a wait(n) command (e.g. wait(30);) however as the dataset grows I'm constantly having to update countless inst...

    RVhydrA RVhydrA
    Discussions |
    Nov 11, 2024 3:59 AM
    3994 views | 5 replies
  • How to get CV% for an unbalanced Precision study

    Hello JMP community, I have some data for Precision study with an unbalanced design. As shown below, there are ten runs performed with reagent lot 2 and 3 on two instruments (A and B). The fully automated instrument has three docks (locations) for the 96-well plate. The same sample was tested with 3 replicates in each of the ten runs by one operator. The goal is to calculate CV% for intra-run, int...

    Jinweidu80 Jinweidu80
    Discussions |
    Nov 11, 2024 1:36 AM
    1210 views | 3 replies
  • wilks lambada

    Hi I am trying without luck to run this test. I have a species (string) plus two data columns. I am getting no results. Can anyone advise?

    gw21 gw21
    Discussions |
    Nov 10, 2024 11:15 AM
    474 views | 1 replies

Latest Discussions

  • column and table selection

    The new Messages in Workflow Builder are great.
    Is there a possibility to pick a column from he current data table - or an open table?

     

    hogi hogi
    Discussions |
    Nov 7, 2024 10:31 AM
    380 views | 0 replies
  • Data Visualization in Virtual Reality

    Has anyone considered or have any interest in visualizing JMP plots (e.g., 3D scatter, surface) in virtual reality? I know there are several immersive VR programs (Arthur, Virtualitics, NVIDIA Omniverse) that can handle data and images generated from other program and I was wondering if anyone has made any attempts to do the same with JMP. Would love to hear back from anyone interested.

    PieBird215 PieBird215
    Discussions |
    Nov 7, 2024 9:58 AM
    593 views | 0 replies
  • Error add-in manager :AddinID == selectionID

    I am taking the above error once i click to build currently selected add-in button at the add-in manager.  Error Message: {"Send Expects Scriptable Object"(1, {23}, 2, "Send", here:addinTable << /*###*/get rows where(:AddinID == selectionID) /*###*/)} Error: Send Expects Scriptable Object 1 time(s). Data Table Indices: 23 Type: Error Function Name: Send Function being executed: here:addinTab...

    Georgios_Tsim Georgios_Tsim
    Discussions |
    Oct 29, 2024 6:41 AM
    537 views | 0 replies
  • JMP 18 Addins on Server - Change in Location

    FYI from JMP tech support:   If you are running JMP on a server, note that JMP 16 addins do not work for JMP 18 because the file paths have changed.  JMP is no longer part of SAS so the file path changed from C:\ProgramData\SAS\JMP\addIns to C:\ProgramData\JMP\JMP\addIns

    Changing your file path to C:\ProgramData\JMP\JMP\addIns will make addins visible for JMP version 18.

    pmroz pmroz
    Discussions |
    Oct 29, 2024 5:58 AM
    583 views | 0 replies
  • How do I replace a prediction expression in a fit model with a specific expression?

    Hi, I am completing a DOE and I have ran a fit model using the JMP software to define a design space based on desirability of certain variables, however one of the desirability variables is a simple ratio of two of the construct model effects, however when running the model, the model is defining its own prediction expression for this variable rather than using the formula in the data table. Does ...

    supermackie93 supermackie93
    Discussions |
    Oct 24, 2024 5:40 AM
    502 views | 0 replies
view all discussions