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

  • Join tables with like method (contains)

    hey, is it possible to join tables not with equal sign (=) but with like method (%) or something similar?
    for example: in one table I have column of names, in the second table I have column of parts of those name and i want them to match
    "america"--> "ame", "eric" ect...

    shiro shiro
    Discussions |
    Jan 12, 2022 11:17 AM
    2994 views | 8 replies
  • How do I join tables based on one fully matching column and one closest matching?

    Hi,  I would like to join two data tables via the 'join' function in JMP. I would like to join them based on time and reactor number. However, this is not working as the column 'time' has 8 decimals in one of the data files and the other one zero decimals.(How) would it be possible to match time on the closest matching point and reactor number exactly?I've already found some older discussions abou...

    Jekko Jekko
    Discussions |
    Jan 12, 2022 9:30 AM
    3668 views | 4 replies
  • Extract text from string

    Hi,If possible I would like extract particular text from the strings:\\swirt.misc@CAS-K-CLERK\K10447-Wit_OG lo hi TT-YYT (CTL1083.1)_172-7-10053 -303\\swirt.misc@CAS-K-CLERK\K10445-Wit_OG lo hi ES WERT (CIL0858.1)_172-7-10046-600\\swirt.misc@CAS-K-CLERK\K10437-Wit_OG lo hi TT-YYT (CTL1077.1)_172-7-10053-303\\swirt.misc@CAS-K-CLERK\K10420-Wit_OG lo hi ES TRTR (CMA0851.1)_172-7-10047-600\\swirt.misc...

    swiergi11 swiergi11
    Discussions |
    Jan 12, 2022 8:12 AM
    10117 views | 11 replies
  • Missing Specification Limits in Levey Jennings Control Charts

    Dear Community, For the process performance reports my colleagues and I create via JMP, we include a Levey Jennings control chart figure. We create this figure using the "Analyze"->"Quality and Process"->"Control Chart"->"Levey Jennings"-tool Oddly enough, even tho we specify the specification limits for the column(s) (and check the "show as Graph Reference Lines"), the figure will only show the c...

    N_Faust-BC N_Faust-BC
    Discussions |
    Jan 12, 2022 5:33 AM
    2683 views | 4 replies
  • How to add lines (specs, targets) to a histogram in graph builder while using local data filter?

    I have a lot of data (> 6,000) in one column for many different products. In another column I have product name and, in total, 12 different products covering these > 6,000 data.In graph builder I can make a basic histogram of all data and then use local data filter to see a histogram of the data only for the product selected. This works nicely but is incomplete because I want to view each histogra...

    scottahindle scottahindle
    Discussions |
    Jan 12, 2022 4:42 AM
    5259 views | 4 replies

Latest Discussions

  • Join tables with like method (contains)

    hey, is it possible to join tables not with equal sign (=) but with like method (%) or something similar?
    for example: in one table I have column of names, in the second table I have column of parts of those name and i want them to match
    "america"--> "ame", "eric" ect...

    shiro shiro
    Discussions |
    Jan 12, 2022 11:17 AM
    2994 views | 8 replies
  • Missing Specification Limits in Levey Jennings Control Charts

    Dear Community, For the process performance reports my colleagues and I create via JMP, we include a Levey Jennings control chart figure. We create this figure using the "Analyze"->"Quality and Process"->"Control Chart"->"Levey Jennings"-tool Oddly enough, even tho we specify the specification limits for the column(s) (and check the "show as Graph Reference Lines"), the figure will only show the c...

    N_Faust-BC N_Faust-BC
    Discussions |
    Jan 12, 2022 5:33 AM
    2683 views | 4 replies
  • How to add lines (specs, targets) to a histogram in graph builder while using local data filter?

    I have a lot of data (> 6,000) in one column for many different products. In another column I have product name and, in total, 12 different products covering these > 6,000 data.In graph builder I can make a basic histogram of all data and then use local data filter to see a histogram of the data only for the product selected. This works nicely but is incomplete because I want to view each histogra...

    scottahindle scottahindle
    Discussions |
    Jan 12, 2022 4:42 AM
    5259 views | 4 replies
  • How to extract the position of a char in a string?

    I have the following column, which contains string of char, such as dot or char (no number and special char).I want to generate a column that list out the position of the char which is not a dot. See an example below.Is there any formula or script I can use in JMP?? ·cgaagt··a···········           2,3,4,5,6,7,10
    ··t·a·············c··              3,5,19
    ·····················               

    JMP2021 JMP2021
    Discussions |
    Jan 11, 2022 11:15 PM
    2602 views | 2 replies
  • Cast selected columns into roles not showing

    I have a trouble with JMP16, hopefully someone has encountered and overcome this problem.While choosing commands, Cast selected columns into roles in Multivariate and correlations, the selected options are invisible. In other words command select the columns into roles, when i click on column name, then click Y,columns, the option doesn't display at all. Surprisingly it seem to invisibly select th...

    JustineK JustineK
    Discussions |
    Jan 11, 2022 11:02 PM
    948 views | 1 replies

Latest Discussions

  • How do I apply time fixed effects with multiple regression

    I have financial panel data and would like to hold dummy time variables fixed as I regress the other independent variables to test my model's significance. Not sure how to proceed. Is this function only available in SAS? Thanks   

    RiDe RiDe
    Discussions |
    Jan 10, 2022 11:18 PM
    699 views | 0 replies
  • separating labelled values from graph points

    I have looked in the scripting help section and all over this community and haven't found a solution for my problem so hopefully someone can help. I have a graph containing two trend lines and a bar graph and want to label the values of each point but when I set the labels both values show up on each trend line and I can't figure out how to separate the labels. I tried stacking the labelled column...

    Cdougz Cdougz
    Discussions |
    Dec 31, 2021 7:38 AM
    911 views | 0 replies
  • Expand Contours

    Hi, 

    I understand that the contouring is done based on triangulation to data points, but is there a method for expanding them further to fit a custom SHP file I've imported into JMP? I've already set the alpha and the lowest value so the contour should cover the, 'most', area. Any other methods? Thanks! 

    MikeDereviankin MikeDereviankin
    Discussions |
    Dec 15, 2021 12:49 PM
    709 views | 0 replies
  • Getting all Zeros for the AR(1) estimate/std error in a Repeated Measures Mixed Model Using JMP Pro

    I am fitting a model of a continuous response against 7 fixed effects. When running the Standard Least Squares; my residuals plots/assumptions checks don't look too bad but the Durbin Watson test is suggesting an AR(1) structure in the residuals. This is expected for this particular analysis and is consistent with other data sets looking at the same response/factors. The Time Series platform also ...

    lisa2442 lisa2442
    Discussions |
    Dec 14, 2021 7:32 AM
    872 views | 0 replies
  • Export Functional Data Explorer prediction formula

    Hi,I want to export the prediction formula generated by Functional Data Explorer either to Excel or Python (via Formula Depot), but there is a problem because the formula contains P Spline Coef() interpolation, which I think is not available in Excel or in Python libraries. Do you have any suggestions how to solve this?Best regards

    ruskicar ruskicar
    Discussions |
    Dec 14, 2021 2:11 AM
    829 views | 0 replies
view all discussions