Welcome to the JMP User Community!

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

  Discussions |

  Sep 14, 2022 6:44 AM

  1324 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

  Discussions |

  Sep 13, 2022 7:54 PM

  1887 views | 4 replies

• Delete columns with for loop

  Hi, I create a for loop script to delete empty column (column contains only N/A).It works ok except on one file, one column get deleted when it's not suppose to.Not sure what's wrong for (i= ncols (dt[d]),i>=1,i--, summarize(data table(dt[d]),temp = by(column(i))); if(nitems(temp) ==1 & temp[1]=="N/A", data table(dt[d])<< delete columns(column(i)); ); );
  
  

  yanee

  Discussions |

  Sep 13, 2022 11:59 AM

  1553 views | 1 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

  Discussions |

  Sep 13, 2022 11:23 AM

  2183 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

  Discussions |

  Sep 13, 2022 6:43 AM

  741 views | 0 replies