Welcome to the JMP User Community!

Latest Discussions

• How do I conditionally setting cells in a column to missing values

  After hours of Internet searching, there does not appear to be a clear answer on how to accomplsh what I want to do and, after a number coding attempts, this is clearly one of those areas where JSL differs dramatically from other programming languages. I have CSV files that are used as databases in a custom VBA program for a client. The reason for using CSV files was largely due to making it easy ...

  mdawson69

  Discussions |

  Mar 2, 2017 11:26 AM

  11706 views | 5 replies

• JSL question: select columns and replace missing values with zero

  Hi,  There are many numeric columns in the data table, and all of them have missing values in them. I want to select only few of them (considering that I know the column names already), and replace the missing values in them with zero.I wrote the code as follows, but it doesn't work. Could you help? Thanks! dt = data table("Untitled 9"); col_list = {"A","B"}; For( i = 1, i <= N Items( col_list ), ...

  pomemelom

  Discussions |

  Mar 1, 2017 1:53 PM

  10215 views | 4 replies

• JSL - showing spec limits as graph reference lines (JMP 12)

  I have recently updated to JMP 12.1 and was trying to port over an old script to set the spec limit property (see below). It works fine in JMP 11, but now that I'm running JMP 12.1, the code in red doesn't work. It doesn't error out, it just doesn't toggle the option for showing specs as graph reference lines. Has anyone found a solution to this?M JMP 11 code that worked but doesn't work with 12.1...

  mohamed_elhassa

  Discussions |

  Mar 1, 2017 9:36 AM

  11625 views | 3 replies

• Predictive Modeling with asymmetric cost / imbalanced data set

  Hello, How can I instruct predictive modeling platforms on JMP Pro (partition, random forests etc.) to assign a higher cost to falsely predicting the minority class. I have a dataset that is highly imbalanced with a high cost for false negative (readmission rate of acute patients) and when I use the classifiers the AUC is low and all positive cases are falsely classified. Please help on tools avai...

  Nayimoni

  Discussions |

  Mar 1, 2017 6:13 AM

  11359 views | 10 replies

• Where is the binomial reliability calculation hiding?

  I'm doing a binary test (pass/fail) and the number of acceptable failures depends on the sample size and acceptance/confidence limits. It's a binomial reliability calculation. I can find reliability lifetimes but no basic sample size calculator that takes failures into account. MiniTab has it clearly available, and I found very simple online calculators, but I need to document the calculations in ...

  Lisa

  Discussions |

  Feb 28, 2017 4:05 PM

  5388 views | 4 replies