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: 

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

  • Trying to open an xlsm excel sheet

      I am trying to use an open command to open an excel file. I keep getting the error that it can not be opened in the excel wizard. Should I change the worksheet settings? dt = Open( DXrelease, Worksheets( "SDMA" ), Use for all sheets( 1 ), Concatenate Worksheets( 0 ), Create Concatenation Column( 0 ), Worksheet Settings( 1, Has Column Headers( 1 ), Number of Rows in Headers( 1 ), H...

    BTeague BTeague
    Discussions |
    Nov 13, 2022 1:20 PM
    2703 views | 5 replies

  • JSL error: jump to line?

    If the JSL edit reports an error, is there a functionality to jump to the respective line?e.g. by clicking on the error message?

    hogi hogi
    Discussions |
    Nov 13, 2022 6:39 AM
    1293 views | 2 replies

  • Error tracing: JMP tries to "help"

    JMP helps the user to "trace" errors in JSL code: It doesn't indicate the line of code where the error "happens".
    It tries to find out where the actual error is in the code and shows this line.In the below example, the error message just shows up if line 6 is uncommented --> error "happens"  in line 6.
    But the erroneous code (Graph Bulder without "i") is in line 4.And JMP, indeed mentions line 4 -> ...

    hogi hogi
    Discussions |
    Nov 13, 2022 6:38 AM
    1338 views | 1 replies

  • connect to SQL databse programmatically

    Hi,I am trying to connect to an SQL database in a script using theOpen Database command.Now, when I work interactively, I create a "Machine Data Source" fromthe database conect widget. When I connect, a window opens up askingfor username and password. When I insert them, I can succesfully connectto the database and import tables into JMP.So I would like to try the same from a script. Unfortunately...

    paologrigis paologrigis
    Discussions |
    Nov 12, 2022 2:32 PM
    66113 views | 11 replies

  • How to change point color in a control chart based on stratification?

    By default I get a black marker colour for all plotted points on an individuals chart, as shown in attached file.Supposed I want to stratify in some way and change the marker, or point, colour. In the attached this is the second column (column titled "Material").How could I do this? For example, make all the values on the chart associated with 'A' be green, the 'B' values black and the 'C' values ...

    scottahindle scottahindle
    Discussions |
    Nov 12, 2022 7:41 AM
    8229 views | 4 replies

Latest Discussions

  • JSL error: jump to line?

    If the JSL edit reports an error, is there a functionality to jump to the respective line?e.g. by clicking on the error message?

    hogi hogi
    Discussions |
    Nov 13, 2022 6:39 AM
    1293 views | 2 replies

  • Error tracing: JMP tries to "help"

    JMP helps the user to "trace" errors in JSL code: It doesn't indicate the line of code where the error "happens".
    It tries to find out where the actual error is in the code and shows this line.In the below example, the error message just shows up if line 6 is uncommented --> error "happens"  in line 6.
    But the erroneous code (Graph Bulder without "i") is in line 4.And JMP, indeed mentions line 4 -> ...

    hogi hogi
    Discussions |
    Nov 13, 2022 6:38 AM
    1338 views | 1 replies

  • Excluding data from Graph Based on Value

    Is there a way to graph data, if it occurs 2 or more times? 

    For instance: 
    Column 1: Family Name
    Column 2: Rooms of the House with a Television in it

    Is there a way for me to sort and graph my data to only include families with 2 or more Televisions? 

    ClusteredTable4 ClusteredTable4
    Discussions |
    Nov 11, 2022 6:07 PM
    1580 views | 3 replies

  • Opening a specific date range from SQL tables

    I open a lot of tables from SQL and I would like to be able to open just the previous 7 days. So when I run the script I want it to look at the date/time column on the sql table and open only the data for the previous 7 days.  Here is my open table script:
    Open Database(
    "DSN=0.20;UID=****=****;APP=JMP;WSID=VJDSTATION;DATABASE=BioControl;",
    "SELECT * FROM dbo.VisitLog", "VisitLog"
    ); The column I want...

    JocelynJohnson JocelynJohnson
    Discussions |
    Nov 11, 2022 1:29 PM
    1603 views | 1 replies

  • Regex Issure with Decimals and Whole Numbers

    Hello! Using JMP 16.2: I have a column with whole numbers and decimal numbers. I want to create a new column that flags the whole numbers (or the decimals).  Column Name: ValueColumn Inputs:0.533.76810etc. I have tried several versions of the following Regex using a column formula:Regex(Value,"\d+\,\d+", "Decimal")Regex(Char(Value),"\d+\,\d+", "Decimal")I have also tried parentheses and brackets t...

    Maerawlings Maerawlings
    Discussions |
    Nov 11, 2022 10:11 AM
    2307 views | 3 replies

Latest Discussions

  • Linear mixed model not showing "Random Effect" noise in simulator/monte carlo

    I have fit a Mixed Model via the Fit Model platform in JMP Pro. When opening up the 'Prediction Profiler', and inspecting the Profiler itself, I can see the as expected predicted response and its as expected confidence interval in [], which reflects the variation due to the Random Effects I have fit.  However, when I run the 'Simulator' with equal experimental variables as above, and after adding ...

    Vartian Vartian
    Discussions |
    Nov 8, 2022 5:38 AM
    872 views | 0 replies

  • Monte Carlo / Simulator from Mixed Model not showing "Random Effect" noise

    I have fit a Mixed Model via the Fit Model platform in JMP Pro. When opening up the 'Prediction Profiler', and inspecting the Profiler itself, I can see the as expected predicted response and its as expected confidence interval in [], which reflects the variation due to the Random Effects I have fit. However, when I run the 'Simulator' with equal experimental variables as above, and after adding n...

    Vartian Vartian
    Discussions |
    Nov 4, 2022 12:48 PM
    680 views | 0 replies

  • How do I save plots/images at a specific size when they are generated in a project?

    Hi,when I generate images within a project the window size attribute is ignored (the plot is always maximized). How do I prevent this to define a specific image size, esp. when the plots are saved? Best regards,Ole @martindemel   

    OHS OHS
    Discussions |
    Nov 4, 2022 6:53 AM
    695 views | 0 replies

  • JMP 17 Trial - windows server not supported

    Dear members of the forum, I have just came across this issue during an attempt to install JMP 17 trial version on a windows server. Any ideas?         Edit: I contacted JMP support and they confirm that the trial version will not work on windows server.

    ron_horne ron_horne
    Discussions |
    Nov 1, 2022 2:20 PM
    1206 views | 0 replies

  • How to run JSL script in user opened JMP session instead creating a new seesion by JMP.dll?

    Currently I developed a windows application based on Interop.JMP.dll. The application contains a functionality to generate JSL file and run it in JMP but I got a issue now. It seems can only create a new session and run it by application instead of using the session that user opened first. I'd like to confirm whether it's possible to run JSL in the session by user opened manually. Appreciate it if...

    SquaresDingo505 SquaresDingo505
    Discussions |
    Oct 24, 2022 7:23 PM
    742 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