cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest Discussions

  • Multi File Import Certain Tabs and Columns

    I am trying to import multiple XLSX files (which I know how to do), but I only need certain tabs with certain columns. I don't need everything being imported. Is there a way to do this? Using JMP 17. Can recreate with steps or JSL code.

    patriciafm811 patriciafm811
    Discussions |
    Oct 11, 2023 11:18 AM
    1273 views | 6 replies
  • How to make contour plot for data that contains categorical variables

    Hi,  I'd like to make contour plots for a dataset that has 2 continuous variables, and one categorical variable. When I was messing around with the plot, I was somehow able to make it generate plots for both scenarios (one plot for assuming categorical condition A, another for categorical condition B) automatically. I can no longer repeat that analysis as it tells me the X values must be numerical...

    MetaLizard62080 MetaLizard62080
    Discussions |
    Oct 11, 2023 10:56 AM
    1825 views | 2 replies
  • Make combined data table with a column containing the test title

    I need help with table scripting, I think... Goal: run paired tests on 93 variables and save the combined data table of results to apply a multiple-test correctionWhat's working: the analysis What I'm struggling with: the output of the combined data table. I'm looking for an output where, ideally, the two-tailed P value is included in the table with a descriptor column that relates back to the com...

    Shiz Shiz
    Discussions |
    Oct 11, 2023 10:25 AM
    1680 views | 5 replies
  • Adding dates from columns

    I have 3 dates that I wanted to add up in order to calculate the total number of days. Is there a way to do this? I just know the Date Difference ( ) function, but doesn't know if there is a function used in calculating the sum of dates from three different columns? 

    UserID16644 UserID16644
    Discussions |
    Oct 10, 2023 6:19 PM
    1168 views | 4 replies
  • Change column format

    Hi all, I am opening a csv file with dates (0000-00-00) having a default column data type character. However, whenever I tried to update the column with a formula from another column with a date value, I cannot change the format into date. My code looks something like thisdt = Open ("C:\Users\table1.jmp"); dt2 = Open ("C:\Users\table1.jmp"); dt2 << Update( With( dt), Match Columns( :idFin = :idF...

    UserID16644 UserID16644
    Discussions |
    Oct 10, 2023 6:06 PM
    771 views | 1 replies

Latest Discussions

  • Multi File Import Certain Tabs and Columns

    I am trying to import multiple XLSX files (which I know how to do), but I only need certain tabs with certain columns. I don't need everything being imported. Is there a way to do this? Using JMP 17. Can recreate with steps or JSL code.

    patriciafm811 patriciafm811
    Discussions |
    Oct 11, 2023 11:18 AM
    1273 views | 6 replies
  • How to make contour plot for data that contains categorical variables

    Hi,  I'd like to make contour plots for a dataset that has 2 continuous variables, and one categorical variable. When I was messing around with the plot, I was somehow able to make it generate plots for both scenarios (one plot for assuming categorical condition A, another for categorical condition B) automatically. I can no longer repeat that analysis as it tells me the X values must be numerical...

    MetaLizard62080 MetaLizard62080
    Discussions |
    Oct 11, 2023 10:56 AM
    1825 views | 2 replies
  • Make combined data table with a column containing the test title

    I need help with table scripting, I think... Goal: run paired tests on 93 variables and save the combined data table of results to apply a multiple-test correctionWhat's working: the analysis What I'm struggling with: the output of the combined data table. I'm looking for an output where, ideally, the two-tailed P value is included in the table with a descriptor column that relates back to the com...

    Shiz Shiz
    Discussions |
    Oct 11, 2023 10:25 AM
    1680 views | 5 replies
  • Adding dates from columns

    I have 3 dates that I wanted to add up in order to calculate the total number of days. Is there a way to do this? I just know the Date Difference ( ) function, but doesn't know if there is a function used in calculating the sum of dates from three different columns? 

    UserID16644 UserID16644
    Discussions |
    Oct 10, 2023 6:19 PM
    1168 views | 4 replies
  • How to screen easily the non significant of many factors(~200 columns) before to perform a mulitple regression.

    I have many factor (~200 columns) and one response,i have many measures.Most of this factors show colinearity between them,is there a simple way to perform a first filter of the not relevant factors?Then in the remaining i will perform a multiple regression.

    Perpignan_italy Perpignan_italy
    Discussions |
    Oct 10, 2023 5:50 AM
    1170 views | 3 replies

Latest Discussions

  • Strange behavior using GenReg and Forward Selection

    Hi All,   I'm hoping someone might be able to help me to understand what is causing some strange behavior when I use GenReg and the Forward Selection Estimation Method.   So, I have some data that I'm running through GenReg with Forward Selection, where I have several model effects and a validation column as well. After performing the fit, I want to run some simulations on the Estimate column of t...

    SDF1 SDF1
    Discussions |
    Oct 2, 2023 9:06 AM
    472 views | 0 replies
  • SIMCA classification method: what alternative options do I have in JMP and what are the pros/cons?

    Hello, I am after a combination of guidance and education. I have recently come across SIMCA as a classification approach. I believe this is not something JMP can address at the moment so my question is, which alternative options can I explore to achieve a similar goal and what would be the advantages/disadvantages when compared to the SIMCA method?  I am currently using JMP 17 Thank you very much...

    CamillaLiscio CamillaLiscio
    Discussions |
    Oct 2, 2023 5:55 AM
    743 views | 0 replies
  • What determines which data table is seen as "Associated Data" for New Window?

    What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on creation what it should be (without first creating some report which will be removed)?   This example script will have the summary table as associated data, but I would like it to be the Big Class table. ...

    jthi jthi
    Discussions |
    Sep 21, 2023 9:44 AM
    512 views | 0 replies
  • Using R - File path problem

    I have difficult to get the filepath correct. 
    Error message says "Cannot open table in access or evaluation of ....(Filepath)"   

    Prometheus Prometheus
    Discussions |
    Sep 17, 2023 10:46 PM
    622 views | 0 replies
  • Data Access Handler

    How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties.  But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...

    hogi hogi
    Discussions |
    Sep 16, 2023 12:21 AM
    385 views | 0 replies
view all discussions