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

  • Add double quotes to a string

    Hi, How can I add double quotes using formula? "" || :Code || "" || ":" || "" || :Description || "" || ","  I try doing "", but it does not work. Thank you,Rami

    rshehadah rshehadah
    Discussions |
    Jan 8, 2019 6:32 PM
    4979 views | 1 replies
  • How to get a average for part of column data by using formula

    For example, I have a column:234506070would like to get the average for every 3 rows, and put the average in a new column in first row in every set by using formua, like this: 2  33450  606070  

    jasongao jasongao
    Discussions |
    Jan 8, 2019 4:35 PM
    7503 views | 3 replies
  • How to extract part of char string in a column by using formula

    For example, I have a char column Column 1Cordinate1:N23; Cordinate2:S45Cordinate1:S78; Cordinate2:N85Cordinate1:N67; Cordinate2:N90Cordinate1:S33; Cordinate2:S74 Now I am only interested in the infonation for Cordinate2 North, so I would like to create a new column by using some formula to extract the Cordinate2 N data. The results should look like this: Column 1                                  ...

    jasongao jasongao
    Discussions |
    Jan 8, 2019 2:11 PM
    11078 views | 5 replies
  • LAG function

    Hi All,  I'm hoping this is an easy line of code someone can help me with. I have a LAG function script written, but it's not letting me grab the first Run.  How can I get it to see that there's a Run 1, and not just skip it?Attached is the data. Thanks! Here's my script:Names Default To Here( 1 ); dt = Current Data Table(); dt << select where( :name( "Run" )[Row()] != Lag( :name( "Run" )[Row()] ...

    kwmcm kwmcm
    Discussions |
    Jan 8, 2019 12:50 PM
    5747 views | 2 replies
  • How to retain the cell color after saving the data table into journal or new window

    /* After save dt into Journal, the cell color from data data table was changed into the font color in the journal */ Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Color by Column( :age); Wait( 0 ); dt << Color Rows by Row State; dt<<save(); dt<< Clear column selection(); dt << clear select; win = New Window( "New Window", dt<<Journal);  

    wu wu
    Discussions |
    Jan 8, 2019 11:00 AM
    4171 views | 4 replies

Latest Discussions

  • How to retain the cell color after saving the data table into journal or new window

    /* After save dt into Journal, the cell color from data data table was changed into the font color in the journal */ Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Color by Column( :age); Wait( 0 ); dt << Color Rows by Row State; dt<<save(); dt<< Clear column selection(); dt << clear select; win = New Window( "New Window", dt<<Journal);  

    wu wu
    Discussions |
    Jan 8, 2019 11:00 AM
    4171 views | 4 replies
  • Stationariy time series

    I have a time series (Occ (%ocupation) vs. time stamp cfr. Time series model in annex) where the autocorrelation function shows a slow decay indicating non-stationarity, however the ADF test all are negative indicating a statationary Occ time series. Which criterion is right? I get extremely good resuts with ARMA as well as ARIMA (diffeferenced) models. Can I assess a non differenced (4,2) ARMA mo...

    frankderuyck frankderuyck
    Discussions |
    Jan 8, 2019 6:41 AM
    5713 views | 5 replies
  • How to plot different spec limit for different group

    For example: I have a data table including 2 columns:Value Group12  165  213  167 2Group 1 and Group 2 has different spec limits. How can I set them up and plot the corret spec limit in Graphic builder?Thanks! 

    jasongao jasongao
    Discussions |
    Jan 8, 2019 5:29 AM
    6193 views | 2 replies
  • Pairwise comparison on interaction term

    I would Like to know if Is it possibile and how to perform pairwise comparisons on an interaction term when this one Is between a categorica and a continuous variable. In Jmp I found only multiple comparison for the mai effect. Thank you.

    Sarettathepooh Sarettathepooh
    Discussions |
    Jan 7, 2019 6:51 PM
    19059 views | 6 replies
  • Can JMP Support Excel Formatting through JSL

    All, 
         Going through several different posts in the community on the topic, I believe I know the answer to my question. However, I will still go ahead and summarize the issue and see if anyone else has gone down this path.

         Problem Statement: Generate an Excel Workbook in a previously accepted and recognized template      Not for Debate : Why is Excel the chosen format of output 

        In going...

    uday_guntupalli uday_guntupalli
    Discussions |
    Jan 5, 2019 4:29 AM
    28291 views | 7 replies

Latest Discussions

  • I want to use LASSO and Group LASSO in JMP

    I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors.  I need to get JMP Pro before trying out JMP's implementation.  I'm doing all the analysis in R at present.  Does JMP Pro also include group lasso?  I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso.  F...

    gene gene
    Discussions |
    Nov 2, 2018 7:43 AM
    2412 views | 0 replies
  • Contingency table and mosaic plot are not same orientation

    // For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL ...

    Vball247 Vball247
    Discussions |
    Oct 29, 2018 2:18 PM
    3110 views | 0 replies
  • how to change the type and color of lines in graph

    I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can  be grouped by A1 & a, also can  be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1):  I use the follow script to change the type of lines:Dispatch( {}, "400", ScaleBox, {Legend Model( 8,...

    Yu Yu
    Discussions |
    Sep 25, 2018 2:34 AM
    3437 views | 0 replies
  • Mean separation letter from test slices

    Hello!

    How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...

    jfranc19 jfranc19
    Discussions |
    Sep 14, 2018 2:35 PM
    2327 views | 0 replies
  • repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

    Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...

    Reinaldo Reinaldo
    Discussions |
    Jun 18, 2018 6:31 AM
    3278 views | 0 replies
view all discussions