cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
JMP Bar Chart

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users

Learning Resources

Latest Discussions

  • Scripting: open all sheets from an Excel file

    What is the syntax to open all sheets from an excel file without naming all the sheets? This is the script log I got after clicking "Select all" in Excel Wizard. The specific excel file had 2 sheets name "Sheet1" and "Sheet2".Worksheets( {"Sheet1", "Sheet2"} ),I could not find help from Scripting Index either Open( excelFilePath, <Worksheets( "sheet name" | {"sheet name", "sheet name", ...} |...

    GroupSquareWolf GroupSquareWolf
    Discussions |
    Oct 3, 2022 10:50 AM
    1551 views | 1 replies
  • Self-reference in the hot-spot script ("Set Menu Script"). Is it possible?

    Hi, is self-reference possible in the hot-spot commands ("<< Set Menu Script"), similar to "<<Set Function".E.g., in the example below I'd like to have a hot-spot commands instead of the buttons: Names Default To Here( 1 ); names = {"AAAA", "BBBB", "CCCC", "DDDD"}; New Window( "Example", For( i = 1, i <= N Items( names ), i++, <<append( Outline Box( names[i], Button Box( "Show my name", <<...

    AlterEgo AlterEgo
    Discussions |
    Oct 2, 2022 4:05 AM
    1839 views | 2 replies
  • Making exact clone of a column

    HI JMP users, am looking for your help to make identical clone of a column through JMP scipt.I don't want to select the "Date" column to make a identical column instead script should be able to recognize "Date" column and make a clone column. Regards 

    chandankishor66 chandankishor66
    Discussions |
    Sep 30, 2022 1:21 PM
    1257 views | 2 replies
  • setting spec limit to column property by JSL - lines not shown on plot

    Hi I have a script that assigns spec limits (USL/LSL) to columns property, and then make a plot of the column, and I expect
    to see the limits lines drawn on the plot. What happens is that the limits are set correctly in the table, but not visible on the plot.If I draw the same plot to this column manually after running the script - no lines again.If I open the column spec property window, I see the...

    shlomi_bakish shlomi_bakish
    Discussions |
    Sep 28, 2022 3:29 PM
    6666 views | 11 replies
  • update table using JSL without adding missing columns

    I'm trying to update the values of a specific column in a data table using values in another data table. The update function seems like the logical choice but it always seems to add extra unmatched columns to the updated table. From the update utility there is an option for this However there isn't any mention of this in either the scripting index or in the help search. I've tried     dt << upda...

    tom_e_dunn tom_e_dunn
    Discussions |
    Sep 27, 2022 2:04 PM
    16552 views | 3 replies

Latest Discussions

  • Collapsing Table Variables/Scripts from Data Box

    Is there a way to collapse Table Variables/Scripts from Data Box / change height of Columns list to hide it? Or is there any other way of getting column listing from data table with same functionalities?  What I have: What I would like to have:   Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp", invisible); New Window("Big Class", H List Box( lb = List Box(dt << Get Column Na...

    jthi jthi
    Discussions |
    Sep 14, 2022 6:44 AM
    1276 views | 2 replies
  • Is Missing command- Scrippting

    In this example, ;"Sum of A+B+C" calculates sum of :A + :B + :C in each row with this formula: If( Is Missing( :A ), 0, :A ) + If( Is Missing( :B ), 0, :B ) + If( Is Missing( :C ), 0, :C )If I change the specific column names to with column number, the script is not working anymore and generates an error If( Is Missing( Column( 1 ) ), 0, Column( 1 ) ) + If( Is Missing( Column( 2 ) ), 0, Column( 2 ...

    GroupSquareWolf GroupSquareWolf
    Discussions |
    Sep 13, 2022 7:54 PM
    1844 views | 4 replies
  • dynamic Y variable for oneway analysis

    Hi everybody, I am trying to script a dynamic Y variable for oneway analysis, then output the mean into a combined table. Is this a correct way to do so ?dt = Data Table ("Analysis"); ColNamesList = d1 << get column names (string ); For( i = N Items( ColNamesList ), i >= 1, i--, OW = (dt << Oneway( Y( Column(ColNamesList) ), X(:SITE), Mean ( 1 ), Automatic Recalc( 0 ) )) << Report; )...

    XiangCD_MP_User XiangCD_MP_User
    Discussions |
    Sep 13, 2022 11:23 AM
    2141 views | 4 replies
  • Model classification thresholds add-in display "negative" probability

    Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...

    Agustin Agustin
    Discussions |
    Sep 13, 2022 6:43 AM
    713 views | 0 replies
  • Injecting images to text with tags to build display box

    I have a JSON which I get with GET request. The JSON contains two keys, text and imagesimages has list of objects with name of image and then the image.  In text "¤imagename|img¤" parts are to be replaced with "imagename" image found from images. Below is an example in associative array format   aa = Associative Array(); aa["text"] = "First line with no image ¤tile|img¤ text and ¤windmap|img¤ im...

    jthi jthi
    Discussions |
    Sep 9, 2022 6:20 AM
    973 views | 1 replies

Latest Discussions

  • Model classification thresholds add-in display "negative" probability

    Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...

    Agustin Agustin
    Discussions |
    Sep 13, 2022 6:43 AM
    713 views | 0 replies
  • JSL Script Creates New Taskbar Icon When Run

    Hi All, I have what seems to be an odd problem. I've created a JSL script that launches a window through which a user can select some options and then run scripts to pull data from various sources. The odd thing that is happening is that when one of these scripts is run it causes all subsequent JMP windows to open under a new taskbar icon. An example for clarity: 1) User opens jmp. There is 1 icon...

    jbakri jbakri
    Discussions |
    Aug 1, 2022 12:32 PM
    1247 views | 0 replies
  • SUR (Seemingly Unrelated Regressions)

    HI, How to find estimators of FGNLS and NLS (Seemingly Unrelated Regressions) Using JmpPro.# Note that it is present in SAS in the proc syslin
    and it is in stat in the nlsur command Regards

    Raaed Raaed
    Discussions |
    May 5, 2022 4:45 PM
    934 views | 0 replies
  • How do I apply time fixed effects with multiple regression

    I have financial panel data and would like to hold dummy time variables fixed as I regress the other independent variables to test my model's significance. Not sure how to proceed. Is this function only available in SAS? Thanks   

    RiDe RiDe
    Discussions |
    Jan 10, 2022 11:18 PM
    815 views | 0 replies
  • Projects Window List in JMP 15 for Mac -- Reorder?

    I'm trying to use JMP projects more with the promise of re-using graphs and analyses on new sets of similar data. I'm using the Window List in the UL as a kind of 'table of contents' that I can click into to see/show my findings for various analyses.  There is a flow to the findings which I'd like to order in that Window List.  Is this possible? I can't click and drag an entry for a window up or d...

    datanaut datanaut
    Discussions |
    Aug 16, 2021 6:38 AM
    720 views | 0 replies
view all discussions