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

  • Join two tables by matching common column name

    Hi,I have two tables as below.Table1 :NameSectionSubjectAdamAMathBobAscienceChrisBenglish Table2:  NameSectionScoreAdamA80BobA90ChrisB84 I want to join both table in jsl and get the following output table but I don't want to give matching column names explicitly. Matching columns would be the columns with same column name in both table. Matching columns can vary. It can be 2 (as in shown example) ...

    Rajat Rajat
    Discussions |
    Mar 18, 2020 9:09 AM
    2975 views | 1 replies

  • Adding and deleting borders of graphs in graph builder

    Hello, I want to tweak a graph to my wishes but I'm not as succesful as I want... The graph consists of 2 columns. I would like to get rid of the little grey line on top, seperating the titles of the columnsAnd I would like to have a black line closing the graph on the top Is there something in the preferences or may elsewhere that I just didn't find..? Thanks a lot!   @martindemel    

    JL_LZH JL_LZH
    Discussions |
    Mar 18, 2020 2:40 AM
    8851 views | 6 replies

  • why this script is not working??

    Names Default To Here( 1 ); dd = Current Data Table(); i=1; newdt&i = dd << Subset( Output Table Name( "i" ), All Columns( 1 ), All Rows( 1 ) ); //Graph table newdt&1 << Select columns( :As is Config );this script is  not working at select columns....please solve it .. 

    Song Song
    Discussions |
    Mar 17, 2020 8:06 PM
    2998 views | 2 replies

  • extracting month and year from mm/dd/yyyy date format

    Hi,I need to extract the month and year information from Date column in format of mm/dd/yyyy to mm/yyyy so I can find the mean of turnaround time by month. Month(:Date) extract month and Year(:Date) give year of the date. But I need it both in same formula (or same column). Tried Month(:Date) || Year(:Date) worked but resulting date type - 'expression' won't allow to plot the data. The attached ta...

    rahul_pd rahul_pd
    Discussions |
    Mar 17, 2020 12:55 PM
    11131 views | 2 replies

  • Import hidden Excel worksheet

    How can I import data from a hidden Excel worksheet? If I use Open() with the option Worksheets("TechnicalData"), then it fails as long as the worksheet "TechnicalData" is hidden in my Excel file. As soon as I unhide the worksheet in Excel, the import works again. (Note: Why do I want to import a hidden worksheet? Because I need to import data from a "user friendly" excel sheet, which is not actua...

    JWi JWi
    Discussions |
    Mar 17, 2020 12:15 PM
    2238 views | 1 replies

Latest Discussions

  • Import hidden Excel worksheet

    How can I import data from a hidden Excel worksheet? If I use Open() with the option Worksheets("TechnicalData"), then it fails as long as the worksheet "TechnicalData" is hidden in my Excel file. As soon as I unhide the worksheet in Excel, the import works again. (Note: Why do I want to import a hidden worksheet? Because I need to import data from a "user friendly" excel sheet, which is not actua...

    JWi JWi
    Discussions |
    Mar 17, 2020 12:15 PM
    2238 views | 1 replies

  • JMP script - Color or Mark by Column

    I have a JMP table with a column called Order that contains letter values like A, B, C, D, E, etc., and another column called Number that contains number values like 1, 2, 3, 4, etc.  Manually operating on this table, I could do the following:-- Right click at the upper left of the table and select Color or Mark by Column-- Select Order from the list of columns, then leave Colors = JMP Default and...

    fbm73 fbm73
    Discussions |
    Mar 15, 2020 4:16 PM
    2685 views | 1 replies

  • how to find and replace all instances of specified characters within a given column

    This is a very simple question.  I have a given column in a JMP table, and I want a JMP scripting command that will find and replace all instances of specified characters within that column.  For example, I have a column called GROUP, and certain rows in GROUP contain values like "A05 or "B17 and I would like to replace all " characters in GROUP so that the entries become A05 and B17 instead of "A...

    fbm73 fbm73
    Discussions |
    Mar 15, 2020 5:37 AM
    8731 views | 4 replies

  • How to copy Directories from one place to another?

    Hi,I have run into a problem all of a sudden. I wish to copy files and directories and I am not able to do that anymore.I use Copy File() and Copy Directory().Somehow Copy Directory() doesn't recognize my paths anymore or occasionally fails.So, I would like to know:1. How to copy a directory (say D:/copyme) inside another directory (D:/destination) ? So that I have D:/destination/copyme as the fin...

    AD1 AD1
    Discussions |
    Mar 13, 2020 4:33 AM
    3073 views | 4 replies

  • PLS modeling - "0 factors" is advised

    Hi everyone !

    Here's my situation: I have a dataset of 58 batches in line, and 213 columns corresponding to my parameters Xs (ex: Glucose at culture day 1, Glucose at culture day 2 etc...) . I have couple of data missing here and there depending on the X and the batches but on the overall the dataset is quite fine.Now I want to use PLS to put all my Xs and try to understand which of them impact my ...

    Elofar Elofar
    Discussions |
    Mar 12, 2020 12:22 AM
    4343 views | 5 replies

Latest Discussions

  • How do I calculate z-scores at different aggregation levels?

    Hello,  How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...

    Jmsouch Jmsouch
    Discussions |
    Feb 26, 2020 7:04 AM
    2216 views | 0 replies

  • Calling Windows API ImageViewer.dll to display JPG files.

    I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL.   ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...

    DMeakin1 DMeakin1
    Discussions |
    Jan 17, 2020 10:19 AM
    2020 views | 0 replies

  • Running script from command line on MAC

    Not a mac person.  Does anyone know how to run a jsl script from command line on a mac?  I specifically mean WITHOUT "//!" at the top of it.     I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl

    vince_faller vince_faller
    Discussions |
    Jan 10, 2020 2:26 PM
    1668 views | 0 replies

  • how to add confounding variable

    I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomous). 3- Y variables: insurance and practice (dichotomous) and time (continuous)I have one confounding variable Age (continuous). I will have to add random effect to X variable. But I am confused how to add confounding variable to this analysis. Can an...

    billi billi
    Discussions |
    Jan 6, 2020 9:39 AM
    1604 views | 0 replies

  • Difference between std error in "Parameter Estimates" and "Least Squares Means Table"?

    I am running mixed effects models and have noticed that the standard error for an effect in the "Parameter Estimates" table is different from the standard error reported in the Least Squares Means table for the same effect. How are they calculated differently? Thanks! 

    Ranae Ranae
    Discussions |
    Nov 26, 2019 11:44 AM
    1681 views | 0 replies
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