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: 
  • 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
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: 

Learning Resources

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

view all learning resources

Latest Discussions

  • Counting number of values or words in each column

    i have a data set and i want to count the number of "OK" and put the calculate value at the bottom of the row for each column.

    For example:abacadOH;OC;OKOKOH;OC;OKOKOH;OC;OKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOK699For(i=1,i<=NCol(dt),i++, Column(dt,i)[NRows(dt)] = Char(N Rows( dt<< get rows where( As Column(dt,i) == "OK"))); )
    I was using the code above but it seems to not let me put the value in f...

    jearls11 jearls11
    Discussions |
    Feb 13, 2024 5:34 AM
    2174 views | 3 replies

  • How to prevent Milliseconds from disappearing during Import Data from Database?

    Hello,  TLDR: Is there a way to keep milliseconds when data is imported from a database? Import JSON, timestamp milliseconds all turn into 0's. JMP 16.2/17.0 I currently have a JSL script that pulls json data from a database ex ->  Data Table(open database(dsn_string, sql_string, table_name, Invisible(1)));  This script has been working with no issues except that the granularity of the timestamp c...

    Glo_Roh Glo_Roh
    Discussions |
    Feb 13, 2024 4:26 AM
    1975 views | 3 replies

  • How to loop when querying date?

    Hi allI am trying to query the database using JMP. In my query, I manually change the dateNow value from day 1 to 30 then run the script. But I needed to create another one that would loop all through the days. How can I create a loop that queries every date starting from July 2023 to January 2024? dateNow = "01/11/2024"; dt = Open Database( "DSN=databasename;UID=root;PWD=admin;APP=JMP;DATABASE=d...

    UserID16644 UserID16644
    Discussions |
    Feb 12, 2024 10:58 PM
    1366 views | 2 replies

  • Concatenate a string to an integer.

    Hi. I'm trying to create new columns with the same name, but different extension. For example, I'm trying to create column 1 & column 2 &column 3... etc.  Here is what I have:  lista = list(1 , 2, 3 , 4);  for(i1=1, i1<N Items ( lista)+1, i1++,  dt_limit << new column (    insert( "condition", char ( lista(i1) )  )    ); );  it doesn't seem to work, however. It either returns an error or retur...

    RA899 RA899
    Discussions |
    Feb 12, 2024 6:00 PM
    1309 views | 2 replies

  • Predictor Screening

    I am trying to use the predictor screening platform and though I have walked through the example on JMP, but I still have questions. I put my response variable in a yes, no format like the example; however, when I look to see which variables are the best predictor of the response how do I interpret the results? Is the number #1 ranked variable the best for predictor for a "yes" outcome or a "no" o...

    barr26 barr26
    Discussions |
    Feb 12, 2024 4:36 PM
    1419 views | 1 replies

Latest Discussions

  • How to prevent Milliseconds from disappearing during Import Data from Database?

    Hello,  TLDR: Is there a way to keep milliseconds when data is imported from a database? Import JSON, timestamp milliseconds all turn into 0's. JMP 16.2/17.0 I currently have a JSL script that pulls json data from a database ex ->  Data Table(open database(dsn_string, sql_string, table_name, Invisible(1)));  This script has been working with no issues except that the granularity of the timestamp c...

    Glo_Roh Glo_Roh
    Discussions |
    Feb 13, 2024 4:26 AM
    1975 views | 3 replies

  • Predictor Screening

    I am trying to use the predictor screening platform and though I have walked through the example on JMP, but I still have questions. I put my response variable in a yes, no format like the example; however, when I look to see which variables are the best predictor of the response how do I interpret the results? Is the number #1 ranked variable the best for predictor for a "yes" outcome or a "no" o...

    barr26 barr26
    Discussions |
    Feb 12, 2024 4:36 PM
    1419 views | 1 replies

  • Scheduled job failed

    Hi, I'm trying to run daily scheduled job, but keep getting failing error "Process is terminated due to StackOverflowException".What might be the reason for this?

    shaiv90 shaiv90
    Discussions |
    Feb 11, 2024 11:09 PM
    706 views | 0 replies

  • How to have both error bars and value labels on clustered bar chart?

    Hello, this is the current graph I have. I want to include both the error bars and the value labels for the mean, but they are overlapping. Is there anyway I can move the value labels slightly higher so they do not overlap with the value labels? Alternatively, if anyone knows how to make a caption box instead of stacking the numbers vertically have them go horizontally, that would work too. Thanks...

    libjuno libjuno
    Discussions |
    Feb 11, 2024 6:17 AM
    1415 views | 1 replies

  • I'm Confused About Variables

    I'm having a conceptual problem figuring out how local variables work. I'll simplify the issue to focus in on what is confusing to me. I create a local variable, say t0, with a value of 5. Then I write a column formula to increment this value by 1... either t0=t0+1 or t0+=1 (it doesn't seem to matter), the result that I expected was that when JMP evaluated each cell in the column, it would increme...

    scott1588 scott1588
    Discussions |
    Feb 10, 2024 11:21 AM
    3060 views | 4 replies

Latest Discussions

  • Scheduled job failed

    Hi, I'm trying to run daily scheduled job, but keep getting failing error "Process is terminated due to StackOverflowException".What might be the reason for this?

    shaiv90 shaiv90
    Discussions |
    Feb 11, 2024 11:09 PM
    706 views | 0 replies

  • PickFile(), Projects and Network Drives

    Did you notice that PickFile looks different when it's opened from within a project? More than that - when Pick File is opened from a project, with mydir pointing to a network drive with thousands of files, Jmp will freeze for dozens of seconds:mydir= "\\computername\directory"; Pickfile("select a file" , mydir) So, if you work in a project, to prevent Jmp from freezing, please be sure that your i...

    hogi hogi
    Discussions |
    Feb 9, 2024 3:07 PM
    759 views | 0 replies

  • How might I include a line break (or a second line) in the print header of a PDF generated from a Journal window?

     w = New Window("window", <<Journal, hlb = hlistbox() ); w << Set Print Headers( "lineone \!n linetwo", "", "Page &pn; of &pc;" ); w << SavePDF ( "C:\Users\blahblah.pdf");The above script should include a line break in the "left header" so that it has two lines. Instead the resulting PDF just has a non-printing box character between the two words, like this ... and if i copy that text into this wi...

    mann mann
    Discussions |
    Jan 31, 2024 6:25 AM
    937 views | 0 replies

  • Optimal decision tree and Adam's consensus?

    Hello - First of all, I'm speaking very much as a non-statistician here. I have a paper I'm trying to replicate that is doing hierarchical clustering with multiple similarity functions and grouping methodologies, and then using an Adam's consensus to find a sort of "optimal" dendrogram, if you will. I looked at their software they were using, and its been out of comission for a good 15 years. JMP ...

    ehchandlerjr ehchandlerjr
    Discussions |
    Jan 26, 2024 11:06 AM
    744 views | 0 replies

  • Use Limits Table In Distributions Platform

    Hi, is it possible to use a limits table to load specifications grouped by some factor in platforms other than Process Screening? Ideally I'd like to use the limits table in the distributions platform. Thanks in advance, Alicia

    Alicia Alicia
    Discussions |
    Jan 25, 2024 8:24 AM
    696 views | 0 replies
view all discussions

JMP Events

view all events
Latest Blog Post

Vroom! Vroom! Vroom! Join the JMP Summer Challenge: Motorsport edition

 view all blog articles

Learn more about JMP's premier analytics conference