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 19 is here! See the new features at jmp.com/new.
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.

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

  • JSL how to reference a table in graph builder

    Hallo all,   I use a JSL script to generate two tables dt1 and dt1 from an SQL server and then I want graph builder to plot two columns from the first data table I generated. Example below:     dt1 = Open Database( "BLA", " SELECT col1, col2 FROM BLA", "data table 1" ); dt2 = Open Database( "BLA", " SELECT col1, col2 FROM BLA", "data table 2" ); Graph Builder( Variables( X( :col1 ), Y( :Tcol...

    valeria valeria
    Discussions |
    Sep 26, 2021 11:47 PM
    2691 views | 3 replies

  • Determine Week of Year and Day of Week Based on Year, Date and Time

    Hello all, My company uses a fiscal calendar where one year has only 52 work week(WW). The weeks start on Saturdays, time 19:00  (hh:mm). The day of week (DOW) is determined based on the time 19:00. I am trying to determine it by using Week Of Year() and Date of Week() functions but I do not get the desired outcome. Has anyone created JSL script to determine the week of year and date of week based...

    bzanos bzanos
    Discussions |
    Sep 26, 2021 9:58 PM
    2376 views | 2 replies

  • Saving Multiple Data Tables to an Excel Workbook

    Hi -
    I have a jsl script made with Jmp 12 that processes huge data table and generates 9 data tables with different summaries.

    I am saving these off currently as 9 csv files. I would like to condense it to ONE Excel workbook with 9 tabs.

    I understand saving each data table to excel (xlsx) is an option. How can I have 9 sheets saved to one excel via Jmp 12?

    Appreciate any inputs/pointers. Thanks!

    uProf uProf
    Discussions |
    Sep 26, 2021 7:38 PM
    1573 views | 2 replies

  • break a single column into multiple based on empty row or specific character

    Hi,can someone provide advice?I have a column with structure below:
    123 abcdef xxyyzz

    is it possible to divide to multiple columns based on empty row (or a repeated same character) 1 a xx2 b yy3 c zz   d   e   f

    dadawasozo dadawasozo
    Discussions |
    Sep 25, 2021 8:08 AM
    942 views | 2 replies

  • How to estimate sample size to meet specificity and sensitivity requirements

    Hi, I'm trying to calculate the sample size required for my test to meet the sensitivity and specificity requirements.I have a binary test that detects the presence of bacteria in water, if it's positive bacteria is present, if it's negative it is not present.I would like my test to have92% sensitivity (with 95% CI of 90-94%)and 90% specificity (with 95% CI of 88-92%)and I want the power to be 0.8...

    Agustin Agustin
    Discussions |
    Sep 24, 2021 9:22 AM
    2472 views | 3 replies

Latest Discussions

  • Saving Multiple Data Tables to an Excel Workbook

    Hi -
    I have a jsl script made with Jmp 12 that processes huge data table and generates 9 data tables with different summaries.

    I am saving these off currently as 9 csv files. I would like to condense it to ONE Excel workbook with 9 tabs.

    I understand saving each data table to excel (xlsx) is an option. How can I have 9 sheets saved to one excel via Jmp 12?

    Appreciate any inputs/pointers. Thanks!

    uProf uProf
    Discussions |
    Sep 26, 2021 7:38 PM
    1573 views | 2 replies

  • break a single column into multiple based on empty row or specific character

    Hi,can someone provide advice?I have a column with structure below:
    123 abcdef xxyyzz

    is it possible to divide to multiple columns based on empty row (or a repeated same character) 1 a xx2 b yy3 c zz   d   e   f

    dadawasozo dadawasozo
    Discussions |
    Sep 25, 2021 8:08 AM
    942 views | 2 replies

  • How to estimate sample size to meet specificity and sensitivity requirements

    Hi, I'm trying to calculate the sample size required for my test to meet the sensitivity and specificity requirements.I have a binary test that detects the presence of bacteria in water, if it's positive bacteria is present, if it's negative it is not present.I would like my test to have92% sensitivity (with 95% CI of 90-94%)and 90% specificity (with 95% CI of 88-92%)and I want the power to be 0.8...

    Agustin Agustin
    Discussions |
    Sep 24, 2021 9:22 AM
    2472 views | 3 replies

  • How to calculate adjusted variable data ？

    Hello, this may be a simple question.I am trying to analyze e relationship between Adjusted Variable and Variable of Interest. I want to calculate adjusted variable data by age and sex.  What JMP function should I use?  

    KF2 KF2
    Discussions |
    Sep 23, 2021 10:40 AM
    1279 views | 2 replies

  • Does Graph Builder have a ruler tool?

    Graph Builder is fantastic, it's one of the killer features of JMP. Does it have a ruler tool buried somewhere?  A way to measure the distance between two points?   For all the things GB does, I'd be surprised if it didn't...

    BHarris BHarris
    Discussions |
    Sep 23, 2021 8:13 AM
    2709 views | 3 replies

Latest Discussions

  • Skip Lot Sampling Plan

    Hi,I am interested to use JMP for skip lot sampling plan. I like to test only a fraction (f) of samples after successful inspection of (n) number of samples. Here is the link to NIST https://www.itl.nist.gov/div898/handbook/pmc/section2/pmc27.htm I appreciate any help you can provide. Thanks Adam

    AT AT
    Discussions |
    Sep 10, 2021 10:38 AM
    959 views | 0 replies

  • Time values in xls or xlsx, csv, and JMP

    Hi all, I have a strange issue with the time values from my excel. I have some data (example is attached here as excel file), the time column is an interest for me and I would add the date and time column together to create a date time column. To analyze the data, I use JMP so I am importing the excel file.However, I ran into a number of oddities:1. When I import multiple files (from customers to ...

    fliew0410 fliew0410
    Discussions |
    Sep 7, 2021 7:25 AM
    953 views | 0 replies

  • Error while using Azure MFA to connect with JMP

    I have rightly set up the ODBC connection version 17 for SQL server using Azure MFA. However, when I try to connect for the DSN via JMP i get the following error. how to overcome this error in JMP14.  [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Password option must not be specified, if Authentication option is 'ActiveDirectoryInteractive'.

    hariharan249 hariharan249
    Discussions |
    Sep 3, 2021 7:14 AM
    669 views | 0 replies

  • Applying Boolean Logic to filtering/selecting records in a Dashboard/Application built from multiple platforms

    Hi everyone,  I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out to community members @cwillden , @txnelson , @danschikore , @brady_brady , and technical support crew Adam Morris, Sarah Seligman, Laura Archer, and Wendy Murphrey for helping me get this project this far along.  I f...

    caseylott caseylott
    Discussions |
    Aug 17, 2021 11:15 AM
    1225 views | 0 replies

  • Projects Window List in JMP 15 for Mac -- Reorder?

    I'm trying to use JMP projects more with the promise of re-using graphs and analyses on new sets of similar data. I'm using the Window List in the UL as a kind of 'table of contents' that I can click into to see/show my findings for various analyses.  There is a flow to the findings which I'd like to order in that Window List.  Is this possible? I can't click and drag an entry for a window up or d...

    datanaut datanaut
    Discussions |
    Aug 16, 2021 6:38 AM
    615 views | 0 replies
view all discussions

JMP Events

view all events
Latest Blog Post

More on the many advantages of structural equation models

 view all blog articles

Learn more about JMP's premier analytics conference