cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

  • Response Screening DataTable

    Hello i'm writing a script that perform Response screening because my Idea is to work with  the output "Pvalues" table of this report, but im not able to assign a "dt"  variable to Pvalues table.... so with script im not able to move from another table to Pvalues. Someone can help me   obj = selectDT[1] << Response Screening( Y( Response ), X( Eval( Predictor ) ), save Pvalues )     Thanks in adva...

    gianpaolo gianpaolo
    Discussions |
    Jun 11, 2020 1:10 AM
    1548 views | 1 replies
  • How to use contains() correctly?

    Hi, All I wanna use contains(),Names Default To Here( 1 ); dt = Open( "$Sample_Data/Blood pressure.jmp" ); colNamesList = dt << get column names( continuous ); Input = New Window( "example", << modal(), new1 = hlistbox( Text Box( "Test name :" ), Para_Num_teb = Text Edit Box( "", <<set width( 200 ) ) ), text box("Click OK"), Button Box( "OK", Para_Num = Para_Num_teb << get text(); )...

    LBrian LBrian
    Discussions |
    Jun 10, 2020 8:57 PM
    2267 views | 2 replies
  • JMP 15: get function doesn't work with modal windows

    If you try this script (obtained from the scripting index in JMP 15) Names Default To Here( 1 ); New Window( "Example", <<modal, numbox = Number Edit Box( 0 ) ); Print( numbox << Get );and edit the number box you get this error:deleted object reference: numbox << Get in access or evaluation of 'Glue' , Names Default To Here( 1 ); /*###*/New Window( "Example", <<modal, numbox = Number Edit Box(...

    Fiona_Baines Fiona_Baines
    Discussions |
    Jun 10, 2020 9:10 AM
    2905 views | 3 replies
  • if "compare" column value is greater than 100%, then change the value to 100%, if less than or equal to 100%, then keep the value no change

      Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); New Column( "Compare", Numeric, "Continuous", Format( "Percent", 12, 0 ), Formula( :weight / :height ) ); //change the value on position of :weight[2] to 59. But seems not work. could you help edit the script on this place? dt:weight[2] << Set Values( 58 ); // I hope realize if the column "compare" result >100%, then ou...

    Theresa Theresa
    Discussions |
    Jun 10, 2020 12:32 AM
    2788 views | 2 replies
  • Getting mode statistics in tabulate

    Hi JMP user community,I have periodic inprocess record for batches manufactured, monitoring frequency is every 15 mins.I have to calculate batch specific mode for the respective in-process entry.I can't see the option of mode statistics in Analyze > tabulate. I am using JMP 14.3.0.Is there way to get Mode as statistics using tabulate.Thanks!  

    nil nil
    Discussions |
    Jun 9, 2020 11:09 PM
    2899 views | 2 replies

Latest Discussions

  • if "compare" column value is greater than 100%, then change the value to 100%, if less than or equal to 100%, then keep the value no change

      Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); New Column( "Compare", Numeric, "Continuous", Format( "Percent", 12, 0 ), Formula( :weight / :height ) ); //change the value on position of :weight[2] to 59. But seems not work. could you help edit the script on this place? dt:weight[2] << Set Values( 58 ); // I hope realize if the column "compare" result >100%, then ou...

    Theresa Theresa
    Discussions |
    Jun 10, 2020 12:32 AM
    2788 views | 2 replies
  • Getting mode statistics in tabulate

    Hi JMP user community,I have periodic inprocess record for batches manufactured, monitoring frequency is every 15 mins.I have to calculate batch specific mode for the respective in-process entry.I can't see the option of mode statistics in Analyze > tabulate. I am using JMP 14.3.0.Is there way to get Mode as statistics using tabulate.Thanks!  

    nil nil
    Discussions |
    Jun 9, 2020 11:09 PM
    2899 views | 2 replies
  • How to find row and column (cell) that matches a value

    I have tables that are generated and the format is different from time to time and it breaks my script.  The tables are massive and so the way i handle my loops is that i import the first 100 rows and 5 columns, for speed.  Then i search a particular column for a keyword to help me know where which row the real data starts.  I close the file then reopen with that variable identifying the column he...

    SamKing SamKing
    Discussions |
    Jun 9, 2020 7:11 AM
    4118 views | 2 replies
  • Impact of screen resolution on html output

    Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...

    Ole Ole
    Discussions |
    Jun 9, 2020 6:21 AM
    1172 views | 0 replies
  • Load data to a google sheet using JMP

    Hello everybody, I was wondering if it was possible to load data to a google sheet using JMP. I'm running a script, it generates some numbers, and I would like those numbers to end up in a google sheet. Any ideas on how to do this? Cheers, Eduardo

    Eduardo Eduardo
    Discussions |
    Jun 9, 2020 2:02 AM
    3732 views | 2 replies

Latest Discussions

  • Impact of screen resolution on html output

    Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...

    Ole Ole
    Discussions |
    Jun 9, 2020 6:21 AM
    1172 views | 0 replies
  • 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
    4434 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
    2038 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
    1885 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
    1559 views | 0 replies
view all discussions