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

  • Counting and Using Row Identifier

    Hello All,

    Wanted to ask a question regarding counting of rows. I am attaching a data table which should hopefully illustrate the example. 

    So I have data where the main variable is density of features. There is a unique value of the density per each ROI, per each sample (ID). In the normalized variable I am taking each density value per each ROI per each sample with unique ID and dividing by the wh...

    Ekarshalev Ekarshalev
    Discussions |
    Feb 7, 2023 8:58 AM
    3471 views | 7 replies

  • What to do if my discriminant analysis has large misclassified number & percent?

    I have done Manova for my data analysis and found significant differences among my treatments but when I run separate univariate tests and try to find where the difference is; the results were non-significant… Some other forums said that the overall variables in MNOVA may contribute to the differences among the groups ( Overall effect of all the variables), but independently the variables may not ...

    Hopexu114 Hopexu114
    Discussions |
    Feb 7, 2023 8:38 AM
    1436 views | 1 replies

  • How can I add (copy) rows according to number in a specific column to the datatable

    Hi, I have a datatable as shown below. The column Anzahl shows the counts of column Prüfplan. I want JMP to make a row for every count so that Anzahl is always 1. I did that manually for row 1 as shown below, to clarify what I want to do. The original row has to be removed of course.  Can anybody help me, thank you!

    Christina Christina
    Discussions |
    Feb 7, 2023 8:28 AM
    2161 views | 5 replies

  • How to Disconnect from a database via script?

    Hello,I am using the File>Database>Query Builder method to connect to an excel file and create a table. I am able to close the table with jmp script but the connection remains active and locks up the excel file for other users. How can I disconnect via jmp script? I can manually go through File>Database>Open>Disconnect but I would like to do this automatically in the running script. Here is the qu...

    MBRackliffe MBRackliffe
    Discussions |
    Feb 7, 2023 7:15 AM
    1554 views | 2 replies

  • Using Char to compare numeric and character values

    Hi,Is it possible to compare numeric and character values? I want to compare two columns (identical or different values). One column has a numeric date and one has a character date and as I need to compare only parts of it I want to use substring. The below script runs, but it doesn´t get me the correct result as all appears to be different (which is not the case). Am I using Char wrong? If( Subst...

    JulieSAppel JulieSAppel
    Discussions |
    Feb 7, 2023 4:58 AM
    3669 views | 8 replies

Latest Discussions

  • Counting and Using Row Identifier

    Hello All,

    Wanted to ask a question regarding counting of rows. I am attaching a data table which should hopefully illustrate the example. 

    So I have data where the main variable is density of features. There is a unique value of the density per each ROI, per each sample (ID). In the normalized variable I am taking each density value per each ROI per each sample with unique ID and dividing by the wh...

    Ekarshalev Ekarshalev
    Discussions |
    Feb 7, 2023 8:58 AM
    3471 views | 7 replies

  • Authenticate DBC user and pass before storing them for future use

    Hi,I am writing some code to pull data from an ODBC connection. I want to test if the username and password entered are valid. The script is as follows: dbc = Create Database Connection("Driver={Oracle in instantclient11_1}; DBQ=" || target || "; UID=" || user || ";PWD=" || pass || ";FBS=12800000;");I found some solutions suggesting checking if dbc is empty to see if the connection was created as ...

    SivaSubram5313 SivaSubram5313
    Discussions |
    Feb 7, 2023 4:52 AM
    1325 views | 2 replies

  • 対応分析のデータをクレンジングする方法を教えてください。

    対応分析をする前に、データをクレンジングしたいのですが、目的変数の項目が多い場合、いちいち入力することはなく分析をできる方法教えてください。

    Chisa315 Chisa315
    Discussions |
    Feb 6, 2023 4:51 PM
    1059 views | 1 replies

  • 対応分析で2値かした場合行列が全部0となった場合の対応分析方法

    対応分析で2値かした場合行列が全部0となった場合、対応分析ができる方法を教えてください。

    Chisa315 Chisa315
    Discussions |
    Feb 6, 2023 4:45 PM
    947 views | 1 replies

  • Selecting latest Date for same ID

    Hi all,I have a problem here trying to figure out. I'm still new in JSL thus I'm stuck.
    I have this table that gives me the ID of an item, the date it was processed and so on. For same ID, multiple reprocess could've been done and it causes the timestamp of DateTime to double/triple. I want to clean up my table and only maintain the ones with latest DateTime for same ID. I know i should use loop fo...

    Leyahans Leyahans
    Discussions |
    Feb 6, 2023 12:11 PM
    1593 views | 2 replies

Latest Discussions

  • JMP Script Window - Hovering over a variable do not show the value stored in the variable if passed between scripts

    I have found that hovering over a variable is very useful feature in JMP Script Window/Editor when debugging the script. I have been working with very long script which I have divided to smaller pieces by using Include-feature. I am able to pass variable content correctly between the included scripts but it looks like hovering do not work on included script windows (showing empty variable content ...

    JanneI JanneI
    Discussions |
    Jan 27, 2023 5:51 AM
    801 views | 0 replies

  • Choice experiment: probability profiler baseline assumptions

    Dear community,  For the probability profiler as used to analyse data in choice experiment analysis, I am wondering how to optimally set the baseline scenario to compare probability profiler data.  Following for instance von Wedel & Hagist (2022), utilize the probability profiler to compare the baseline of the combination of attributes with the lowest marginal utilities. While such an analysis is ...

    Declan_JMP Declan_JMP
    Discussions |
    Jan 23, 2023 3:54 AM
    1616 views | 0 replies

  • Can we find some tutorials videos in YouTube?

    Hello everyone, passing by to say hello and to share that I created a YouTube Channel with JMP 17 Video Tutorials in english, spanish and portuguese.As an enthusiast about Problem Solving, passionated about JMP and a JMP Partner, I hope you'll come with me, subscribe to the channel and enjoy all the videos that are there and yet to come.https://www.youtube.com/@planaconsultoria Best regards!

    Matheus_Plana Matheus_Plana
    Discussions |
    Jan 15, 2023 10:27 AM
    1657 views | 0 replies

  • Data puzzles via Hanukkah of Data is underway

    If you're looking for some data wrangling puzzles, the Hanukkah of Data series of daily puzzles is underway at https://hanukkah.bluebird.sh/5783/. They're on day 2 of 8 now. As far as I can tell, you can do them whenever and there's no competitive part. I'm doing them in JMP, of course!

    XanGregg XanGregg
    Discussions |
    Dec 19, 2022 11:21 AM
    826 views | 0 replies

  • Slope and Intercept Collector error "matrix must be non-singular in access or evaluation of 'Inv' , Inv/*###*/(x` * x)"

    HI all,I have a question about an error I'm getting when using @stan_koprowski's slope and intercept add-in. I've posted my question on the add-in's thread but due to the much lower exposure compared to discussion posts, I thought that it might be a good idea to ask here as well. I made a mock data table with three groups and several observations in each group. When I run the add-in I am getting t...

    Lavik17 Lavik17
    Discussions |
    Dec 19, 2022 10:20 AM
    965 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