Welcome to the JMP User Community!

Latest Discussions

• 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

  1539 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

  1305 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

  1825 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

  580 views | 0 replies

• I did DOE for nanoparticle synthesis to estimate size, what do I put if no synthesis occurred? / Hice DOE para síntesis de NPs, ¿Qué pongo si no ocurrió síntesis?

  I elaborated a 2^4 factorial design, in some conditions NPs were not formed and I have doubts about how to put this information: with 9 or eliminate the data./Elabore un diseño factorial 2^4 y en algunas condiciones no existió la formación de NPs y tengo duda de como poner esta información en JMP si con 0 o eliminar las condiciones.

  OlyUASLP

  Discussions |

  Sep 13, 2022 1:49 AM

  989 views | 1 replies