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

  • Loop for Recode

    I have several columns of data with numbers in.When I import the data from excel some columns get imported as strings.I would like to be able to loop through all columns and change their data type to integer.The below script is an attempt to change one column.col_list = dt << Get Column Names () dt << Begin Data Update; dt << Recode Column( dt;col_list[21], {Num( _rcNow )}, Update Properties( ...

    Jemster Jemster
    Discussions |
    Jul 5, 2022 7:49 AM
    1168 views | 1 replies

  • Best design for ingredients with category caps

    I have to design an experiment involving 1 fixed ingredient (A), 1 ingredient with a minimum and maximum % to use (B) and ingredients from 9 other different categories (C to K). Each category from C to K have varying number of ingredients within those categories, varying from atleast 2 to a maximum of 9. And each of the ingredients in these categories have a recommended use level (%), so it is eit...

    ishwarvenugopal ishwarvenugopal
    Discussions |
    Jul 5, 2022 7:07 AM
    2521 views | 6 replies

  • Deleting Columns with N Null Row Values

    I have a table of values with each column being an instrument and each row being a time. Some instruments have not had data recorded at enough time values in order for me to fit a meaningful model.I am attempting to use a loop to allow me to cycle through each column in turn and check the number of values.I have some code which find the number of values for column 80.col_a = Column(dt_2, 80); val_...

    Jemster Jemster
    Discussions |
    Jul 5, 2022 5:06 AM
    1538 views | 2 replies

  • How to query Access Linked Tables?

    Hello, I try to load a linked table from an Access database and keep getting the error "Tables () referenced in the SQL Query were not found in the database in access or evaluation of 'Table'.. ". The script works fine for the local tables and a local copy of the linked table. I'm using JMP 16. Please help! Thanks in advance! fn_GetData = Function( {test}, New SQL Query( Connection( "ODBC:...

    SpideyStrange SpideyStrange
    Discussions |
    Jul 5, 2022 1:45 AM
    863 views | 1 replies

  • Getting a border box to appear on a button press.

    I am trying to open up a border box to the right of my list box on a button press, how can this be achieved? I have attached my attempted code below. New Window("test", title = Text Box("test", set font style("Bold")), V List Box( lb = List Box( "Test", width(150),nlines( 18 ) ), ), H List Box( Button = Button Box("Test", Spacer Box(Size(50, 25)), Border Box( Left...

    Andyon98 Andyon98
    Discussions |
    Jul 4, 2022 10:28 AM
    809 views | 1 replies

Latest Discussions

  • Best design for ingredients with category caps

    I have to design an experiment involving 1 fixed ingredient (A), 1 ingredient with a minimum and maximum % to use (B) and ingredients from 9 other different categories (C to K). Each category from C to K have varying number of ingredients within those categories, varying from atleast 2 to a maximum of 9. And each of the ingredients in these categories have a recommended use level (%), so it is eit...

    ishwarvenugopal ishwarvenugopal
    Discussions |
    Jul 5, 2022 7:07 AM
    2521 views | 6 replies

  • How to query Access Linked Tables?

    Hello, I try to load a linked table from an Access database and keep getting the error "Tables () referenced in the SQL Query were not found in the database in access or evaluation of 'Table'.. ". The script works fine for the local tables and a local copy of the linked table. I'm using JMP 16. Please help! Thanks in advance! fn_GetData = Function( {test}, New SQL Query( Connection( "ODBC:...

    SpideyStrange SpideyStrange
    Discussions |
    Jul 5, 2022 1:45 AM
    863 views | 1 replies

  • Getting a border box to appear on a button press.

    I am trying to open up a border box to the right of my list box on a button press, how can this be achieved? I have attached my attempted code below. New Window("test", title = Text Box("test", set font style("Bold")), V List Box( lb = List Box( "Test", width(150),nlines( 18 ) ), ), H List Box( Button = Button Box("Test", Spacer Box(Size(50, 25)), Border Box( Left...

    Andyon98 Andyon98
    Discussions |
    Jul 4, 2022 10:28 AM
    809 views | 1 replies

  • How do I isolate a character string of only numbers with varying starts and ends?

    Hello, I am trying to isolate only the 12 digit string for each Name to give me what you see in column Name 1. Is there a regex formula I could use to take care of the front and back end? Any help would be appreciated. Thanks!

    IMG0318 IMG0318
    Discussions |
    Jul 4, 2022 3:06 AM
    804 views | 1 replies

  • Get As Report - Text Justification

    Hello, I am trying to justify the text to the left:VLB2<<append( Report_P = CollectionFileStacked<<Get As Report ); Report_P[Tablebox(1)] << Set Underline Headings(1); Report_P[Tablebox(1)] << Horizontal Alignment( "Left" );This doesn't seem to work, I also try to unselect specific columns with no success, the Scripting Index for the 'Get As Report' and 'Table Box' doesn't seem to be of much help....

    Niros Niros
    Discussions |
    Jul 3, 2022 12:37 AM
    1058 views | 2 replies

Latest Discussions

  • Urgent: covariance parameter estimates are all zero (i.e. estimate, Std error, confidence interval)

    Dear All,I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Other information include about the analysis include:1. 14 continuous variables measured four times at unequal time periods2. All the three covariance structures I tried (AR1, Toeplizt and spatial power) had...

    MomentMonster90 MomentMonster90
    Discussions |
    Jun 13, 2022 5:53 AM
    782 views | 0 replies

  • Validate column values (make sure all values in column follow a specific pattern)

    Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column match specific Regex. Like so:!IsMissing(Regex(Column(myColumn)[1], "^\w+(\d{3})\w+$", "\1"))I can iterate through each row to make sure that all of them match, but maybe there is a better way?  

    miguello miguello
    Discussions |
    May 6, 2022 11:09 AM
    630 views | 0 replies

  • SUR (Seemingly Unrelated Regressions)

    HI, How to find estimators of FGNLS and NLS (Seemingly Unrelated Regressions) Using JmpPro.# Note that it is present in SAS in the proc syslin
    and it is in stat in the nlsur command Regards

    Raaed Raaed
    Discussions |
    May 5, 2022 4:45 PM
    774 views | 0 replies

  • Friedman post hoc analysis

    Hello, I am trying to do a matched sample analysis across three different factors. I wanted to:1. Confirm that my sample would be what I pick for 'Block" when I do Fit Y by X when running Friedman's test2. Is there a post hoc analysis in JMP that I can use? I dont see Nemenyi or Conover as an optionThanks for your time.  

    pnakashe pnakashe
    Discussions |
    May 5, 2022 12:02 PM
    996 views | 0 replies

  • JMP script: Script Alarm Control chart- Table with atypical batch number and values

    Hello everyone,I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.I used for that the "script alarm" function as I could found some exemples on the JMP community. Here is my script:  z_KSigmaZ =1.4; // Création de la Carte de controle si N catégories > 5 Names Default To Here( 1 ); If(N Items(Associative Array(:"RNS/NS tordu (srg)")) > 5, Gr...

    Sebastienlg Sebastienlg
    Discussions |
    Apr 29, 2022 6:29 AM
    701 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