User Community
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 will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
JMP Bar Chart

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users

Learning Resources

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

view all learning resources

Latest Discussions

  • Convert Date/Time (down to the millseconds) into a Variable

    Hello,I am trying to convert a date/time down to the milliseconds in order to insert into an SQL statement that I am using in my JSL script. The typical method I use to do so usually creates the variable (date) with single quotes around it. However, when attempting the same method to my date/time which includes milliseconds it adds two single quotes to each end of the variable. Could someone assis...

    Sully Sully
    Discussions |
    Mar 12, 2021 5:40 AM
    1495 views | 1 replies

  • How do I delete columns in a data table with their names containing "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the column containing only "." (NOT empty)

    I have a large dataset on hand and want to delete all columns whose name contain "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the whole column only contains "." but not empty except the column name. (images are shown below) I did not know how to do this after searching Google and read the JMP manual. Thanks for help on this.    

    mengzy1974 mengzy1974
    Discussions |
    Mar 12, 2021 12:56 AM
    1632 views | 1 replies

  • How do I create a counting variable based on another column & transpose a table?

    Hi all,I'd appreciate help with reformatting a clinical dataset. It records ~50 variables for multiple patients on multiple visits. So there are ~51 columns with one being an MRN or record number per patient. There are typically 6-7 rows of data per patient/MRN to report on variables taken at different visits. So 2 questions: 1)How can I generate a new incremental count variable that counts number...

    acm acm
    Discussions |
    Mar 11, 2021 4:13 PM
    1882 views | 1 replies

  • check if data exist in another table

    Hi, I have 2 tables A and B, each has a column "email" and "id". I want to add a new column in table A, if that row has "the same email OR same id" showing up in table B, then "YES", if no then empty. Could someone help me how to write this script?  Thank you.

    joann joann
    Discussions |
    Mar 11, 2021 10:35 AM
    4474 views | 7 replies

  • Variable confounds with residual

    Hi, l am attempting to analyse data for an interlab study with a mixed model, its a nested design with 5 variables, the dependant variable is titers, the structure of my analysis is as followsFixed EffectSample (30 of)Random EffectsSample*Lab (3 levels)
    Sample*Day (3 Levels)
    Sample*Run (2 Levels)
    Replicate[Sample,Lab,Day,Run] (replicate has 2 levels)
    Sample*Lab*Day l get the error message that Replica...

    Mickyboy Mickyboy
    Discussions |
    Mar 11, 2021 4:02 AM
    6408 views | 10 replies

Latest Discussions

  • Convert Date/Time (down to the millseconds) into a Variable

    Hello,I am trying to convert a date/time down to the milliseconds in order to insert into an SQL statement that I am using in my JSL script. The typical method I use to do so usually creates the variable (date) with single quotes around it. However, when attempting the same method to my date/time which includes milliseconds it adds two single quotes to each end of the variable. Could someone assis...

    Sully Sully
    Discussions |
    Mar 12, 2021 5:40 AM
    1495 views | 1 replies

  • How do I delete columns in a data table with their names containing "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the column containing only "." (NOT empty)

    I have a large dataset on hand and want to delete all columns whose name contain "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the whole column only contains "." but not empty except the column name. (images are shown below) I did not know how to do this after searching Google and read the JMP manual. Thanks for help on this.    

    mengzy1974 mengzy1974
    Discussions |
    Mar 12, 2021 12:56 AM
    1632 views | 1 replies

  • How do I create a counting variable based on another column & transpose a table?

    Hi all,I'd appreciate help with reformatting a clinical dataset. It records ~50 variables for multiple patients on multiple visits. So there are ~51 columns with one being an MRN or record number per patient. There are typically 6-7 rows of data per patient/MRN to report on variables taken at different visits. So 2 questions: 1)How can I generate a new incremental count variable that counts number...

    acm acm
    Discussions |
    Mar 11, 2021 4:13 PM
    1882 views | 1 replies

  • BMI percentile calculations

    For patients < 18 years of age, their obesity is determined by age, gender specific BMI percentiles . CDC had codes to do this in SAS https://www.cdc.gov/nccdphp/dnpao/growthcharts/resources/sas.htm I am wondering if this is possible to do this in JMP. I currently have to depend on a SAS user to do this for me..

    Sandeep123 Sandeep123
    Discussions |
    Mar 10, 2021 3:13 PM
    1389 views | 1 replies

  • Predicting Rainy Days

    Hi all! I'm wondering if JMP can help with spot a pattern in the days leading up to rain. If I have years of historical daily (even hourly) environmental data which includes temperature, humidity, pollution, etc, would JMP be able to help spot a pattern leading up to rainy days? If so, what type of analysis would be best suited for a study like this? The "sequential" element is tricky to me, as I'...

    gudetama gudetama
    Discussions |
    Mar 8, 2021 12:55 PM
    3433 views | 7 replies

Latest Discussions

view all discussions

JMP Events

Sorrento, Italy 10-12 March
view all events
Latest Blog Post

Revolutionizing Spectral Baseline Correction in JMP: Harness the Power of Python Integration

JMP blog post photo
view all blog articles

Learn more about JMP's premier analytics conference