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

  • Unstacking a Stacked Excel Cell or Parsing Free-form Text to Generate Multiple Rows

    We all run into some version of this: Excel table formatted to look nice, no thought given to analyzability.In the free-form text cell, it looks like this: m/d: text [alt+enter]
    m/d: text [alt+enter]
    m/d: text [alt+enter]
    m/d: text [alt+enter]
    ...
    m/d: text [alt+enter] When the data are exported to JMP, the cell gets collapsed into: m/d: text m/d: text m/d: text ... m/d: text.
    I want to parse that long ...

    markschahl markschahl
    Discussions |
    Jun 4, 2020 11:47 AM
    2430 views | 3 replies
  • How to get partitioned sum of squares in ANOVA results of fit model

    Not just CTSS, SSmodel and SSE, I mean SS for individual predictors. How do I get it from fit model results? Thank you.

    ricardor ricardor
    Discussions |
    Jun 4, 2020 5:30 AM
    1388 views | 1 replies
  • Pareto Graph - changing cumulative percent formatting label

    Does anyone know if it is possible to change the formatting of the cumulative % label in the pareto plot?   This was made using the Failure.jmp sample data table and Analyze --> Quality and Process --> Pareto Plot as shown below    

    wendytseng wendytseng
    Discussions |
    Jun 3, 2020 11:24 AM
    2288 views | 1 replies
  • Force Open() to Use Excel Wizard Without Changing Preferences

    Hey JMP Community, I'm building an application where a user can import data from Excel or from a JMP table.  I'm getting the file path via Pick File().  If they select an Excel file, I want to coerce JMP to use the Excel Wizard without changing the user's preferences.  In the Scripting Index, I found something called Excel Open Method() which has an option "Use Excel Wizard"; however, there is not...

    cwillden cwillden
    Discussions |
    Jun 3, 2020 11:13 AM
    1722 views | 1 replies
  • Selecting data points across plots created from different tables

    Hello, I generate two plots - 1) Variability plot from a stacked data table (B) [B is created from a parent table (A)]2) Bivariate plot created from parent table (A) These two plots are generated as a report in tabs. The problem I face right now is that since these plots are generated from different tables, points selected on either of the plots do not get selected on the other plot. Is there a wa...

    psundar6 psundar6
    Discussions |
    Jun 3, 2020 3:02 AM
    2126 views | 3 replies

Latest Discussions

  • How to get partitioned sum of squares in ANOVA results of fit model

    Not just CTSS, SSmodel and SSE, I mean SS for individual predictors. How do I get it from fit model results? Thank you.

    ricardor ricardor
    Discussions |
    Jun 4, 2020 5:30 AM
    1388 views | 1 replies
  • DATA WIDE TO LONG FORMAT

    Hi allI have data in wide format  i.e col  with  three variables: predicted, upper and lower and respective rounding options like round up of predicted, upper and lower, round down of predicted, upper and lower etc. which I want to  reorganize it in long format i.e  some constant rows like date and all of the value has to be reformatted into longer.I have attached the " have" and "want" data.Any h...

    sweetycha sweetycha
    Discussions |
    Jun 2, 2020 12:12 PM
    3516 views | 1 replies
  • Add rows every x rows

    Dear community, i've got a huge table and would like to add one row every 4 rows (4 rows data, adding 1 row, moving the rest of the data downwards, then adding 1 row after 4 rows of data aso).I have no clue how to achieve that with a script. Can anyone kindly help me with this topic?

    Sandra Sandra
    Discussions |
    Jun 2, 2020 11:52 AM
    2936 views | 7 replies
  • Autorunning the JMP script periodically

    Hi, I'm trying to automate my everyday task. I want the following script to run periodically and save the output. Can JMP auto select from the drop down list and save the output?For ex. Selecting a Age then selecting a Name and then saving the output for all the age from 12 - 17 Thanks

    Jackie_ Jackie_
    Discussions |
    Jun 2, 2020 8:54 AM
    1681 views | 4 replies
  • Loading R .rds files into JMP

    We have some equipment that publishes results in an .rds files--an R file format.  I can find how to read a JMP file into R, but I'd like to read the R / .rds file into JMP.  Does anyone have some code snippets that would do this? Thanks!Ray Bunkofske

    vt_sailor vt_sailor
    Discussions |
    May 29, 2020 11:21 AM
    3312 views | 4 replies

Latest Discussions

  • How do I have two different chart types in a single graph using two axis?

    While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot?    Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot.     To do this, first clear the row s...

    Bass_Masri Bass_Masri
    Discussions |
    Apr 28, 2020 4:28 PM
    3575 views | 0 replies
  • 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
    1626 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
    1483 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
    1324 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
    1285 views | 0 replies
view all discussions