Welcome to the JMP User Community!

Latest Discussions

• how to change a series of numbers into time format

  Hello!  Can anybody help changing a series of numbers into time format [hh:mm:ss] here. Originally, the data type is character. So, I've tried changing the data type from character to numeric to set format as [hh:mm:ss] but I failed...I have no idea what to do now. What I'd like to see as a result is, taking an example of 000003, 00:00:03..It should not be that difficult, but I can't find a way......

  SuperBigRabbit

  Discussions |

  Sep 13, 2022 10:45 PM

  2163 views | 3 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